I am trying to implement caching for a Datagrid. I am using
System.Data.SqlClient as I habe SQL Server 2000 in the backend. Is it
possible to do caching without having a dataset. I am also including the
sample code below. If you can give some references where a Datagrid has been
implemented with pager controls, that would be great.

class ABC
{
private void Page_Load(object sender, System.EventArgs e)
{
if (this.Page.IsPostBack == false)
{
this.PopulateGrid();
dgCategorie.AllowPaging = true;
dgCategorie.PagerStyle.Mode =
PagerMode.NumericPages;
dgCategorie.PagerStyle.PageButtonCount = 5;
dgCategorie.PageSize = 10;
dgCategorie.VirtualItemCount = 200;
}
}

private void PopulateGrid()
{
Cat_Conn.Open();
strSQL = "Select Top 10 Cat_Nom, Coul_Cat, Tmpl_Cat
" +
"From Categories";
SqlCommand selCmd = new SqlCommand(strSQL,
Cat_Conn);
dgCategorie.DataSource =
selCmd.ExecuteReader(CommandBehavior.CloseConnection);
dgCategorie.DataBind();
Cat_Conn.Close();
}
}