Getting the parameter values being passed to SQL database via SQLDataSource control

Question

I am debugging code written by a previous developer :-)

I have a SQLDataSource control that is calling a database stored procedure, and passing quite a large number of paramaters, and the stored proc returns records that populates a gridview control.

When I walk through the code behind to determine the values being passed, is there any way that I can see exactly how the parameters are being formated and passed to the stored proc?

Ronald Wildenberg · Accepted Answer · 2010-09-01 13:03:33Z

1

You can use SqlDataSource's Updating event for this. It's parameter SqlDataSourceCommandEventArgs has a property Command that contains the parameters for the query.

answered Sep 1, 2010 at 13:03

Ronald Wildenberg

32.3k17 gold badges95 silver badges133 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mike Brind · Accepted Answer · 2010-09-01 13:17:19Z

1

Instead of trying to unpick them from Code-behind, use Sql Profiler. If you are using the Express version, there's a Profiler for that too: AnjLab Sql Profiler

answered Sep 1, 2010 at 13:17

Mike Brind

30.3k6 gold badges65 silver badges95 bronze badges

1 Comment

user279521 Over a year ago

I am aware of SQL profiler, but not sure how to configure it. I tried looking around on the web, finally gave up. Got any tips regarding profiler? BTW, using the enterprise version of SQL 2005.

Collectives™ on Stack Overflow

Getting the parameter values being passed to SQL database via SQLDataSource control

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related