[Solved] BeginInsert method not working well with filtering

[Michael Hassinger]

I have a grid where the user adds an item via a context menu choice of "Add New Item." When they click this, I call the grid's BeginInsert method, which creates a new row at the bottom of the grid and allows them to start inputting values.

This works fine until I have filtered on two or more columns.  The grid pre-filters on a column called "status," and if I filter on the column called "assigned to" and then call BeginInsert, the new row isn't visible - I assume because the filtering options are hiding it.

We want to keep the "Excel" feel to the grid and keep input on the grid itself without DataForms and what not.  What's the best way to go about this?

[Nedyalko Nikolov]

Hello Michael Hassinger,

Indeed you are right, since that row didn't pass the filter it is not shown. You have 2 options:

1. You could set RadGridView.ShowInsertRow property to true, that way you will add new item in a separate UI that do not care about the filter. (Recommended approach)

2. Another option is to handle RadGridView.AddingNewDataItem event and provide e.NewObject which passes current filter.

Best wishes,
Nedyalko Nikolov
the Telerik team