SqlDataReader : SqlDataReader : ADO.Net C# Examples

SqlDataReader

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

class  MainClass
{
    static  void  Main(string[]  args)
        {
                string  ConnectionString  ="server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated  Security=SSPI;";
                string  SQL  =  "SELECT  *  FROM  Employee";

                SqlConnection  conn  =  new  SqlConnection(ConnectionString);
                SqlCommand  cmd  =  new  SqlCommand(SQL,  conn);
                
                conn.Open();

                SqlDataReader  reader  =  cmd.ExecuteReader();

                Console.WriteLine("ID,  FirstName");

                while  (reader.Read())
                {
                        Console.Write(reader["ID"].ToString()  +  ",  ");
                        Console.Write(reader["FirstName"].ToString()  +  ",  ");
                }

        Console.WriteLine("Total  Number  of  records  affected:  "+  reader.RecordsAffected.ToString()  );

                reader.Close();
                conn.Close();
        }
}
    
   
  
   

Related in same category :
• SqlDataReader
• Use SQL Server Data Provider
• 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
• Typed Accessors
• SqlDataReader.GetString, GetDateTime
• how to read a table schema
• Use indexer to read data