Question

"System.InvalidOperationException"类型的未经处理的异常在 System.Data.dll

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.OleDb;
using System.Windows.Forms;

namespace StudentScore
{
class DataAccess
{
//定义连接字符串
private string strDSN;
//定义数据库连接对象
OleDbConnection oledbCon;
//数据库连接方法
public void dataCon()
{
strDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath.ToString() + "\\student.mdb";
oledbCon = new OleDbConnection(strDSN);
}
//获取DataSet
public DataSet getDataset(string sql)
{
DataSet ds = new DataSet();
oledbCon.Open();#这个地方有问题
try
{

OleDbCommand oledbCom = new OleDbCommand(sql, oledbCon);
OleDbDataAdapter oledbDa = new OleDbDataAdapter(oledbCom);
oledbDa.Fill(ds);
return ds;
}
catch(Exception e)
{
throw new Exception(e.ToString());
}
finally
{
oledbCon.Close();
}
}

//执行SQL语句
public bool sqlExec(string sql)
{
try
{
oledbCon.Open();
}
catch
{
MessageBox.Show("数据库未连接");
}
try
{
OleDbCommand oledbCom = new OleDbCommand(sql, oledbCon);
oledbCom.ExecuteNonQuery();
return true;
}
catch (Exception e)
{
MessageBox.Show(e.Message, "提示");
return false;
}
finally
{
oledbCon.Close();
}
}
}
}
编辑器：vs2013
解决问题发现：vs2013环境下生成的.exe文件复制到另一台计算机(学校电脑上面是vs2008)上可以使用





Answer 1

这种问题我也遇到过，首先看机器上是否安装了Access，应该是03版的吧。然后VS里面编译选项要改成针对x86的才行。