DataAdapter.Update( )

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way to see the final SQL that gets executed by the Update( )
method. I'm getting a syntax error for the SQL, but all looks OK as far as I
can see. I need to see the SQL with all the parameters replaced.

Connecting to a MS Access database.

Thanks,
Tom Costanza
 
Tom,

Mostly is putting the update in a try and catch block much easier and than
show the exception.

If you tell what you are using VB, C# etc, than it is even possible to give
a sample for that.

I hope this helps,

Cor
 
Well, you should be creating that code yourself.

If you want to see what was generated, just look in your code behind - it's
all there.
 
Scott

Now I am using an answer from which I had to think about what you would have
written and than you write something else.

:-)

Cor
 
If you set your Update CommandText into a variable, you can then check that
variable value, just prior to executing your command, by setting a
breakpoint on it and looking at the populated commandText stored in the
variable.
 
Back
Top