I have the same scenario here, is it not possible to use the ultragrid1.rows.all.find() function to return the row? since we're resetting the grid, we can capture the field value from the grid prior to the reset.

Theres always the old fallback of looping through each row in the grid, but the Find method seems to be what we're looking for here, isnt it?

Um, I don't think so. I could be wrong, but I am pretty sure that the All property is a property on Collection and it just returns an Object array. I wasn't aware that there was a Find method on an Array, but even if there is, I assume it finds some object that you specify. I don't see how it would be able to find an UltraGridRow with a cell that has a particular value. It knows nothing about the grid or cells.  

 Mike, marcjannes, fergal1982

 I have this same requirement in my project.

 The .Find() method is a new LINQ extension for collections. However, because the .All property doesn't know that the items inside the RowsCollection object (UltraGrid1.Rows) are UltraGridRow objects, what seems to be syntactically correct is something like this ... 

       // get the row from the grid which represents the column for which the filter was modified.
       UltraGridRow colRow = this.ActiveGrid.Rows.OfType<UltraGridRow>().ToList().Find(row => row.Cells[0].Text.Equals(valueListColumnFiltersChangedEventArgs.Column.Name, StringComparison.CurrentCultureIgnoreCase));

• In the first bit, you want to explicitly get the objects inside the Rows collection that are of type UltraGridRow (Rows.OfType<UltraGridRow>)
• This sets us up for being able to convert to a List<UltraGridRow>, while also ensuring that the following conversion to a List, and finally the search using the predicate, don't fail if they come across an invalid type. (While I'm fairly confident this should have no problems with verifying the type, if it does cause problems you can perform an equivalent using: .Where(obj => obj is UltraGridRow) ... to get an IEnumerable collection of the rows. I would suspect the OfType is slightly more performant?).
  
• You can then use the.Find() method, supplying your predicate/function of choice.
• For me this happens inside an event which i raise from my BizObj when an item from a sub-collection is removed from the middle of the collection. (Each item in the sub-collection is displayed in the same row as the parent object, in unbound columns at the end of the grid.)
  
• Here you see the value of valueListColumnFiltersChangedEventArgs.Column.Name is compared to the text value inside the first column of the grid, which is read-only and used as the key (back to the BizObj) for the row. 

emz,

Thanks for that bit of code and the explanation, it's quite thorough.  Got some questions for you:  (1) is that really any faster than a foreach loop?  According to the MSDN documentation the List<T>.Find method is linear in its search, so how does the optimized CLR achieve find the item any faster?  It has to go through all the same items one by one starting at the beginning, just like a foreach loop, and it has to run the same comparison you would use in a foreach loop (row.Cells["ColumnKey"].Text.Equals("Stuff"), for example).

Question (2):  Have you considered just using the Single method?  Here is what I use in my code:

grid.Rows.Single(row => row.GetCellValue("ColumnKey").ToString() == valueToFind.ToString()).Selected = true;

While Single doesn't work when more than one element in the source with the correct value exists, I assume since we're trying to select a single row, it's going to be off a unique column.  (We could use Where otherwise).

I'm very new to LINQ, so this is still a learning process for me and I would appreciate any input.

Thanks,

J

Although this thread looks a bit old I thought I would show my approach which seems to be working well:

gridBindingSource.Position = gridBindingSource.Find("ColumnName", SearchValue))

Thanks Mike - that's a great method - not sure when it was added, but I had totally missed it.

grid.Rows.GetAllFilteredInNonGroupByRows