Hello,

I asked this question a while back but wasn't able to receive a satisfactory answer so I'll try again.

I would like to know how to iterate though the underlying dataset in the same order as the sort-order specified in the datagrid.

Regards,

Anthony

Hi Anthony,

You can get the visual order by using the Items collection on your DataGridControl. You can also use it's GetItemAt() method to retrieve a specific item (index starts at 0).

For example:

   ItemCollection items = this.myGrid.Items;
   foreach( Employee item in items )
   {
      Console.WriteLine( "{0}", item.FirstName );
   }

   Console.WriteLine( "1st: {0}", ( ( Employee )this.myGrid.Items.GetItemAt( 0 ) ).FirstName );
   Console.WriteLine( "2nd: {0}", ( ( Employee )this.myGrid.Items.GetItemAt( 1 ) ).FirstName );

Hi Diane,

Thank you very much, this worked for me.

Regards,

Anthony