更新时间:2023-02-08 07:45:18
最简单的连接方式是通过 OdbcConnection 使用这样的代码
The simplest way to connect is through an OdbcConnection using code like this
using System.Data.Odbc;
using(OdbcConnection myConnection = new OdbcConnection())
{
myConnection.ConnectionString = myConnectionString;
myConnection.Open();
//execute queries, etc
}
其中 myConnectionString 是这样的
where myConnectionString is something like this
myConnectionString = @"Driver={Microsoft Access Driver (*.mdb)};" +
"Dbq=C:mydatabase.mdb;Uid=Admin;Pwd=;
或者,您可以创建一个 DSN,然后在您的连接字符串中使用该 DSN
In alternative you could create a DSN and then use that DSN in your connection string
现在你的 connectionString 可以这样写了
now your connectionString could be written in this way
myConnectionString = "DSN=myDSN;"