Friday, October 22, 2010
Pagging In asp.net c#
In ASPX Page:
PageSize="5" AutoGenerateColumns="false" EmptyDataText="No Result Found" Width="100%"
OnRowCommand="gvVendor_RowCommand" OnSorting="grdView_OnSorting" OnRowDataBound="gvResults_RowDataBound"
CellPadding="4" AllowPaging="true" OnPageIndexChanging="gridView_PageIndexChanging">
Incode Behind :
protected void gridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
gvVendor.PageIndex = e.NewPageIndex;
gvVendor.DataSource = Binddata();
gvVendor.DataBind();
gvVendor.PageSize = 10;
}
Sorting GridView Columns Manually in Asp.net and c#
private const string ASCENDING = " ASC";
private const string DESCENDING = " DESC";
private const string DESCENDING = " DESC";
public SortDirection GridViewSortDirection
{
get
{
if (ViewState["sortDirection"] == null)
ViewState["sortDirection"] = SortDirection.Ascending;
return (SortDirection) ViewState["sortDirection"];
}
set { ViewState["sortDirection"] = value; }
}
protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
{
string sortExpression = e.SortExpression;
if (GridViewSortDirection == SortDirection.Ascending)
{
GridViewSortDirection = SortDirection.Descending;
SortGridView(sortExpression, DESCENDING);
}
else
{
GridViewSortDirection = SortDirection.Ascending;
SortGridView(sortExpression, ASCENDING);
}
}
private void SortGridView(string sortExpression,string direction)
{
// You can cache the DataTable for improving performance
DataTable dt = GetData().Tables[0];
DataView dv = new DataView(dt);
dv.Sort = sortExpression + direction;
GridView1.DataSource = dv;
GridView1.DataBind();
}