Pagination, Sorting and Filtering in SPGridView

gvCRBooked.DataBind();

}

Step 5: Code for Pagination in SPGridView:

void gvCRBooked_PageIndexChanging(object sender, GridViewPageEventArgs e)

{

gvCRBooked.PageIndex = e.NewPageIndex;

gvCRBooked.DataSourceID = gridDS.ID;

gvCRBooked.DataBind();

}

Step 6: Code for Sorting in SPGridView:

void gvCRBooked_Sorting(object sender, GridViewSortEventArgs e)

{
string lastExpression = "";

if (ViewState["SortExpression"] != null)

lastExpression = ViewState["SortExpression"].ToString();

string lastDirection = "asc";

if (ViewState["SortDirection"] != null)

lastDirection = ViewState["SortDirection"].ToString();

string newDirection = string.Empty;

if (e.SortExpression == lastExpression)

{

e.SortDirection = (lastDirection == "asc") ? System.Web.UI.WebControls.SortDirection.Descending : System.Web.UI.WebControls.SortDirection.Ascending;

} newDirection = (e.SortDirection == System.Web.UI.WebControls.SortDirection.Descending) ? "desc" : "asc";

ViewState["SortExpression"] = e.SortExpression;

ViewState["SortDirection"] = newDirection;

gvCRBooked.DataBind(); //For Filter

if (ViewState["FilterExpression"] != null)

{

gridDS.FilterExpression = (string)ViewState["FilterExpression"];

}

Step 7: Code for Filtering in SPGridView:

private void gvCRBooked_Filtering(object sender, ObjectDataSourceFilteringEventArgs e)

{

ViewState["FilterExpression"] = ((ObjectDataSourceView)sender).FilterExpression;

}

Functionality

The code above explains how SPGridview actually works. The SPGridView looks up ObjectDataSource using the DataSourceID property. Once it has ObjectDataSource, it then sets the property specified in FilteredDataSourcePropertyName (FilterExpression) to be the filter. One more important point that to be kept in mind is that FilterDataFields should be in a sequence and if you don't want to add any filter to a specific column then enter a blank comma for this. For example:

"Title,,Location,FromDateTime,ToDateTime";

Conclusion

In this article we saw how to do sorting, filtering and paging in SPGridView.