Use A Data Reader : SqlDataReader : Database C# Source Code

Use A Data Reader

    


/*
 * C# Programmers Pocket Consultant
 * Author: Gregory S. MacBeth
 * Email: gmacbeth@comporium.net
 * Create Date: June 27, 2003
 * Last Modified Date:
 * Version: 1
 */
using System;
using System.Data;
using System.Data.SqlClient;

namespace Client.Chapter_13___ADO.NET
{
    public class UsingADataReader
    {
        static void Main(string[] args)
        {
            SqlConnection MyConnection = new SqlConnection(@"Data Source=(local); Initial Catalog = CaseManager; Integrated Security=true");

            MyConnection.Open();

            SqlCommand MyCommand = new SqlCommand("SELECT * FROM CaseInfo", MyConnection);
            SqlDataReader MyDataReader = MyCommand.ExecuteReader(CommandBehavior.CloseConnection);

            while (MyDataReader.Read())
            {
                Console.WriteLine(MyDataReader[0] + " " + MyDataReader[1]);
            }

            MyConnection.Close();
        }
    }
}


           
       
    
   
  
   

Related in same category :
• Execute multiple SELECT statements using a SqlCommand object and read the results using a SqlDataReader object
• Get column index from SqlDataReader
• use the GetOrdinal() from DataReader to get the numeric positions of a column
• how to read column values as C# types using the Get* methods
• Read column values as Sql* types using the GetSql* methods
• Read data from SqlDataReader
• Reference data in SqlDataReader by column name
• Use While loop to read query result data from SqlDataReader
• Deal with Multiple Results
• SqlDataReader Ordinal Indexer