pass session variable into asp:gridview's sqldatasource select command

Question

I am currently having trouble trying to get a select command with a session variable in my asp gridview. I have been looking on here and other sites and have not really came across much. It's got to be a simple fix that i just have not came across yet. Here is my code

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ConnectionStrings:mySql_Connection %>"
                    SelectCommand =  "Select [Username], [Name] FROM UserPassword WHERE CustID = '" & session("CustID") & "'>
                </asp:SqlDataSource>

I'm not even sure if that is close to correct or not. I get the server tag is not well formed. Or invalid syntax. Can someone show how to do this. I've been stuck on this and its really bugging me.

ajp · Accepted Answer · 2012-12-26 16:39:12Z

2

You can use Session Paramter

<asp:SqlDataSource ConnectionString="<%$ConnectionStrings:mySql_Connection %>"
                SelectCommand =  "Select [Username], [Name] FROM UserPassword WHERE CustID     = @CustID>
 <SelectParameters>
  <asp:SessionParameter Name="CustID" SessionField="CustID"
   DefaultValue="0" />

 </SelectParameters>
</asp:SqlDataSource>

You can refer the below link also: http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.sessionparameter.aspx

edited Dec 26, 2012 at 16:39

answered Dec 26, 2012 at 16:31

ajp

1,4902 gold badges13 silver badges25 bronze badges

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

8 Comments

squinny Over a year ago

so what would i do sessionParameter Name = "CustID" SessionField = "CustID"? and would the select command be FROM UserPassword WHERE CustID = CustID">?

ajp Over a year ago

made some edits.. in the command give your parameter name starting with with '@'. I do so usually on code behind, but the example in MSDN article given has just a '?'

squinny Over a year ago

see i tried that before and got this same thing "Must declare the scalar variable "@CustID"."

ajp Over a year ago

can you try just a '?' as given in the MSDN article msdn.microsoft.com/en-us/library/…

ajp Over a year ago

Or this can help you blogs.msdn.com/b/spike/archive/2010/03/03/…

|

Collectives™ on Stack Overflow

pass session variable into asp:gridview's sqldatasource select command

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related