关与WinForm的ACCESS数据库连接问题

Question

OleDbConnection thisConnection=new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\D\DevCs\Works2\Person.mdb;");
thisConnection.Open();
OleDbCommand thisCommand=thisConnection.CreateCommand(); //
thisCommand.CommandText="SELECT * FROM Intro";
OleDbDataReader thisReader=thisCommand.ExecuteReader();
while(thisReader.Read())
{
Console.WriteLine("\t{0}\t{1}",thisReader["ID"],thisReader["TheName"]);
}
thisReader.Close();
thisConnection.Close();

Answer 1

using System.Data.OleDb;OleDbConnection connection;
OleDbTransaction sqltxn;connection = New OleDbConnection;
connection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=lottery.mdb; ";
connection.Open();
connection.Close();