asp.net+access2010 数据库连接求助

[shengji2012]

如题连接数据库的时候的时候显示ConnectionString未初始化，可是连接字符串不放进web.config中而是直接用 OleDbConnection sqlcon = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\\dbse.accdb");
的话没问题

<connectionStrings>
<add name="co" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;DataSource=|DataDirectory|\\dbse.accdb" />
</connectionStrings>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.OleDb;
using System.Data;
using System.Configuration;
namespace webaccess
{
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{



}

protected void Button1_Click(object sender, EventArgs e)
{
string constr = ConfigurationManager.ConnectionStrings["co"].ToString();
OleDbConnection sqlcon = new OleDbConnection();
sqlcon.Open();
OleDbDataAdapter sqlad = new OleDbDataAdapter("select tname,tsex,taddr from base where tname= '" + TextBox4.Text + "'", sqlcon);
DataSet dset = new DataSet();
sqlad.Fill(dset, "sqlbs");
if (dset.Tables["sqlbs"].Rows.Count > 0)
{

TextBox1.Text = Convert.ToString(dset.Tables["sqlbs"].Rows[0][0]);
TextBox2.Text = Convert.ToString(dset.Tables["sqlbs"].Rows[0][1]);
TextBox3.Text = Convert.ToString(dset.Tables["sqlbs"].Rows[0][2]);

}

sqlcon.Close();
}
}
}

[dalmeeme]

OleDbConnection sqlcon = new OleDbConnection();
改为：
OleDbConnection sqlcon = new OleDbConnection(constr);

另外连接字符串写在配置文件中的话，DataSource=|DataDirectory|\\dbse.accdb中的"\\"是不要加的，去掉。

[万金流]

//Access 2010
//string s1 = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=";
string s2 = @HttpContext.Current.Server.MapPath("data\\yangbiao.mdb");

[myhope88]

楼上讲得很清楚了

[快乐的小二兔]

1楼说的对2楼方法很有效