UC知道C#连ACCESS失败，帮改加分！！
来源：百度知道 编辑：UC知道 时间：2024/06/01 04:54:00
using System;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class Hadmin_Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
string tmp = "";
if (DropDownList1.SelectedIndex == -1)
{
tmp = "login_dept.L_id";
}
else
{
tmp = (string)DropDownList1.SelectedValue;
}
string sqlStr = "SELECT login_dept.L_name, sendInfo.I_title, sendInfo.I_sendDate FROM
using System.Data;
using System.Data.OleDb;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class Hadmin_Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
string tmp = "";
if (DropDownList1.SelectedIndex == -1)
{
tmp = "login_dept.L_id";
}
else
{
tmp = (string)DropDownList1.SelectedValue;
}
string sqlStr = "SELECT login_dept.L_name, sendInfo.I_title, sendInfo.I_sendDate FROM
OleDbConnection aConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source='datax/defsx12.mdb'");
//建立Command前加一句:
aConn.Open();
OleDbCommand aCmd = new OleDbCommand(sqlStr, aConn);
如果还不能连接说明连接字符串错误.确定数据库位置正确.或修改下加转义字符
OleDbConnection aConn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source='datax\defsx12.mdb'");
string connString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.Mappath(datax/defsx12.mdb);
注意这里要用绝对路径
连接字符串错了
连接字符串有问题