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






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 setQuery more columns and read result set
2.Read result set containing all columnsRead result set containing all columns
3.Read value using OleDbDataReaderRead value using OleDbDataReader
4.Map database column name to OleDbDataReader
5.Reference data in OleDbDataReader by column name
6.Format Data from OleDbDataReader