using session variable in aspx page in sql query
<p>I have the sqldatasource in aspx page and in the query I want to use one parameter i.e. coming from session.</p>

<p>Below is my  code.Please help me out.</p>

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