[dharshinfotech]

how to read line by line from database

[eclipsed4utoo]

dharshinfotech, on 24 Aug, 2009 - 06:31 AM, said:

how to read line by line from database

for me, it's easiest to use the SqlConnection, SqlCommand, and SqlDataReader classes.

using (SqlConnection conn = new SqlConnection(yourConnectionString))
{
     using (SqlCommand cmd = new SqlCommand())
     {
          // your command code(connection, query, etc.)

          using (SqlDataReader dr = cmd.ExecuteReader())
          {
               while (dr.Read())
               {
                   //process the current data
                   // if the first column is a string type
                   string someData = dr.GetString(0);
               }
          }

     }
}