using session variable in aspx page in sql query

Question

I have the sqldatasource in aspx page and in the query I want to use one parameter i.e. coming from session.

Below is my code.Please help me out.

<asp:SqlDataSource runat="server" ID="MySQLData2"
ConnectionString='<%$ConnectionStrings:ConnectionString %>'
ProviderName="MySql.Data.MySqlClient"
SelectCommand="SELECT * FROM tablename  WHERE id="Here I want to use session variable"" />

Please edit your question title!!! does it really mean anything? — huMpty duMpty
– huMpty duMpty, Commented Jul 25, 2012 at 12:45

yogi · Accepted Answer · 2012-07-25 12:50:54Z

2

Try this

<asp:SqlDataSource runat="server" ID="MySQLData2"
    ConnectionString='<%$ConnectionStrings:ConnectionString %>'
    ProviderName="MySql.Data.MySqlClient"
    SelectCommand="SELECT * FROM tablename  WHERE id=@SessionVar">
  <SelectParameters>
     <asp:SessionParameter Name="SessionVar" SessionField="SessionVariableName" ConvertEmptyStringToNull="true" />
  </SelectParameters>
</asp:SqlDataSource>

edited Jul 25, 2012 at 12:50

answered Jul 25, 2012 at 12:42

yogi

19.6k13 gold badges67 silver badges93 bronze badges

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

3 Comments

Hinek Over a year ago

Are you sure, this will work? How does the data source associate @SessionVar with the SessionParameter?

freefaller Over a year ago

Should SessionVar and SessionVariableName be different?

Hinek Over a year ago

I think it should be Name="SessionVar" SessionField="SessionVariableName" or you just use ? like mreyeros pointed out in his answer.

mreyeros · Accepted Answer · 2012-07-25 12:41:45Z

1

This MSDN article should get you what you need. Basically you would define your SelectCommand with the parameter placeholder, "?", and then define your SelectParameters collection with an entry for your SessionParameter.

answered Jul 25, 2012 at 12:41

mreyeros

4,38923 silver badges24 bronze badges

Comments

Johnny_D · Accepted Answer · 2012-07-25 12:41:27Z

0

Using parameters is rather simple:

 <asp:SqlDataSource id="Employees" runat="server"
  ConnectionString="<%$ ConnectionStrings:Northwind%>"
  SelectCommand="SELECT LastName FROM Employees WHERE Title = @Title">
  <SelectParameters>
    <asp:ControlParameter Name="Title" 
      ControlID="DropDownList1"
      PropertyName="SelectedValue"/>
  </SelectParameters>
</asp:sqldatasource>

Just replace the value of parameter with your variable:

 <%= Sessiom[variable_name] %>

answered Jul 25, 2012 at 12:41

Johnny_D

4,6524 gold badges36 silver badges65 bronze badges

1 Comment

Amandeep Singh Over a year ago

Thanks John..But this is not working as it is giving me runtime exception that you have problem in query.My query is right as it is running fine when I am running it replacing a constant value with session variable.

Lazy · Accepted Answer · 2012-07-25 12:43:15Z

0

        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Data Source=LAZY-PC;Initial Catalog=Test;Integrated Security=True"
        ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM [C] WHERE ([C#] = @column1)">
        <SelectParameters>
            <asp:SessionParameter Name="column1" SessionField="id" Type="String" />
        </SelectParameters>
    </asp:SqlDataSource>

answered Jul 25, 2012 at 12:43

Lazy

1,4722 gold badges10 silver badges8 bronze badges

Comments

dariom · Accepted Answer · 2012-07-25 12:48:22Z

0

Johnny_D's answer is pretty much spot on, but I'd like to point out that there's a SessionParameter class that you can use for this:

<asp:SqlDataSource runat="server" ID="MySQLData2"
    ConnectionString='<%$ConnectionStrings:ConnectionString %>'
    ProviderName="MySql.Data.MySqlClient"
    SelectCommand="SELECT * FROM tablename WHERE id= ?" />
      <SelectParameters>
          <asp:SessionParameter
            Name="id"
            SessionField="SessionVariableName"
            DefaultValue="0" />
      </SelectParameters>
  </asp:SqlDataSource>

answered Jul 25, 2012 at 12:48

dariom

4,59832 silver badges43 bronze badges

Collectives™ on Stack Overflow

using session variable in aspx page in sql query

5 Answers 5

3 Comments

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

3 Comments

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related