SqlCommandBuilder does not let me see the generated commands

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

Guest

Hi

I would like to be able to examine the SqlCommands generated by SqlCommandBuilder when passed a SqlDataAdapter that has its SelectCommand property properly initialized

I want to check what is going on to see if I want changes. How can I do that from within the program? - i.e. I can envision using SQL Profiler to catch the actual SQL sent but that would be too late

Any ideas or workarounds? Maybe a setting somewhere makes these commands available to the program?

Thanks in advance
Juan Dent
 
Well, you can call methods on the CB to see the commands it generates, but
you probably don't want to use it.
See my article on the CB. http://www.betav.com/msdn_magazine.htm
--
____________________________________
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.
__________________________________

[email protected] said:
Hi,

I would like to be able to examine the SqlCommands generated by
Click to expand...
SqlCommandBuilder when passed a SqlDataAdapter that has its SelectCommand
property properly initialized.
I want to check what is going on to see if I want changes. How can I do
Click to expand...
that from within the program? - i.e. I can envision using SQL Profiler to
catch the actual SQL sent but that would be too late.
 
Back
Top