RadGrid - Open popup to edit record on page load

[Steve]

I've got a radgrid using a modal popup edit form to edit the records. I'd like to be able to link to this page, and be able to open a specific record in edit mode (perhaps passing the id for the record in the query string).

I've found other threads mentioning doing this for the add/insert scenario. For example: http://www.telerik.com/community/forums/aspnet-ajax/grid/radgrid-open-popup-add-form-on-page-load.aspx

But I want to do this for an edit/update existing record scenario.

Thanks!
-Steve

[Genti]

Hello Steve,

Here's a sample code that will do the job.

protected void Page_Load(object sender, EventArgs e)
{

    if (Request.QueryString["id"] != null)
    {
        int id = Int32.Parse(Request.QueryString["id"]);

        var currentPage = id / RadGrid1.PageSize;

        RadGrid1.MasterTableView.CurrentPageIndex = currentPage;

        RadGrid1.EditIndexes.Add(id % RadGrid1.PageSize);
    }
}

Note, the pager is updated accordingly depending where the item is. Otherwise, the grid would be able to put in edit mode only the items that are populated in page load.


Hope this helps.

All the best,
Genti
the Telerik team

[Steve]

Correct me if I'm wrong, but this solution assumes that the ID's of the items being passed in are:
a) start's at 1, continues uninterrupted (2, 3, 4).
b) numeric (as opposed to alphanumeric)
c) the sort order is based on the ID, and ascending

For my scenario, issue "a" is the primary blocker for the given solution.

The solution would seem to work if there was another way of identifying the page and row that a given ID would be located.
Or, a work around could be to temporarily set paging to off while in edit mode, so all the records are displayed on the current page? This isn't ideal, especially for large data sets. And I'd still want to set paging on again after saving, so I'd still need to find what page the item is on to display that page after updating.

So, is there a solution that doesn't have the issues mentioned above?

Thanks,
-Steve  

[Genti]

Hi Steve,

I could not guess what your scenario was from the description that was given.
In this case you are correct, in order to use my example you should know how to map the ids to the edit indexes beforehand.

If you could not find any way, then as you said, you're going to disable paging and crawl through all the items to find the matching id and set it to edit mode. This is a candidate solution but the efficiency in this scenario would be very low(loop through all items).

Another solution would be to set the grid data source to the row that needs to be edited. This way the searching time won't be linear(suppose you have an index on the id column in the database).

Hope this helps.

Best wishes,
Genti
the Telerik team