protected void gridMain_ItemCommand(object source, GridCommandEventArgs e)
{
if (e.CommandName == RadGrid.FilterCommandName)
{
try {
filterData = new FilterData();
if (Session["FilterRecords"] != null)
{
filterData = (FilterData)Session["FilterRecords"];
}
Pair filterPair = (Pair)e.CommandArgument;
TextBox filterBox = (e.Item as GridFilteringItem)[filterPair.Second.ToString()].Controls[0] as TextBox;
string valuetxt = filterBox.Text;
if (!string.IsNullOrWhiteSpace(valuetxt))
{
filterData.AddRecord(filterPair.First.ToString(), filterPair.Second.ToString(), valuetxt);
}
else
{
filterData.RemoveRecord(filterPair.First.ToString(), filterPair.Second.ToString());
}
}
catch (Exception) { }
/*
* TextBox filterBox = (e.Item as GridFilteringItem)[filterPair.Second.ToString()].Controls[0] as TextBox;
* SqlConnection conn = new SqlConnection(connStr);
* dt = new DataTable();
* com.Connection = conn;
* com.CommandText = "SELECT * FROM tblEmployees where EmployeeID='" + filterBox.Text + "' OR FirstName='" + filterBox.Text + "' OR LastName='" + filterBox.Text + "' OR Address='" + filterBox.Text + "'";
* sqlda = new SqlDataAdapter(com);
* sqlda.Fill(dt);
* RadGrid1.DataSource = dt;
* RadGrid1.DataBind();
*/
}
}