110,533
社区成员
发帖
与我相关
我的任务
分享
private OleDbConnection conn = null;
String strConn = @"Provider=Microsoft.ACE.OLEDB.12.0;
Data Source=Dat.accdb;
Jet OLEDB:Database Password=312746722Wj";
using (conn = new OleDbConnection( strConn))
conn.Open();
public class OleDbDataAccess : IDataAccess
{
private OleDbConnection conn;
public OleDbDataAccess()
{
string connStr = ConfigurationManager.AppSettings["oleDbConn"];
conn = new OleDbConnection(connStr);
if (conn.State != System.Data.ConnectionState.Open)
{
conn.Open();
}
}
public DataSet ExecuteQuery(string sql)
{
DataSet ds = new DataSet();
OleDbDataAdapter oda = new OleDbDataAdapter(sql, conn);
oda.Fill(ds);
return ds;
}
IDataReader IDataAccess.ExecuteReader(string sql)
{
OleDbCommand odc = new OleDbCommand(sql, conn);
return odc.ExecuteReader();
}
public int ExecuteSql(string sql, ref DbParameter[] parameters)
{
OleDbCommand odc = new OleDbCommand(sql, conn);
odc.Parameters.AddRange(parameters);
return odc.ExecuteNonQuery();
}
public int ExecuteCommand(string sql)
{
OleDbCommand odc = new OleDbCommand(sql, conn);
return odc.ExecuteNonQuery();
}
}