OleDBConnection myConnection = 
       new OleDBConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;" +
                           @"Data Source=C:\Test.MDB");
// 打开数据库连接
myConnection.Open();

SqlConnection myConnection = new SqlConnection("Data Source=(local);" +
                                               "Integrated Security=SSPI;"+ 
                                               "Initial Catalog=Test");
// 打开数据库连接
myConnection.Open();

SqlCommand myCommand = myConnection.CreateCommand();
myCommand.CommandText = "select count(*) as NumberOfRegions from region";
Int count = (int) myCommand.ExecuteScalar();

string strConn;
strConn = "Provider=SQLOLEDB;Data Source=(local)\\NetSDK;" +
          "Initial Catalog=Northwind;Trusted_Connection=Yes;";
OleDbConnection cn = new OleDbConnection(strConn);
OleDbCommand cmd = new OleDbCommand("CustOrdersOrders", cn);
cmd.CommandType = CommandType.StoredProcedure;
OleDbCommandBuilder cb = new OleDbCommandBuilder();
cn.Open();
cb.DeriveParameters(cmd);
cn.Close();
foreach (OleDbParameter param in cmd.Parameters)
{
    Console.WriteLine(param.ParameterName);
    Console.WriteLine("\t" + param.Direction.ToString());
    Console.WriteLine("\t" + param.OleDbType.ToString());
    Console.WriteLine();
}

// 创建一个为Microsoft Access OLE DB提供者的连接对象
OleDbConnection myConnection
         = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;" + 
                               @"Data Source=C:\Test.MDB");
// 打开数据库连接
myConnection.Open();
// 在此连接上创建SQL命令
OleDbCommand myCommand = myConnection.CreateCommand();
// 初始化SQL SELECT命令以接收数据
myCommand.CommandText = "SELECT Column1 FROM Table1";
// 在上面的SQL命令的基础上创建一个DataReader对象
OleDbDataReader myReader = myCommand.ExecuteReader();
// 不断读取Column1中的记录并显示在控制台中只到全部读完
while (myReader.Read())
{
	Console.WriteLine("{0}",  myReader["Column1"]);
}
myReader.Close();
myConnection.Close();

OleDbConnection myConnection
          = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;" +
                                @"Data Source=C:\Test.MDB");
myConnection.Open();
OleDbDataAdapter myAdapter
         = new OleDbDataAdapter("SELECT Column1 from Table1", myConnection);
Console.WriteLine("{0}\n",myAdapter.SelectCommand.CommandText);
OleDbCommandBuilder myBuilder = new OleDbCommandBuilder(myAdapter);
OleDbCommand insertCommand = myBuilder.GetInsertCommand();
Console.WriteLine("{0}\n",insertCommand.CommandText);

SELECT Column1 from  Table1
INSERT INTO 'Column1' ('Column1') VALUES (?)

// 创建一个DataAdapter对象以进行更新操作和其他的一些操作
SqlDataAdapter myAdapter
          = new SqlDataAdapter("SELECT * FROM Table1", myConnection);
// 创建一个DataSet对象以包含相关的表、行和列
DataSet myDataSet = new DataSet();
// 对DataSet对象进行填充
myAdapter.Fill(myDataSet, "Table1");
// 显示变化以前的数据
Console.WriteLine("Record before change: {0}",
                  myDataSet.Tables["Table1"].Rows[3]["Column1"]);
// 对表1，行3，列1中的数据进行修改
myDataSet.Tables["Table1"].Rows[3]["Column1"] = "Hello";
// 显示变化以后的数据
Console.WriteLine("Record after change: {0}",
                  myDataSet.Tables["Table1"].Rows[3]["Column1"]);
// 调用Update命令以更新表中的变化
myAdapter.Update(myDataSet, "Table1");

DataRow myRow = myDataSet.Tables["Table1"].NewRow();
myRow["Column1"] = "Hi";
myRow["Column2"] = "How do you do?";
myDataSet.Tables["Table1"].Rows.Add(myRow);
myAdapter.Update(myDataSet, "Table1");