DataAdapter Query Access

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

Guest

Hi people, i have a question about this:

I need to know how can i obtain the sql queries (Insert, Update, Delete)
that are executed by DataAdapter.Update on a DataSet. I know that i can see
that queries on SQLProfiler but i want to obtain that sentences on my
code...It's possible???

I hope you can help me...

Regards

Johny
 
You can do this by querying the DataAdapter.UpdateCommand.CommandText
property.

You can also get the:
DataAdapter.SelectCommand.CommandText
DataAdapter.DeleteCommand.CommandText
DataAdapter.InsertCommand.CommandText

Hope that helps.
David
 
Tks but i want to do another thing...Example: When i send to my server 30
rows the DataAdapter uses the InsertCommand or other to accomplish that but
that is just a template....All just that i need is the 30 queries that was
executed on my db server...It's possible???

Regards
 
Back
Top