7,712
社区成员
发帖
与我相关
我的任务
分享
string sqlStr = "select name from MSYSOBJECTS where type=1 and flags=0";
DataTable dt = DBHelper.GetDsFromSql(sqlStr).Tables[0];
class DBHelper
{
public static DataSet GetDsFromSql(string sqlStr)
{
string strConnection = "Provider = Microsoft.ACE.OLEDB.12.0;";
strConnection += @"Data Source =" + AppDomain.CurrentDomain.BaseDirectory + "" + Consts.c_AccessName + ".accdb";
OleDbConnection conn = new OleDbConnection(strConnection);
DataSet ds = new DataSet();
try
{
OleDbDataAdapter da = new OleDbDataAdapter(sqlStr, conn);
conn.Open();
da.Fill(ds);
}
catch (Exception e)
{
ds.Tables.Add("TempTable");
}
conn.Close();
return ds;
}
}