如题连接数据库的时候的时候显示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();
}
}
}
的话没问题 <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();
}
}
}
改为:
OleDbConnection sqlcon = new OleDbConnection(constr);另外连接字符串写在配置文件中的话,DataSource=|DataDirectory|\\dbse.accdb中的"\\"是不要加的,去掉。
//string s1 = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=";
string s2 = @HttpContext.Current.Server.MapPath("data\\yangbiao.mdb");