Sessions ASP.Net Tutorial

  1. Home
  2. ASP.Net Tutorial
  3. Sessions
  4. Sorting a DataView stored in Session state
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Web.Configuration" %>
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

    DataView dvProducts;
    void Page_Load()
    {
        dvProducts = (DataView)Session["Products"];
        if (dvProducts == null)
        {
            string conString = WebConfigurationManager.ConnectionStrings["Products"]. ConnectionString;
            SqlDataAdapter dad = new SqlDataAdapter("SELECT Id,Title,Director FROM Products", conString);
            DataTable dtblProducts = new DataTable();
            dad.Fill(dtblProducts);
            dvProducts = new DataView(dtblProducts);
            Session["Products"] = dvProducts;
        }
    }
    protected void grdProducts_Sorting(object sender, GridViewSortEventArgs e)
    {
        dvProducts.Sort = e.SortExpression;
    }
    void Page_PreRender()
    {
        grdProducts.DataSource = dvProducts;
        grdProducts.DataBind();
    }



    Session DataView


     
     

              id="grdProducts"
         AllowSorting="true"
         EnableViewState="false"
         OnSorting="grdProducts_Sorting"
         Runat="server" />
     
              id="lnkReload"
         Text="Reload Page"
         Runat="server" />