title: SQL data retrieve - C#
body: <p>how do i retrieve data from a table within a loop or something. That means I want to retrieve row by row at a time. but the sequence of rows may differ.
  For example, 1st time i want 5rd row,then 2nd, then 9...so on.</p>
  
  <p>I searched it through the internet. I got only two answers.</p>
  
  <ol>
  <li><p>Use several SqlConnection objects.</p></li>
  <li><p>reader= sqlCommand.ExecuteReader();
  While(reader.Read()){
      reader["Column Name"].ToString();
  }</p></li>
  </ol>
  
  <p>If you got my problem, please help me
  Thank you.</p>