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 OrderNumber FROM Orders "
             + "WHERE OrderDate BETWEEN #4/1/99# AND #4/30/99#";
   OleDbDataReader reader = cmd.ExecuteReader();
   Console.WriteLine();
   Console.WriteLine
      ("   Order numbers of orders from 4/1/99 to 4/30/99");
   while(reader.Read())
     Console.WriteLine(reader.GetString(0)); 
   reader.Close();




   con.Close();
 }
}
           
          

   


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

public class DatabaseInfo {    
 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 command = con.CreateCommand();
   command.CommandText = "SELECT COUNT(*) FROM Employee";
   Console.WriteLine("Number of Employee rows: {0}",(int)command.ExecuteScalar());
   con.Close();
 }
}
 
           
          

   

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

public class DatabaseInfo {    
 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 command = con.CreateCommand();
   command.CommandText ="SELECT MAX(Salary) FROM Employee";
   Console.WriteLine("Max of salary: {0:C}",(decimal)command.ExecuteScalar());
   con.Close();
 }
}
 

           
          

   


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

public class DatabaseInfo {    
 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 command = con.CreateCommand();
   command.CommandText = "SELECT AVG(Salary) FROM Employee";
   Console.WriteLine("Average of salary: {0:C}",(decimal)command.ExecuteScalar());


   con.Close();
 }
}
 
           
          

   

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

public class DatabaseInfo {    
 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 command = con.CreateCommand();
   command.CommandText ="SELECT SUM(salary) FROM Employee";
   Console.WriteLine("Sum of salary: {0:C}",(decimal)command.ExecuteScalar());


   con.Close();
 }
}
 

           
          

   
 

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

class MainClass {
    public static void Main() {
        using (OleDbConnection con = new OleDbConnection()) {
            con.ConnectionString = "Provider=SQLOLEDB;" +     
                @"Data Source=.sqlexpress;" + 
                "Initial Catalog=Northwind;" + 
                "Integrated Security=SSPI";    

            con.Open();

            if (con.State == ConnectionState.Open) {
                Console.WriteLine("  Timeout = " + con.ConnectionTimeout);
            } else {
                Console.WriteLine("OleDbConnection failed to open.");
                Console.WriteLine("  Connection State = " + con.State);
            }
        }
    }
}

    

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

class ExecuteTableDirect
{
public static void Main()
{
OleDbConnection myOleDbConnection =new OleDbConnection(“provider=sqloledb;server=(local)SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI”);
OleDbCommand myOleDbCommand = myOleDbConnection.CreateCommand();

myOleDbCommand.CommandType = CommandType.TableDirect;

myOleDbCommand.CommandText = “Employee”;

myOleDbConnection.Open();

OleDbDataReader myOleDbDataReader = myOleDbCommand.ExecuteReader();

for (int count = 1; count <= 2; count++) { myOleDbDataReader.Read(); Console.WriteLine("myOleDbDataReader[" ID"] = " + myOleDbDataReader["ID"]); Console.WriteLine("myOleDbDataReader[" FirstName"] = " + myOleDbDataReader["FirstName"]); Console.WriteLine("myOleDbDataReader[" LastName"] = " + myOleDbDataReader["LastName"]); } myOleDbDataReader.Close(); myOleDbConnection.Close(); } } [/csharp]