Hi,
I would like to log the actual sql commands that a dataadapter is executing
against the database. Currently I have been able to use the RowUpdatingEvent
in which I am able to get at the command via eventArgs.Command.CommantText
and the parameters via eventArgs.Command.Parameters but I actually looking
for an easy way to get at the actual SQL with the parameters filled in
(strings properly quoted...). Is there an easy way to achieve this?

Thanks for your help in advance!
Terry

Yes there is ---

If you're using SQL Server, run the profiler and setup a trace.
else you could see CommandText's but you are left guessing as far as the
"strings properly quoted" Sql Parameters go .. !!

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik


"TWahl" <(E-Mail Removed)> wrote in message
news:52F2B188-E021-420A-9BAA-(E-Mail Removed)...
> Hi,
> I would like to log the actual sql commands that a dataadapter is
executing
> against the database. Currently I have been able to use the
RowUpdatingEvent
> in which I am able to get at the command via eventArgs.Command.CommantText
> and the parameters via eventArgs.Command.Parameters but I actually looking
> for an easy way to get at the actual SQL with the parameters filled in
> (strings properly quoted...). Is there an easy way to achieve this?
>
> Thanks for your help in advance!
> Terry
>

What do you mean by "...strings properly quoted" ?
If you're using a Command object, ADO handles the framing quotes and any
imbedded quotes or other special characters that need worrying about. It
also frames date values for you.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
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.
__________________________________

"TWahl" <(E-Mail Removed)> wrote in message
news:52F2B188-E021-420A-9BAA-(E-Mail Removed)...
> Hi,
> I would like to log the actual sql commands that a dataadapter is
> executing
> against the database. Currently I have been able to use the
> RowUpdatingEvent
> in which I am able to get at the command via eventArgs.Command.CommantText
> and the parameters via eventArgs.Command.Parameters but I actually looking
> for an easy way to get at the actual SQL with the parameters filled in
> (strings properly quoted...). Is there an easy way to achieve this?
>
> Thanks for your help in advance!
> Terry
>

I am using Oracle and also using a Command object. My goal is that should an
update fail on the DataAdapter I would like throw an exception back to the
caller. Contained in this exception I would like to include the actual SQL
statement that failed.

Thanks in advance,
Terry


"William (Bill) Vaughn" wrote:

> What do you mean by "...strings properly quoted" ?
> If you're using a Command object, ADO handles the framing quotes and any
> imbedded quotes or other special characters that need worrying about. It
> also frames date values for you.
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> 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.
> __________________________________
>
> "TWahl" <(E-Mail Removed)> wrote in message
> news:52F2B188-E021-420A-9BAA-(E-Mail Removed)...
> > Hi,
> > I would like to log the actual sql commands that a dataadapter is
> > executing
> > against the database. Currently I have been able to use the
> > RowUpdatingEvent
> > in which I am able to get at the command via eventArgs.Command.CommantText
> > and the parameters via eventArgs.Command.Parameters but I actually looking
> > for an easy way to get at the actual SQL with the parameters filled in
> > (strings properly quoted...). Is there an easy way to achieve this?
> >
> > Thanks for your help in advance!
> > Terry
> >
>
>
>