How can I see the actual SQL an ASP SqlDataSource will run (after binding)

Question

This is a very simple question, but one I can't find an answer to. If I have an SqlDataSource that takes parameters, how can I see the actual SQL that will be executed against the DB after the binding takes place? (I have tried adding a breakpoint to code on the onBinding event of the SqlDataSource)

Thanks for any help

Ryan

Answer 1

You will need to use a profiling tool at the database end to get the actual SQL executed. For Sql Server you can use Sql Profiler.

Answer 2

The SqlDataSource.SelectCommand should show you the text of the command that will be executed.