Query more columns and read result set : OleDbDataReader « Database ADO.net « C# / C Sharp

1. C# / C Sharp
2. Database ADO.net
3. OleDbDataReader

Query more columns and read result set

using System;
using System.Data;
using System.Data.OleDb;

public class ExtractInfo {    
 public static void Main () { 
   String connect = "Provider=Microsoft.JET.OLEDB.4.0;data source=.\\Employee.mdb";
   OleDbConnection con = new OleDbConnection(connect);
   con.Open();  
   Console.WriteLine("Made the connection to the Sales database");
   OleDbCommand cmd = con.CreateCommand();
   cmd.CommandText = "SELECT First_Name, Last_Name FROM Employee ORDER BY First_Name"; 
   OleDbDataReader reader = cmd.ExecuteReader();
   Console.WriteLine("First_Name\t\tLast_Name");  
   while(reader.Read()) 
     Console.WriteLine("{0}\t{1}",reader.GetString(0), reader.GetString(1));
   reader.Close();
   
   con.Close();
 }
}
           
       

Related examples in the same category

1.	Read result set containing all columns
2.	Execute complicated SQL query
3.	Read value using OleDbDataReader
4.	Map database column name to OleDbDataReader
5.	Reference data in OleDbDataReader by column name
6.	Format Data from OleDbDataReader