I have a gridview which consists of columns with different datatypes..
I have provided type and search functionality...
Whenever user types his criteria values of all columns are checked and appropriate rows are filtered..
It works fine with varchar... But has some problems with int,float...
I am using dv.RowFilter....
criteria = ViewState["Criteria"].ToString();
string selected = dropdownCriteria.SelectedValue;
string textEntered = searchBox.Value.ToString();
DataSet ds = new DataSet();
ds = (DataSet)ViewState["InitialData"];
DataView dv = new DataView();
dv = ds.Tables[0].DefaultView;
dv.RowFilter = selected + " like '" + textEntered + "%'";
reportGrid.DataSource = dv;
reportGrid.DataBind();
reportGrid.AllowPaging = false;
reportGrid.AllowSorting = false;
reportGrid.AutoGenerateDeleteButton = false;
reportGrid.AutoGenerateEditButton = false;
panelGrid.Update();
DataTable dt = new DataTable();
dt = dv.ToTable();
DataSet tempDS = new DataSet();
tempDS.Tables.Add(dt);
reportGrid.AllowPaging = true;
reportGrid.AllowSorting = true;
reportGrid.AutoGenerateDeleteButton = true;
reportGrid.AutoGenerateEditButton = true;
ViewState["CurrData"] = tempDS;