Example of C# Method of using ODBC to connect to database with OLEDB

using System;
using ;
using ;
using ;
using ;
namespace ODBCtest
{
  class Program
  {
    static void Main(string[] args)
    {
      //ODBC connection      string conString = "DSN=tian"; //tian represents the user data source name of ODBC      string sql = "select count(*) from stuinfo"; //stuinfo is a table in the database bound to the user's data source      OdbcConnection con = new OdbcConnection(conString);
      ();
      OdbcCommand com = new OdbcCommand(sql, con);
      int i = Convert.ToInt32(());
      (i);
      //OLEDB connection      string conString = @"Provider=.4.0;Data Source=D:\"; //Connect the Access database      string sql = "select count(*) from stuinfo";
      OleDbConnection con = new OleDbConnection(conString);
      ();
      OleDbCommand com = new OleDbCommand(sql, con);
      int i = Convert.ToInt32(());
      (i);
    }
  }
}