Grid view sorting and paging after performing search

Ganesh babu

I am performing a search operation in GridView and getting results as expected, but after getting results, if I sort them or click on pagination, the page getting reloaded and sorting and pagination happening for the whole grid. I want sorting and paging should only work for search results which I have got.

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bindgrid();
}
}
protected void bindgrid()
{
ViewState["sortexp"] = "";
ViewState["orderby"] = "ASC";
Sort("");
int iTotalRecords = ((DataTable)(GridView1.DataSource)).Rows.Count;
lbldisplay.Text = "Total Products: " + iTotalRecords.ToString();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
GridView1.DataBind();
bindgrid();
}
public void Sort(string sortexp)
{
DataTable dt = (DataTable)bll.LoadProduct();
DataView DV = dt.DefaultView;if (sortexp != "")
{
DV.Sort = sortexp;
}
GridView1.DataSource = DV;
GridView1.DataBind();
}
protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
{
if (ViewState["orderby"].ToString() == "ASC")
{
ViewState["orderby"] = "DESC";
ViewState["sortexp"] = e.SortExpression + " " + " DESC";
}else
{
ViewState["orderby"] = "ASC";
ViewState["sortexp"] = e.SortExpression + " " + " ASC";
}
Sort(ViewState["sortexp"].ToString());
}

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Kumar7y ago
Hi, This is happen because first page load you bind your gridvgridview from database right, but you search any Value in whole gridview data and filter whole gridview and bind it. But when you click on paging or sorting your whole data data bind again. Solution is that for every search go to datbase and search it on database table return your search result. Then bind it sure your problem will remove or you can use jQuery search help it from my article. https://www.dotnettechpoint.com/2018/02/search-data-from-html-table-using-jquery.html?m=1
0
Ganesh babu7y ago
Hi Arif, thanx for the reply but I don't know jquery.Anyways issue got resloved.Tank u guys for ur response.
0
Mohsin Arif7y ago
hi
there is some suggestion if you have limited data like arround 1000 so why not you use the jquery datatable its so fast and provide the pagination,sorting as well as exporting option instead of doing so many code try this
https://datatables.net/
its so simple and so fast. instead of sending request again and again to the server or making viewstate.
try this its so cool
+1
Ganesh babu7y ago
Hi Rupesh,
I am little bit confused, could u pls explain a more in detail or just provide a sample code
0
Rupesh Kahane7y ago
you can do below things..
1) while showing into a grid show only 10 / 20 records. Pagination should be as it is.
2) So while sorting / filter it will filter only records which contains grid i.e. 10 / 20

Or

1) while shwoing records on grid do Order by some columns with Top 10 / 20 records. So while sorting / filter use that only Top 10 / 20 records.
0