public static DataSet getDataSet(string sqlStr, string sTable)
{
DataSet set2;
OleDbConnection selectConnection = getConn();
try
{
//selectConnection.Open();
OleDbDataAdapter adapter = new OleDbDataAdapter(sqlStr, selectConnection);
DataSet dataSet = new DataSet();
if (dataSet.Tables.Contains(sTable))
{
dataSet.Tables[sTable].Clear();
}
adapter.Fill(dataSet, sTable);
set2 = dataSet;
}
catch (Exception exception)
{
throw exception;//////错误位置,显示exception是无效的文件名
}
finally
{
selectConnection.Close();
selectConnection = null;
}
return set2;
}