access数据库,怎么用c# vs2005连接?

来源：百度知道 编辑：UC知道 时间：2024/05/11 03:41:06
数据连接:Provider=MicroSoft.Jet.OLEDB.4.0;Data Source=?;
用相对路径.谢谢了
private static OleDbConnection connection;
public static OleDbConnection Connection
{
get
{
//OleDbConnection olecon = new OleDbConnection("Provider=MicroSoft.Jet.OLEDB.4.0;Data Source=Server.MapPath("App_Data/ab.mdb")");
//string connectionString = "Provider=MicroSoft.Jet.OLEDB.4.0;Data Source=" +"F:/WebFiles/DXKSWEB/DXWeb/App_Data/DXDATA.mdb";
string connectionString = "Provider=MicroSoft.Jet.OLEDB.4.0;Data Source=" + conString;

if (connection == null)
{
connection = new OleDbConnection(connectionString);
connection.Open();

OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("App_Data/ab.mdb");
conn.Open();

你上面的没写错，把 if 这句改改就可以了。

string str = HttpContext.Current.Server.MapPath("~"); // 获取实际路径
str = System.IO.Path.Combine(str, "App_Data\\ab.mdb"); // 合并两个路径

if (connection.State != ConnectionState.Open)
{
connection.Open();
}
...................