我将数据库连接封装在下面的方法中
private OleDbDataReader OleQuery(string sql )
{
OleDbConnection Oleconn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=d:\\sjk\\sjk.mdb");
Oleconn.Open();//此句代码执行过程中经常出现异常,我该怎么改呢
OleDbCommand cmd = new OleDbCommand(sql,Oleconn );
OleDbDataReader sdr = cmd.ExecuteReader();
if (sdr.HasRows)
{
return sdr;
}
else
{
MessageBox.Show("没有相关记录");
return null;
}
}
private OleDbDataReader OleQuery(string sql )
{
OleDbConnection Oleconn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=d:\\sjk\\sjk.mdb");
Oleconn.Open();//此句代码执行过程中经常出现异常,我该怎么改呢
OleDbCommand cmd = new OleDbCommand(sql,Oleconn );
OleDbDataReader sdr = cmd.ExecuteReader();
if (sdr.HasRows)
{
return sdr;
}
else
{
MessageBox.Show("没有相关记录");
return null;
}
}
OleDbConnection Oleconn = new OleDbConnection(@"Provider=Microsoft.Jet.OleDb.4.0;Data Source=D:\sjk\sjk.mdb");