Submit Code... Close

[DanielleVBANewbie]

Hi guys,

I am getting further with this. Below is the code I have. Right now, it is
not going to both data sources, it comes back and says no new data to submit.
Any ideas there?

Also, I need to know how to make the fail/success message appear once it
does submit?

Any help you can provide would be appreciated.

XDocument.QueryAdapter.Timeout=120;
XDocument.QueryAdapter.Submit();
XDocument.DataAdapters["MainConnection"].Submit();
XDocument.DataAdapters["Submit"].Submit();

 

[DanielleVBANewbie]

Me again,

Even closer, I have it going to both data connections now, but it comes up
an says i failed even though it didn't. I am assuming that is because I need
to put the fail/success code in. Anyone that can help with that?

XDocument.QueryAdapter.Timeout=120;
XDocument.QueryAdapter.Submit();
XDocument.DataAdapters["MainConnection"]
XDocument.DataAdapters["Submit"]
..Submit();

 

[Shiva]

Hello,

You can use ‘try’ and ‘catch’ method for failure message. If you use these
blocks then you will reach ‘catch’ when exception is occurred in your
solution.

One more way If you are try to submit using web service then it will get the
success/failure message in data fields node.

Me again,

Even closer, I have it going to both data connections now, but it comes up
an says i failed even though it didn't. I am assuming that is because I need
to put the fail/success code in. Anyone that can help with that?

XDocument.QueryAdapter.Timeout=120;
XDocument.QueryAdapter.Submit();
XDocument.DataAdapters["MainConnection"]
XDocument.DataAdapters["Submit"]
.Submit();

--
Danielle :<)

Hi guys,

I am getting further with this. Below is the code I have. Right now, it is
not going to both data sources, it comes back and says no new data to submit.
Any ideas there?

Also, I need to know how to make the fail/success message appear once it
does submit?

Any help you can provide would be appreciated.

XDocument.QueryAdapter.Timeout=120;
XDocument.QueryAdapter.Submit();
XDocument.DataAdapters["MainConnection"].Submit();
XDocument.DataAdapters["Submit"].Submit();