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();
}
