title: SQL Server: return all rows in table and read their values
body: <p>I have a table with 6 columns and 5 rows. I want to select all rows and read through them using the <code>SqlDataReader</code> (ASP.NET C#). I currently can access single columns using <code>dataReader["columnName"].ToString()</code> and store that in a string variable. </p>
  
  <p>I want to read through the columns row by row. </p>
  
  <p>Thanks for helping. </p>