SqlCommandBuilder does not let me see the generated commands

[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

 

[William \(Bill\) Vaughn]

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.
__________________________________

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.