SQL From Update of DataAdapter

Stuart Dickerson

unread,

Feb 7, 2003, 1:36:34 PM2/7/03

to

How do you capture or view the SQL from the Update method of the
DataAdapter? Can you do this in the OnRowUpdating event?

Thanks,

Stuart

William (Bill) Vaughn

unread,

Feb 7, 2003, 1:49:53 PM2/7/03

to

Well, either:
1) You coded it so examine the Da.UpdateCommand.CommandText
2) The CommandBuilder created it so examine:
Cb.GetUpdateCommand.CommandText

But these are the "pre-stuffed" queries, not the query being sent to the
server. If you're working with SQL Server (or MSDE) you can simply enable
the Profiler to watch what's getting sent.

hth

--
____________________________________
Bill Vaughn
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"Stuart Dickerson" <as...@asdf.com> wrote in message
news:rtu74vo71816b5anm...@4ax.com...

Stuart Dickerson

unread,

Feb 8, 2003, 6:36:21 PM2/8/03

to

I'm working with OleDb. So are you saying that there isn't a way to
capture what is actually being sent to the database? Am I alone or
doesn't that sound like a good feature (especially when dealing with
those obnoxious multiple-step errors that reveal nothing.

William (Bill) Vaughn

unread,

Feb 8, 2003, 10:19:25 PM2/8/03

to

Well, Peter says you might be able to sniff the wire with Netmon and see
what's getting sent--for those providers that expose their SQL in some
unencrypted form.

--
____________________________________
Bill Vaughn
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"Stuart Dickerson" <as...@asdf.com> wrote in message

news:4r4b4vovtbjscfh9p...@4ax.com...