SqlDataReader Ordinal Indexer : SqlDataReader « Database ADO.net « C# / C Sharp

SqlDataReader Ordinal Indexer

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

   class OrdinalIndexer
      static void Main(string[] args)
         string connString = "server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI";
         string sql = @"select FirstName, LastName from Employee";

         SqlConnection conn = new SqlConnection(connString);

            SqlCommand cmd = new SqlCommand(sql, conn);
            SqlDataReader reader = cmd.ExecuteReader();
            Console.WriteLine("\t{0}   {1}", "First Name".PadRight(25),"Last Name".PadRight(20));
            Console.WriteLine("\t{0}   {1}",  "============".PadRight(25), "============".PadRight(20));
            while(reader.Read()) {
               Console.WriteLine(" {0} | {1}", 
         } catch(Exception e) {
            Console.WriteLine("Error Occurred: " + e);
         } finally {


Related examples in the same category

1.Execute multiple SELECT statements using a SqlCommand object and read the results using a SqlDataReader object
2.Get column index from SqlDataReader
3.use the GetOrdinal() from DataReader to get the numeric positions of a column
4.how to read column values as C# types using the Get* methods
5.read column values as Sql* types using the GetSql* methods
6.Read data from SqlDataReader
7.Reference data in SqlDataReader by column name
8.Use A Data Reader
9.Use While loop to read query result data from SqlDataReader
10.Deal with Multiple Results