set the value of sql data source parameter

Question

I am filtering the data of an SQL data source by setting a WHERE clause parameter in this formatting [@a] and in the event of a combo box, I would to set the value to this parameter, the previous sql data source for a gridview

SqlDataSource2.SelectParameters.Clear();
SqlDataSource2.SelectParameters["@a"].DefaultValue = cid.ToString();
SqlDataSource2.DataBind();

I need to pass value to the WHERE parameter.

I choose the filtering parsed on non choice ( not form or control or profile or session ...)

This way gives me an error. Is there any way to give a value for this parameter [@a]?

lucidgold · Accepted Answer · 2014-06-30 16:19:20Z

Try the following:

ASPX:

<asp:SqlDataSource ID="SqlDataSource1" runat="server" DataSourceMode="DataSet" 
                   ConnectionString="<%$ConnectionStrings:MyConnectionString %>" 
                   SelectCommandType="Text"
                   SelectCommand = "SELECT * FROM TABLE WHERE a=@a"  
                   CancelSelectOnNullParameter="false"> 
        <SelectParameters>
            <asp:QueryStringParameter Name="a" QueryStringField="a" 
                           DbType="String" ConvertEmptyStringToNull="true" />
              </SelectParameters>
</asp:SqlDataSource>

C# Code-Behind:

change @a to a:

SqlDataSource2.SelectParameters.Clear();
SqlDataSource2.SelectParameters["a"].DefaultValue = cid.ToString();
SqlDataSource2.DataBind();

If @a is the FIRST parameter you can also set it using INDEX 0:

SqlDataSource2.SelectParameters.Clear();
SqlDataSource2.SelectParameters[0].DefaultValue = cid.ToString();
SqlDataSource2.DataBind();

Collectives™ on Stack Overflow

set the value of sql data source parameter

1 Answer 1

ASPX:

C# Code-Behind:

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

ASPX:

C# Code-Behind:

Comments

Your Answer

Sign up or log in

Post as a guest