Execute complicated SQL query : OleDbDataReader « Database ADO.net « C# / C Sharp

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

Execute complicated SQL query

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 DISTINCT CustomerName "
            + "FROM Customer, Item, Orders, OrderItem "
            + "WHERE Customer.CustomerID = Orders.CustomerID "
            + "AND Orders.OrderNumber = OrderItem.OrderNumber "
            + "AND OrderItem.ItemNumber = Item.ItemNumber "
            + "AND Description = 'computer'";
   OleDbDataReader reader = cmd.ExecuteReader();
   while(reader.Read())
     Console.WriteLine(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.	Read value using OleDbDataReader
4.	Map database column name to OleDbDataReader
5.	Reference data in OleDbDataReader by column name
6.	Format Data from OleDbDataReader