Read result set containing all columns : OleDbDataReader « Database ADO.net « C# / C Sharp

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

Read result set containing all columns

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 * FROM Employee";
   OleDbDataReader reader = cmd.ExecuteReader();
   Console.WriteLine();
   Console.WriteLine("ID\tFirstName\tLastName\tSalary");  
   while (reader.Read())
     Console.WriteLine("{0}\t\t{1}\t\t{2}\t{3}",reader.GetInt32(0),reader.GetString(1),reader.GetString(2), reader.GetDecimal(3));
   reader.Close();


   con.Close();
 }
}

           
       

Related examples in the same category

1.	Query more columns and read result set
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