SqlDataSource pass variable

Question

I am trying to pass a variable to a SelectCommand in SqlDataSource. I have this MyIdVal that need to be passed.

Here is the code :

<form id="form1" runat="server">

<div>
<%=MyIdVal%>
</div>
<asp:GridView ID="GridView1" runat="server" DataSourceID="myIdDataSource">
</asp:GridView>
<asp:SqlDataSource runat="server" ID="myIdDataSource" 
    ConnectionString="<%$  ConnectionStrings:myCipConnection  %>" 
    ProviderName="<%$ ConnectionStrings:myCipConnection.ProviderName %>"
    SelectCommand="SELECT * FROM books WHERE id = @MyIdVal" >   

    </asp:SqlDataSource>

</form>

The code works fine if I hardcode the id, so how this works?

try SelectCommand="SELECT * FROM books WHERE id = <%= MyIdVal%>" — Jodrell
– Jodrell, Commented May 22, 2012 at 15:44
it gives me this error now Conversion failed when converting the varchar value '<%=MyIdVal %>' to data type int. — Mina Gabriel
– Mina Gabriel, Commented May 22, 2012 at 15:53

Conrad Frix · Accepted Answer · 2012-05-22 15:57:19Z

3

Here's two ways to do it.

Bind the Parameter value to a control

<selectparameters>
    <asp:controlparameter 
            name="MyIdVal" 
            controlid="DropDownListBooks" 
            propertyname="SelectedValue"/>
</selectparameters>

2 . Use the SqlDataSource.Selecting Event

protected void myIdDataSource_Selecting
    (object sender, ObjectDataSourceSelectingEventArgs e)
{
    e.InputParameters["MyIdVale"] = MyIdVal;
}

answered May 22, 2012 at 15:57

Conrad Frix

52.8k13 gold badges99 silver badges158 bronze badges

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

Collectives™ on Stack Overflow

SqlDataSource pass variable

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related