using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using Utilities;

using System.Data;

namespace GridViews

{

public partial class GridViewExample11 : System.Web.UI.Page

{

DBConnect objDB = new DBConnect();

DataSet myDS;

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

String strSQL = "SELECT * FROM Product";

myDS = objDB.GetDataSet(strSQL);

gvProducts.DataSource = myDS;

gvProducts.DataBind();

Session["theDataSet"] = myDS;

}

}

protected void gvProducts_PageIndexChanging(Object sender, System.Web.UI.WebControls.GridViewPageEventArgs e)

{

// Set the GridView to display the correct page

gvProducts.PageIndex = e.NewPageIndex;

myDS = (DataSet)Session["theDataSet"];

gvProducts.DataSource = myDS;

gvProducts.DataBind();

}

}

}