CODEWITHSUNDEEP
c#asp.netdata-bindingsqldatasource
Ryan
Ryan

Reputation: 3982

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

Upvotes: 0

Views: 374

Answers (2)

Joshua Drake
Joshua Drake

Reputation: 2746

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

Upvotes: 0

BFree
BFree

Reputation: 103742

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.

Upvotes: 1

Related Questions