This is a migrated thread and some comments may be shown as answers.

SQLDataSource - underlying SQL

0 Answers 47 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Ken
Top achievements
Rank 1
Ken asked on 16 May 2012, 05:45 PM

Hi,

I was wondering if there is a way to determine the underlying SQL that is sent to the database. So I have a SQLDataSource with a Slect Statement of
 Select name from User where UserId = @Userid

Is it possible to see the final statement that is sent to the database? So I would see "Select name from User where UserId = 1" ?

As in SqlDataSource.SelectStatement(); or some equivalent to this?

All I can see is the SelectCommand and SelectParameters

Would I have to put those 2 together myself?

No answers yet. Maybe you can help?

Tags
General Discussions
Asked by
Ken
Top achievements
Rank 1
Share this question
or