[在线等]从web.config中调用access的连接字符串问题?找不到可安装的ISAM

Question

web.config中的代码 <appSettings>
    <add key="ConnStr" value="Provider=Microsoft.Jet.OLEDB.4.0;Date Source="/>
    <add key="dbPath" value="App_Data\Database.mdb"/>
</appSettings>
<connectionStrings/>
程序中的代码 protected void Button1_Click(object sender, EventArgs e)
    {
        string str = System.Configuration.ConfigurationManager.AppSettings["ConnStr"] + System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["dbPath"]) + ";";
        OleDbConnection conn = new OleDbConnection(str);
        //OleDbConnection conn = new OleDbConnection(("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("app_data/Database.mdb")));
        OleDbDataAdapter da = new OleDbDataAdapter("select * from 个人信息 where name='" + name.Text + @"' and password='" + pwd.Text + @"'", conn);
        DataSet ds = new DataSet();
        da.Fill(ds);
        if (ds.Tables[0].Rows.Count == 1)
        {
            Response.Write("登陆成功");
        }
        else
        {
            Response.Write("登陆失败");
        } 
    }
Database.mdb的路径   C:\Users\Administrator\Desktop\test\WebSite1\App_Data\Database.mdb
-----------------------------------------------
试过了,直接在程序中写连接字符串,成功
OleDbConnection conn = new OleDbConnection(("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("app_data/Database.mdb")));现在就是想把连接字符串写在web.config中...该怎么办啊?

Answer 1

private static string ConnStr= System.Configuration.ConfigurationManager.AppSettings["ConnStr"];

Answer 2

<add key="dbPath" value="App_Data\Database.mdb"/>
修改成试试：
<add key="dbPath" value="~/App_Data/Database.mdb"/>

Answer 3

string m_strConn=ConfigurationSettings.AppSettings["ConnectionString"].ToString();

Answer 4

路径是否严格一致
ConnString = "Provider=Microsoft.Jet.Oledb.4.0; Data Source=" + filepath + "; Extended Properties=\"Excel 8.0; HDR=No; IMEX=1;\"";   string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + FileName + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1;'";   
using(OleDbConnection conn = new OleDbConnection(strConn))   
{   
conn.Open();   
OleDbDataAdapter oleDbDataAdapter = null;   
DataSet ds = new DataSet();   
string s= "select * from [sheet1$]";   
oleDbDataAdapter = new OleDbDataAdapter(s, conn);   
oleDbDataAdapter.Fill(ds);   
conn.Close();   
}