ItemsSource = DataTable -> SearchPanel System.ArgumentException

[Philipp]

Hello,

if i bind a DataTable to a RadGridView.ItemsSource and try to search with SearchPanel, i'm getting a System.ArgumentException error.

Column 'xy' does not belong to table xy.

Can you help me please? Thanks.

 

<telerik:RadGridView ItemsSource="{Binding Table}" ShowSearchPanel="True"/>

 

private DataTable _table;

public DataTable Table
{
    get { return _table; }
    set
    {
        if (Equals(value, _table)) return;
        _table = value;
        OnPropertyChanged(nameof(Table));
    }
}


public ViewModel()
{
    Table = new DataTable("Test");
    Table.Columns.Add("Spalte 1");
    Table.Columns.Add("Spalte 2");
    Table.Columns.Add("Spalte 3");

    for (var i = 0; i < 50; i++)
    {
        var row = Table.NewRow();
        row.ItemArray = new object[] { "Cell 1 " + i, "Cell 2 " + i, "Cell 3 " + i };
        Table.Rows.Add(row);
    }
}

[Maya]

Hi Philipp,

Indeed, you are absolutely right. I managed to reproduce the issue quite easily thanks to the snippets you provided. We will investigate the case further. In the meantime, could you try working with DefaultView instead? For example:

<telerik:RadGridView ItemsSource="{Binding Table.DefaultView}" ShowSearchPanel="True"/>

Will that approach meet your requirements?

Regards,
Maya
Telerik

[Philipp]

Hi Maya,

thank you for reply. DefaultView works for me!

Regards,
Philipp