//Step01: Create DataView Object
DataView dv = new
DataView();
//Step02: Create Method To Show The
Data Into The Grid
private DataView
bindgrid()
{
strQuery = "SELECT a.* FROM <table_name>
a";
layer
= new DALayer();
ds = new DataSet();
ds =
layer.FetchRecords(strQuery, ref strError);
if (ViewState["sortExpr"]
!= null)
{
dv = new DataView(ds.Tables[0]);
dv.Sort = (string)ViewState["sortExpr"];
}
else
{
dv = ds.Tables[0].DefaultView;
}
return dv;
}
//Step03: Write Into Page Index
Changing Event Of The Grid
protected void grdCity_PageIndexChanging(object sender, GridViewPageEventArgs e)
protected void grdCity_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
grdCity.PageIndex = e.NewPageIndex;
grdCity.DataSource = bindgrid();
grdCity.DataBind();
grdCity.HeaderRow.Visible = true;
grdCity.BottomPagerRow.Font.Underline = true;
}
C# custom GridView paging
ReplyDelete