UC知道如何解决c#中使用Access数据库出现的OleDbException异常
来源：百度知道 编辑：UC知道 时间：2024/05/31 09:06:54
private void Form1_Load(object sender, EventArgs e)
{
string connestring = @"Provider = Microsoft.Jet.OLEDB.4.0;Data Source =F:\Visual Studio Works\WindowsApplication3\Database1.accdb"; //.accdb是用Access2007的数据库文件
OleDbConnection connec = new OleDbConnection(connestring);
string sql = "select * from mark";
OleDbDataAdapter myadapter = new OleDbDataAdapter(sql, connec);
DataSet mydataset = new DataSet();
//OleDbCommandBuilder mybuicomm = new OleDbCommandBuilder(myadapter);
myadapter.Fill(mydataset, "MARK");
dataGridView1.DataSource = mydataset.Tables[0];
}
编译成功，但是运行时出现了异常，请问如何解决？
{
string connestring = @"Provider = Microsoft.Jet.OLEDB.4.0;Data Source =F:\Visual Studio Works\WindowsApplication3\Database1.accdb"; //.accdb是用Access2007的数据库文件
OleDbConnection connec = new OleDbConnection(connestring);
string sql = "select * from mark";
OleDbDataAdapter myadapter = new OleDbDataAdapter(sql, connec);
DataSet mydataset = new DataSet();
//OleDbCommandBuilder mybuicomm = new OleDbCommandBuilder(myadapter);
myadapter.Fill(mydataset, "MARK");
dataGridView1.DataSource = mydataset.Tables[0];
}
编译成功，但是运行时出现了异常，请问如何解决？
到
http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=zh-cn
下载驱动程序安装，然后把连接字符串改成：
@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source =F:\Visual Studio Works\WindowsApplication3\Database1.accdb";
数据库没有打开！
connec.Open();
完整代码如下：
private void Form1_Load(object sender, EventArgs e)
{
string connestring = @"Provider = Microsoft.Jet.OLEDB.4.0;Data Source =F:\Visual Studio Works\WindowsApplication3\Database1.accdb"; //.accdb是用Access2007的数据库文件
OleDbConnection connec = new OleDbConnection(connestring);
connec.Open();//打开数据库
string sql = "select * from mark";
OleDbDataAdapter myadapter = new OleDbDataAdapter(sql, connec);
DataSet myd