Typed Accessors : SqlDataReader : ADO.Net C# Examples

Typed Accessors

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

class  MainClass
{
      static  void  Main(string[]  args)
      {
            string  connString  =  @"server  =  .\sqlexpress;integrated  security  =  true;database  =  northwind";

            string  sql  =  @"select  productname,unitprice,unitsinstock,discontinued  from  products";

            SqlConnection  conn  =  new  SqlConnection(connString);  

            try
            {
                  conn.Open();

                  SqlCommand  cmd  =  new  SqlCommand(sql,  conn);

                  SqlDataReader  rdr  =  cmd.ExecuteReader();

                  while  (rdr.Read())
                  {
                        Console.WriteLine(
                              "{0}\t  {1}\t\t  {2}\t  {3}",
                              //  nvarchar
                              rdr.GetString(0).PadRight(30),  
                              //  money
                              rdr.GetDecimal(1),
                              //  smallint
                              rdr.GetInt16(2),
                              //  bit
                              rdr.GetBoolean(3));
                  }
                  rdr.Close();
            }
            catch(Exception  e)
            {
                  Console.WriteLine("Error  Occurred:  "  +  e);
            }
            finally
            {
                  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
• SqlDataReader
• SqlDataReader.GetString, GetDateTime
• how to read a table schema
• Use indexer to read data