Click here to Skip to main content
13,350,861 members (51,227 online)
Rate this:
Please Sign up or sign in to vote.
See more:

friends I want to sort or filter the gridview on textbox text changing value using Ajax in
Posted 22-Mar-12 0:55am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 2

for sorting, sort source data table. which is more helpful


protected void gridView_Sorting(object sender, GridViewSortEventArgs e)
DataTable dataTable = gridView.DataSource as DataTable;

if (dataTable != null)
DataView dataView = new DataView(dataTable);
dataView.Sort = e.SortExpression + " " + ConvertSortDirectionToSql(e.SortDirection);

gridView.DataSource = dataView;
sameer hilal 22-Mar-12 6:08am
The code below works when columns are created explicitly as declerative >><asp:BoundField DataField="ID" HeaderText="ID" SortExpression="" />





asp:TemplateField ItemStyle-HorizontalAlign="Right" HeaderText="MyDate" SortExpression


#region GV_sort event and Sort Direction

protected void GvEvent_Sorting(object sender, GridViewSortEventArgs e)

//Retrieve the table from the session object.
DataTable dt = Session["MyDS"] as DataTable;
if (dt != null)
//Sort the data.
dt.DefaultView.Sort = e.SortExpression + " " + GetSortDirection(e.SortExpression);
GridView Gv = (GridView)sender;
Gv.DataSource = Session["MyDS"];

private string GetSortDirection(string column)
// By default, set the sort direction to ascending.
string sortDirection = "ASC";
// Retrieve the last column that was sorted.
string sortExpression = ViewState["SortExpression"] as string;
if (sortExpression != null)
// Check if the same column is being sorted.
// Otherwise, the default value can be returned.
if (sortExpression == column)
string lastDirection = ViewState["SortDirection"] as string;
if ((lastDirection != null) && (lastDirection == "ASC"))
sortDirection = "DESC";
// Save new values in ViewState.
ViewState["SortDirection"] = sortDirection;
ViewState["SortExpression"] = column;
return sortDirection;
sameer hilal 22-Mar-12 6:15am
For filtering filter using session which will hold value after postback

You have to write textbox value in session

write code where you using sql expression..


String sql="Select * From Table_Name ";

sql+= txtFirstname.text;

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web01 | 2.8.180111.1 | Last Updated 22 Mar 2012
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100