delPiero
2014-06-06T18:29:35Z
Hello,
I have 30,000 rows in iGrid and I would like to know whats the best way to edit the cell that contains text "5098984"
right now I can doing a loop to check every single item and if it matches "5098984" edit, but is there something faster?
Igor/10Tec
2014-06-09T08:36:15Z
Do you mean "change cell value" by "edit"? Editing is a process of changing a cell by the user, i.e. interactive action.

If you ask what is the fastest way to find the row with the required cell contents, then you can exploit row keys for that. Use the values you search by as row keys too, and then a call like iGrid.Rows["5098984"] will immediately return the required row object (iGRow). iGrid uses an optimized internal algorithm to search a row by its key (kinda binary search) - that's why this will work much faster than enumerating rows.
delPiero
2014-06-09T14:06:12Z
yes I am looking to change cell value.

by any chance do you have sample code?
Igor/10Tec
2014-06-10T07:45:08Z
If you definitely know the specified row keys exists, you can use something like this (C#):

iGrid.Rows["5098984"].Cells[3].Value = "New value";

If you need to check the key existence, use the Boolean KeyExists method of the iGrid row collection:


if (iGrid.Rows.KeyExists("5098984"))
  iGrid.Rows["5098984"].Cells[3].Value = "New value";
delPiero
2014-06-11T01:25:10Z
that did it for me.. great work on this iGrid, I purchased one license today and its working great!