sql server 2008 express - SQL data retrieve - C# -

how retrieve data table within loop or something. means want retrieve row row @ time. sequence of rows may differ. example, 1st time want 5rd row,then 2nd, 9...so on.

i searched through internet. got 2 answers.

1. use several sqlconnection objects.

2. reader= sqlcommand.executereader(); while(reader.read()){ reader["column name"].tostring(); }

if got problem, please me thank you.

sounds should correct data layer return values in order going process them. easiest , fastest! :)

as alternative i'd suggest load result datatable:

    datatable table = new datatable();     using ( sqlcommand command = new sqlcommand() )     {            // todo: set command here         using (sqldataadapter adapter = new sqldataadapter(command))         {             adapter.fill(table);         }     }      // use datatable this...      if ( table.rows.count >= 5 ) {         datarow firstrow = table.rows[0]; // #1 row         datarow fifthrow = table.rows[4]; // #5 row         datarow secondrow = table.rows[1]; // #2 row     } 

/alex