CODEWITHSUNDEEP
asp.netsqldatabasevisual-studiodebugging
macleojw
macleojw

Reputation: 4159

How can I view SQL Generated by Visual Studio DataSource?

I've got a data source in Visual Studio. Is there any way to view the SQL that it generates before it sends it to the database?
I don't just want to see the SelectComand, InsertCommand properties which are part of the asp:SqlDataSource, I want to see the query once the parameters have been filled. Is it possible to do this from Visual Studio?

Upvotes: 0

Views: 274

Answers (2)

macleojw
macleojw

Reputation: 4159

It doesn't seem to be possible. See the other answer for a possible work around.

Upvotes: 0

Viktor Jevdokimov
Viktor Jevdokimov

Reputation: 1056

Don't know the answer, but for such debugging I use SQL profiler.

Edit: For the Oracle, check TKPROF tool. Documentation is here.

You might also need to

alter session set events '10046 TRACE NAME CONTEXT FOREVER, LEVEL 12';

Upvotes: 2

Related Questions