第一段出了错误,
把try,catch删了是da的System.Data.OleDb.OleDbException:“标准表达式中数据类型不匹配。”
刚开始撸完全搞不懂为啥
求大佬解惑
class Class1
{
public DataTable ExecuteDataTable(string sql)
{
try
{
using (OleDbConnection conn = new OleDbConnection("Provider = Microsoft.Jet.OLEDB.4.0; Data Source = 'C:/Users/Lenovo/Desktop/学生选课管理信息系统.mdb'"))
{
if (conn.State != ConnectionState.Open)
conn.Open();
using (OleDbDataAdapter da = new OleDbDataAdapter(sql, conn))
{
DataTable dt = new DataTable();
da.Fill(dt);
return dt;
}
}
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public void ExecuteNonQuery(string sql)
{
using (OleDbConnection connection = new OleDbConnection("Provider = Microsoft.Jet.OLEDB.4.0; 'Data Source = C:/Users/Lenovo/Desktop/学生选课管理信息系统.mdb'"))
{
OleDbCommand command = new OleDbCommand(sql);
command.Connection = connection;
command.Connection = connection;
try
{
connection.Open();
command.ExecuteNonQuery();
}
catch (Exception E)
{
throw new Exception(E.Message);
}
}
}
}