Search code examples
c#asp.netdata-bindingsqldatasource

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 breakpoint to code on the onBinding event of the SqlDataSource)

Thanks for any help

Ryan

Solution

  • 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.