SELECT Statement Parameter

[boysenberry]

Hi. I am trying to use an sqldatasource to query a database with parameters. I am setting the sqldatasource up in the ASP section, but want to apply the parameter in the code behind when a hyperlink is pressed in c#.

The ASP section is like this :

<asp:SqlDataSource ID="dsROP" runat="server" ConnectionString="<%$ ConnectionStrings:MyConnectionString %>"
ProviderName="<%$ ConnectionStrings:MyConnectionString.ProviderName %>"
SelectCommand="SELECT First_Name, Surname FROM tblStaff WHERE LoginId = @LoginId">
<SelectParameters><asp:Parameter Name="@LoginId" Type=Int32 /></SelectParameters>
</asp:SqlDataSource>


I am not sure how to get the value of the users login (eg 463) into the parameter in the c# code behind. I get an error Must declare the scalar variable "@LoginId with whatever I try.

I am using a SQL Server 2005 database.

ANy help would be appreciated.

Regards

[jhardman]

I'm not sure I follow. If you have a variable named LoginId that youwant to put into to query, then it goes like this:

        SelectCommand="SELECT First_Name, Surname FROM tblStaff WHERE LoginId = " & LoginId

or if loginId is a form variable, then it looks like this:

        SelectCommand="SELECT First_Name, Surname FROM tblStaff WHERE LoginId = " & request.form("LoginId")

Is this what you are asking?

Jared

[boysenberry]

I'm not sure I follow. If you have a variable named LoginId that youwant to put into to query, then it goes like this:

        SelectCommand="SELECT First_Name, Surname FROM tblStaff WHERE LoginId = " & LoginId

or if loginId is a form variable, then it looks like this:

        SelectCommand="SELECT First_Name, Surname FROM tblStaff WHERE LoginId = " & request.form("LoginId")

Is this what you are asking?

Jared

Thanks for replying. I want to declare the sqldatasource on the ASP Section of the page with a parameter (LoginId). Then at a later time, be able to apply a value to the parameter in the code behind section (c#).

I know I could do it all in the code behind, but I have read that if you set it up in the ASP bit, the paging is all handled for you.

I hope this makes it clearer to what I am trying to achieve.

Thanks and regards

[boysenberry]

Thanks for replying. I want to declare the sqldatasource on the ASP Section of the page with a parameter (LoginId). Then at a later time, be able to apply a value to the parameter in the code behind section (c#).

I know I could do it all in the code behind, but I have read that if you set it up in the ASP bit, the paging is all handled for you.

I hope this makes it clearer to what I am trying to achieve.

Thanks and regards

I have now sorted this out. The problem was not with the above, but to do with my connection string - I had a kind of hybrid between a SQL datasource and an OLEDB one.

Many thanks anyway and sorry if I wasted any time.

Regards