Tuesday, February 14, 2012

ASP.Net(Custom Paging In GridView With C#.Net)


//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)
    {
        grdCity.PageIndex = e.NewPageIndex;
        grdCity.DataSource = bindgrid();
        grdCity.DataBind();
        grdCity.HeaderRow.Visible = true;
        grdCity.BottomPagerRow.Font.Underline = true;
    }

1 comment: