How can I get the values of SqlDataSource SelectParameters?

Question

I need to debug some code involving SqlDataSource SelectParameters, and I would like to get the value of these parameters, but so far I'm only able to get the name of the parameters.

Dim debug As String = "Parameter 1: " & SqlDataSource1.SelectParameters.Item(0).ToString() & "<br />" & _
        "Parameter 2: " & SqlDataSource1.SelectParameters.Item(1).ToString() & "<br />" & _
        "Parameter 3: " & SqlDataSource1.SelectParameters.Item(2).ToString() & "<br />" & _
        "Parameter 4: " & SqlDataSource1.SelectParameters.Item(3).ToString() & "<br />" & _
        "Parameter 5: " & SqlDataSource1.SelectParameters.Item(4).ToString() & "<br />" & _
        "Parameter 6: " & SqlDataSource1.SelectParameters.Item(5).ToString() & "<br />" & _
        "Parameter 7: " & SqlDataSource1.SelectParameters.Item(6).ToString() & "<br />" & _
        "Parameter 8: " & SqlDataSource1.SelectParameters.Item(7).ToString() & "<br />" & _
        "Parameter 9: " & SqlDataSource1.SelectParameters.Item(8).ToString() & "<br />"

    Label3.Text = debug

Output:

Parameter 1: institution
Parameter 2: type
Parameter 3: skoleaar
Parameter 4: termin
Parameter 5: fag
Parameter 6: niveau
Parameter 7: tid
Parameter 8: fritekst
Parameter 9: orderby

That's the name of the parameters, where I need the values.

Is this possible?

Richard Deeming · Accepted Answer · 2013-06-11 19:16:28Z

2

If you handle the Selecting event of the SqlDataSourceControl, the Command property of the SqlDataSourceEventArgs parameter will give you the DbCommand which is about to execute. From there, you can use the Parameters property to examine the parameters being passed to the command.

answered Jun 11, 2013 at 19:16

Richard Deeming

31.5k11 gold badges86 silver badges167 bronze badges

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

Comments

TylerH · Accepted Answer · 2019-05-23 15:07:14Z

1

I use a "stub" or debug method, as part of an event call from the asp:SqlDataSource tag:

<asp:SqlDataSource ID="dsProgram" runat="server" ConnectionString="<%$ ConnectionStrings:ATCNTV1ConnectionString %>" CancelSelectOnNullParameter="false"
    SelectCommand="<<<my select command for example>>" OnSelecting="dsProgram_Selecting">

Code Behind:

protected void dsProgram_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
{
    foreach (SqlParameter P in e.Command.Parameters)
    {
        //for debugging only
    }   
}

Then I debug into the code and watch the 'P' value and all its elements.

Works great. Once I know what's going on, I delete the method and the event call.

edited May 23, 2019 at 15:07

TylerH

21.3k84 gold badges84 silver badges121 bronze badges

answered Apr 22, 2016 at 5:09

Fandango68

4,9555 gold badges50 silver badges88 bronze badges

Collectives™ on Stack Overflow

How can I get the values of SqlDataSource SelectParameters?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related