Retrieves data as native SQL Server types. : SqlDataReader « ADO.Net « C# / CSharp Tutorial

1. C# / CSharp Tutorial
2. ADO.Net
3. SqlDataReader

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

public class NativeSqlServer
{

    public static void Main() 
    {
        string SQL = "SELECT OrderID, CustomerID, OrderDate, Freight FROM Orders";
        SqlConnection con = new SqlConnection("Data Source=localhost;Initial Catalog=Northwind;Integrated Security=SSPI");
        SqlCommand cmd = new SqlCommand(SQL, con);
        SqlDataReader r;

        con.Open();
        r = cmd.ExecuteReader();
        while (r.Read()) {
            SqlInt32 orderID = r.GetSqlInt32(0);
            SqlString customerID = r.GetSqlString(1);
            SqlDateTime orderDate = r.GetSqlDateTime(2);
            SqlMoney freight = r.GetSqlMoney(3);

            Console.Write(orderID.ToString() + ", ");
            Console.Write(customerID + ", ");
            Console.Write(orderDate.ToString() + ", ");
            Console.Write(freight.ToString() + ", ");
            Console.WriteLine();
        }
    }    
}