Mega Code Archive

 

Categories / C# / ADO Database

 

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);          try          {             conn.Open();             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}",                    reader[0].ToString().PadLeft(25),                   reader[1].ToString().PadLeft(20));             }             reader.Close();          } catch(Exception e) {             Console.WriteLine("Error Occurred: " + e);          } finally {             conn.Close();          }       }    }