I am trying to do a loop that goes through every row & executes code. Any help would be appreciated. I have never used the infragistics, but our software uses the controls..
Hi,
It's very difficult to answer your question without knowing more about yoru data structure, what you are trying to do, and what features of the grid you are using.
Usually, looping through rows in the grid is not a very efficient way to do things. If, for example, you want to apply a color to a cell or row based on a value in that row, you would be much better off using the InitializeRow event rather than looping through every row.
If you do actually need to loop, then you will want to use the grid's Rows collection. The collection itself contains only the root-level rows. So if you want rows on multiple levels, you will want to use one of the methods on this collection such as GetAllNonGroupByRows, GetFilteredInNonGroupByRows, GetFilteredOutNonGroupByRows, or GetEnumerator. Which one you use depends on many factors.
It is a Dataview with items from a single progress table. If it were better do do this using the DataView I would try. There is a cell that holds a value in each row. Each row is just a record with a few in the database, no children. I want to loop through each row copy that value to another cell in the same row.