Unable to insert new row with ShowInsertRow

[cocowalla]

Editing existing items in the grid works fine, but when I click on 'Click here to add new item', nothing happens.

In my view model I have an IQueryable:

public IQueryable<MyModel> Data
{
  get { return this.dataService.GetData(); }
}

In the view, I have a RadGridView bound to the Data property:

<telerik:RadGridView Name="RadGridView1"
    GroupRenderMode="Flat"
    ShowInsertRow="True"
    CanUserInsertRows="True"
    CanUserFreezeColumns="False"
    ItemsSource="{Binding Data}"
    AutoGenerateColumns="False"
    SelectedItem="SelectedItem"
    ActionOnLostFocus="CommitEdit"
    RowIndicatorVisibility="Collapsed"
    ShowGroupPanel="False">

[cocowalla]

I've tried binding to a QueryableCollectionView created from the IQueryable, but get the same result

[cocowalla]

So I figured maybe I could use VirtualQueryableCollectionView, and do the paging myself in the ItemsLoading event handler, and convert the page to an IList.

...but I get the same result when binding to VirtualQueryableCollectionView, even when in the ItemsLoading event handler I pass an IList to the Load method :(

[Rossen Hristov]

Hi,

The IQueryable interface is for queries only, i.e. you can only read. If you want to perform CRUD operations, your collection needs to implement either the IList interface or IEditableCollectionView interface.

Since I am not sure where and how your data is coming from, you can check our two data source controls:

RadDataServiceDataSource
RadEntityFrameworkDataSource

You can see those controls in action in our online QSF.

Alternatively, you can edit in-memory data if you bind the grid to an ObservableCollection<T>. Creating such a collection is beyond the scope of Telerik support.

Regards,

Rossen Hristov
Telerik