Datagrid filter bindingsource

[Rodolpho]

Hi. Sorry my english!!!

I use a report system that uses a BindingSource as source of the repot.

How to filter the bindingsource with the same filtered data in datagrid???

I used the ComponentOne C1TrueDBgrid that does it automatically.

When I filter datagrid (C1) data with the filterbar, the filtered rows show in datagrid are same bindingsource. Understand??? kkk (My english is terrible)

How to do this with Telerik datagrid?

Winform.

[Rodolpho]

?????

[Dess | Tech Support Engineer, Principal]

Hello Rodolpho,

Thank you for writing.

RadGridView filters only the displayed data in the collection view. The actual data source remains unchanged. That is why when you filter the RadGridView, the grid data is displayed filtered, but its data source, which is a BindingSource is not filtered. However, you can synchronize the data, filtering the BindingSource via its Filter property as follows:

private void Form1_Load(object sender, EventArgs e)
{
    this.customersTableAdapter.Fill(this.northwindDataSet.Customers);
    this.radGridView1.DataSource = this.customersBindingSource;
    this.radGridView1.FilterExpressionChanged+=radGridView1_FilterExpressionChanged;
}

private void radGridView1_FilterExpressionChanged(object sender, FilterExpressionChangedEventArgs e)
{
    this.customersBindingSource.Filter = e.FilterExpression;
}

I hope this information helps. Should you have further questions, I would be glad to help.

Regards,
Desislava
Telerik