public virtual DataSet SelectData(string FieldList = "*", string RowFilter = "1=1") { string cmdText = string.Format("SELECT {0} FROM {1} WHERE ({2});", FieldList, tableName, RowFilter); OleDbCommand cmd = null; DataSet dataSet = new DataSet(); try { cmd = new OleDbCommand(cmdText, db.getConnection()); odda.SelectCommand = cmd; //设置SELECT db.openConnection(); //打开数据库连接 odda.Fill(dataSet, tableName); } catch (Exception ex) { //抛出异常,外层接收 throw new Exception(ex.Message); } finally { //关闭数据库连接 db.closeConnection(); } return(dataSet); }
protected OleDbConnection conn; //数据库连接 //构造函数 public DBTable(DBase datab, string tb_Name) { db = datab; tableName = tb_Name; conn = datab.getConnection(); }