asp.net+access2010 数据库连接求助
如题连接数据库的时候的时候显示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();
}
}
}