OleDbConnection连接ACCESS字符串错误
数据库层
//构造函数
protected OleDbConnection Connection;
public DBManager()//注意连接字符串的提取内容
{
string connStr;
connStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString + "WebDB.mdb";//得到的文件路径正确
//connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=../WebDB.mdb";//同上
connectionString = connStr;
Connection = new OleDbConnection(connectionString);
}
执行数据库查询
public DataSet ReturnDataSet(string strSQL)
{
DataSet dataSet = new DataSet();
try
{
Connection.Open(); //莫名其妙的加上了D:\\xxxxxxx\\xxxx\\xxxx\\WebDB.mdb
OleDbDataAdapter OleDbDA = new OleDbDataAdapter(strSQL, Connection);
OleDbDA.Fill(dataSet, "objDataSet");
}
catch (Exception e)
{
throw new Exception(e.Message);
}
finally
{
Connection.Close();
}
return dataSet;
}
这是怎么回事
环境是VS 2005打SP1补丁