<%@ Page Language="C#" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <script runat="server"> void Page_Load() { Session["ProductCategoryName"] = "Animation"; } </script> <html xmlns="http://www.w3.org/1999/xhtml" > <head id="Head1" runat="server"> <title>Show SessionParameter</title> </head> <body> <form id="form1" runat="server"> <div> <asp:GridView id="grdProducts" DataSourceID="srcProducts" Runat="server" /> <asp:SqlDataSource id="srcProducts" SelectCommand="SELECT Name As Category,Title,Director FROM Products INNER JOIN ProductCategories ON CategoryId = ProductCategories.id WHERE Name=@Name" ConnectionString="<%$ ConnectionStrings:Products %>" Runat="server"> <SelectParameters> <asp:SessionParameter Name="Name" SessionField="ProductCategoryName" /> </SelectParameters> </asp:SqlDataSource> </div> </form> </body> </html> File: Web.config <configuration> <connectionStrings> <add name="Products" connectionString="Data Source=.\SQLEXPRESS; AttachDbFilename=|DataDirectory|MyDatabase.mdf;Integrated Security=True;User Instance=True" /> </connectionStrings> </configuration>