62,046
社区成员
发帖
与我相关
我的任务
分享
public class AccessHelper
{
public OleDbConnection getConn(string constr)
{
constr = "Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=" + constr;
OleDbConnection tempconn = new OleDbConnection(constr);
return (tempconn);
}
public DataSet GetDataset(string constr, string strCom)
{
try
{
OleDbConnection conn = getConn(constr); //getConn():得到连接对象
OleDbCommand myCommand = new OleDbCommand(strCom, conn);
OleDbDataAdapter myda = new OleDbDataAdapter(myCommand);
DataSet ds=new DataSet();
conn.Open();
myda.Fill(ds);
return ds;
}
catch (Exception e)
{
return null;//throw(new Exception("数据库出错:" + e.Message)) ;
}
//返回Databook对象
}
public int ExecuteNonQuery(string constr, string sql)
{
try
{
int ret = 0;
OleDbConnection conn = getConn(constr); //getConn():得到连接对象
OleDbCommand myCommand = new OleDbCommand(sql, conn);
conn.Open();
ret = myCommand.ExecuteNonQuery();
return ret;
}
catch (Exception e)
{
return 0;//throw(new Exception("数据库出错:" + e.Message)) ;
}
}
}