using System;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
using System.Windows.Forms;
public class AccConnDb{
private OleDbConnection conn;
private OleDbDataAdapter oda = new OleDbDataAdapter();
private OleDbCommand cmd;
private DataSet myds = new DataSet();
string conString = System.Configuration.ConfigurationManager.AppSettings["conStr"];
public AccConnDb(){
//conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + @"/db/dbtest.mdb");
conn = new OleDbConnection(connstr);
}
//执行select语句返回查询结果
public DataSet getDS(string strSQL){
myds = new DataSet();
oda = new OleDbDataAdapter(strSQL, conn);
oda.Fill(myds);
return myds;
}
//执行insert update delete
public bool setDS(string strSQL){
conn.Open();
cmd = new OleDbCommand(strSQL, conn);
cmd.ExecuteNonQuery();
conn.Close();
return true;
}
}
c# access操作类
最新推荐文章于 2023-03-27 16:28:51 发布