[Solved] AllowAddNewRow when bound to LINQ datasource

[Tor Sigve Taksdal]

private Unit u = new Unit();

u.setUnitContext();
IObjectScope context = u.context;

var q =  from d in context.Extent<TblUnitType>()

select new { d.UnitType, d.Abbreviation };

radGridView1.DataSource = q.ToList();

When setting the grid.MasterTemplate.AllowAddNewRow = true; and upong adding a new row to the grid it throws an ArgumentOutOfRangeException...  If a bind to a datatable everything works fine...

The question is how do I add a new row to the rows collection when the grid is bound to a "linq query".

Regards
Tor Sigve

[Julian Benkov]

Hello Tor Sigve Taksdal,

Thank you for your question.

The AddNew logic depends on the IList or IBindingList implementation bound to RadGridView. In your scenario the ToList() method of your query returns a read-only list which does not support adding new items to it. Please verify the IList implementation, returned from q.ToList() and if needed insert additional layer to your logic that converts all the data to a collection which implements IList and IBindingList interfaces like the DataTable class - it has support for all the CRUD operations.

I hope this information is useful.

Regards,
Julian Benkov
the Telerik team