I have a grid with a number of columns with radcombobox filter templates. I want to be able to select a filter on a column (eg Company) and then select a filter on another column (eg Part Type) and have the filter expression combine so I could see part types for a particular company only or if further filters are selected then have them added to the filter clause.
I am able to do this with one combo, but not combine the expressions.
I am able to do this with one combo, but not combine the expressions.
protected
void
cboFilterCompany_SelectedIndexChanged(
object
sender, RadComboBoxSelectedIndexChangedEventArgs e)
{
RadComboBox combo = sender
as
RadComboBox;
ViewState[
"CompanyFilterVal"
] = e.Value;
//to persist value
GridColumn column = grdParts.MasterTableView.GetColumnSafe(
"Company"
);
//if (grdParts.MasterTableView.FilterExpression != "")
//{
// //append?
//}
grdParts.MasterTableView.FilterExpression =
"([Company] = '"
+ e.Text +
"')"
;
column.CurrentFilterFunction = GridKnownFunction.EqualTo;
column.CurrentFilterValue = e.Text;
grdParts.MasterTableView.Rebind();
}