We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
RIDWAN,
By default, our SfDataGrid’s View filters is not supported when the DataSource is DataTable. We have already documented this as a limitation as shown below,
However,
you can achieve your requirement to filter the SfDataGrid’s records by comparing
the two column values with the DataTable bounded grid by using ExpandoObject shown
below,
ExpandoObject:
|
private DataTable dataTableCollection; private ObservableCollection<dynamic> dynamicCollection; public Form1() { InitializeComponent(); this.WindowState = FormWindowState.Maximized; //Gets the data for DataTable object. dataTableCollection = GetGridData();
//Convert DataTable collection as Dyanamic collection. dynamicCollection = new ObservableCollection<dynamic>(); foreach (System.Data.DataRow row in dataTableCollection.Rows) { dynamic dyn = new ExpandoObject(); dynamicCollection.Add(dyn); foreach (DataColumn column in dataTableCollection.Columns) { var dic = (IDictionary<string, object>)dyn; dic[column.ColumnName] = row[column]; } }
DynamicOrders = dynamicCollection; sfDataGrid1.AutoGenerateColumns = true; sfDataGrid1.DataSource = DynamicOrders; }
private ObservableCollection<dynamic> _dynamicOrders;
/// <summary> /// Gets or sets the dynamic orders. /// </summary> /// <value>The dynamic orders.</value> public ObservableCollection<dynamic> DynamicOrders { get { return _dynamicOrders; } set { _dynamicOrders = value; } }
public DataTable DataTableCollection { get { return dataTableCollection; } set { dataTableCollection = value; } } |
Filtering Concept:
|
public bool FilterRecords(object o) { var emplyeeAge = ((ExpandoObject)o).FirstOrDefault(z => z.Key == "EmployeeAge").Value; var memmbersCount = ((ExpandoObject)o).FirstOrDefault(z => z.Key == "MemmbersCount").Value; if (emplyeeAge != null && memmbersCount != null) { if (double.Parse(emplyeeAge.ToString()) < (double.Parse(memmbersCount.ToString()))) return true; } return false; }
private void FilterClick(object sender, System.EventArgs e) { sfDataGrid1.View.Filter = FilterRecords; sfDataGrid1.View.RefreshFilter(); } |
Here
we have modified the attached sample as you requested. Please have a look at this.
If this post is helpful, please consider Accepting it as the solution so that other members can locate it more quickly.
