Read value using OleDbDataReader : OleDbDataReader « Database ADO.net « C# / C Sharp

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

Read value using OleDbDataReader

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

public class Prepare {    
 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 database");

   OleDbCommand cmd2 = con.CreateCommand();
   cmd2.CommandText = "SELECT First_name FROM Employee "
                                  + "WHERE ID > ?"; 
   OleDbParameter p3 = new OleDbParameter();
   cmd2.Parameters.Add(p3);
   p3.Value = new Decimal(0.0);
   OleDbDataReader reader = cmd2.ExecuteReader();
   while(reader.Read()) 
     Console.WriteLine("{0}", reader.GetString(0));
   reader.Close();


   con.Close();
 }
}

           
       

Related examples in the same category

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