Use SQL Server Data Provider : SqlDataReader : ADO.Net C# Examples

Use SQL Server Data Provider

    
using  System;
using  System.Data;
using  System.Data.SqlClient;

class  MainClass
{
      static  void  Main(string[]  args)
      {
            string  connString  =  "server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated  Security=SSPI;";

            string  sql  =  @"select  *  from  employee";

            SqlConnection  conn  =  null;
            SqlDataReader  reader  =  null;

            try
            {
                  conn  =  new  SqlConnection(connString);
                  conn.Open();

                  SqlCommand  cmd  =  new  SqlCommand(sql,  conn);
                  reader  =  cmd.ExecuteReader();

                  Console.WriteLine("Querying  database  {0}  with  query  {1}\n",  conn.Database,  cmd.CommandText);

                  while(reader.Read())  {
                        Console.WriteLine("{0}  |  {1}",  reader["FirstName"].ToString().PadLeft(10)  ,  reader[1].ToString().PadLeft(10)  );
                  }
            }catch  (Exception  e)
            {
                  Console.WriteLine("Error:  "  +  e);
            }
            finally
            {
                  reader.Close();
                  conn.Close();
            }
      }
}
    
   
  
   

Related in same category :
• SqlDataReader
• Reference result set by column name in SqlDataReader
• Reference result set by column index in SqlDataReader
• OrdinalIndexer
• Use loop to read all data in SqlDataReader
• Use SqlDataReader to retrieve data in the resultset
• Get data by data type using SqlDataReader
• Using a DataReader to read row by row
• Updating Data Using CommondBuilder
• SqlDataReader
• Typed Accessors
• SqlDataReader.GetString, GetDateTime
• how to read a table schema
• Use indexer to read data