SQLDataSource - underlying SQL

1 posts, 0 answers
  1. Ken
    Ken avatar
    3 posts
    Member since:
    Nov 2007

    Posted 16 May 2012 Link to this post


    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?

Back to Top