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

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 breakpo开发者_如何学Goint to code on the onBinding event of the SqlDataSource)

Thanks for any help

Ryan

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.

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