Multi-part keys FindItemByKeyValue

[Bill]

Hi, I'm using your example from http://demos.telerik.com/aspnet-ajax/grid/examples/dataediting/clienteditbatchupdates/defaultcs.aspx.  Everything works great except the update and I've spent too long trying to get it to work.

I have a 3 part column key (DataKeyNames="Col1,Col2,Col3").  In the RadAjaxManager_AjaxRequest I'm passing back the values of the keys, but what is the proper syntax (or method) to retrieve the GridDataItem object. 

RadGrid1.MasterTableView.FindItemByKeyValue(keyname, keyvalue); ????

Thanks.

[Bill]

Can anyone help with this?

[Vasil]

Hello Bill,

You could find the item by any of the three key values and it will be the same item.
GridDataItem updatedItem = RadGrid1.MasterTableView.FindItemByKeyValue("Col1", com1value);

Just have to make sure that you have not changed the value of the field by which you are looking for.
For example:
You have Col1, Col2, and Col3. You can change the text in the second column and then use Col1 or Col3 to access the original data item.

If you set DataKeyNames="ProductID,ProductName" in the code of the online demo, the same code-behind will still be valid and the update function will works.

All the best,
Vasil
the Telerik team

[Bill]

Thanks for the response, but i'm still somewhat confused.

What if i had the following data with the datakeynames="Col1,Col2"

Col1        Col2                    Col3
widget1    subwidget1         mycolumndata
widget1    subwidget1.1      **changeddata**
widget2    subwidget2         morecolumndata

So the user has modified the second row (Col1=widget1; Col2=subwidget1.1).  If I find item the griddataitem by using RadGrid1.MasterTableView.FindItemByKeyValue("Col1", widget1) it will return the first row - which is wrong.  This was the reason for my first question, how to i retrieve a griddataitem when the uniqueness is by more than just one column?

Thanks..Bill

[Vasil]

Hi Bill,

You could use FindItemsByKeyValues function and pass dictionary with all data key values.

Hashtable dictionary = new Hashtable();
dictionary.Add("Col1", "widget1");
dictionary.Add("Col2", "subwidget1.1");
GridDataItem[] items = grid.MasterTableView.FindItemsByKeyValues(dictionary);

Greetings,
Vasil
the Telerik team