DataAdapter.Update() failure

[Max Sandman]

My update is failing on the insert. I've got the call inside a try/catch
but the message is too crytic and I can't find the actual sql that is
being called on my behalf. Where and how can I get into the code that
is actually doing the update? All I can do is guess at what is wrong and
it's extremely frustrating. There have to be some better debugging
tools for these DataAdapter/DataSet classes.

sandman

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Nicholas Paldino [.NET/C# MVP]]

Max,

Can you post the exception details?

Also, you can see the insert statement by looking at the InsertCommand
property of the SqlDataAdapter instance you have. Once you have that, you
can check the CommandText property of the SqlCommand instance to get the
statement that is being executed.

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- ni**************@exisconsulting.com

"Max Sandman" <sa*********@yahoo.com> wrote in message
news:OH**************@TK2MSFTNGP10.phx.gbl...

My update is failing on the insert. I've got the call inside a try/catch
but the message is too crytic and I can't find the actual sql that is
being called on my behalf. Where and how can I get into the code that
is actually doing the update? All I can do is guess at what is wrong and
it's extremely frustrating. There have to be some better debugging
tools for these DataAdapter/DataSet classes.

sandman

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Carl Fenley]

Off the top of my head, your problem could be that you don't have a
CommandBuilder object or a Command object for your insert. A snippet of
code that is giving you problems would be very helpful.

- Carl

"Max Sandman" <sa*********@yahoo.com> wrote in message
news:OH**************@TK2MSFTNGP10.phx.gbl...

My update is failing on the insert. I've got the call inside a try/catch
but the message is too crytic and I can't find the actual sql that is
being called on my behalf. Where and how can I get into the code that
is actually doing the update? All I can do is guess at what is wrong and
it's extremely frustrating. There have to be some better debugging
tools for these DataAdapter/DataSet classes.

sandman

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!