public System.Data.DataTable DbToDatatable(string sql, string file_dir)
{
AccessDbClass1 db = new AccessDbClass1();
db.AccessDbClass2(file_dir);
System.Data.DataTable table = db.SelectToDataTable(sql);
db.Close();
return(table);
}
public void AccessDbclass(string sql, string file_dir)
{
AccessDbClass1 db = new AccessDbClass1();
db.AccessDbClass2(file_dir);
bool dd = db.ExecuteSQLNonquery(sql);
db.Close();
}
/// <summary>
/// 将查询结果返回给datatable
/// </summary>
public System.Data.DataTable DbToDatatable(string sql)
{
string str5 = System.Windows.Forms.Application.StartupPath;
string a = str5 + "\\db.accdb";
AccessDbClass1 db = new AccessDbClass1();
db.AccessDbClass2(a);
System.Data.DataTable table = db.SelectToDataTable(sql);
db.Close();
return(table);
}
/// <summary>
/// 执行sql语句
/// </summary>
public void AccessDbclass(string sql)
{
string str5 = System.Windows.Forms.Application.StartupPath;
string a = str5 + "\\db.accdb";
AccessDbClass1 db = new AccessDbClass1();
db.AccessDbClass2(a);
bool dd = db.ExecuteSQLNonquery(sql);
db.Close();
}
public System.Data.DataTable DbToDatatable(string sql, string file_dir)
{
AccessDbClass1 db = new AccessDbClass1();
db.AccessDbClass2(file_dir);
System.Data.DataTable table = db.SelectToDataTable(sql);
db.Close();
return table;
}
/// <summary>
/// 将查询结果返回给datatable
/// </summary>
public System.Data.DataTable DbToDatatable(string sql)
{
string str5 = System.Windows.Forms.Application.StartupPath;
string a = str5 + "\\db.accdb";
AccessDbClass1 db = new AccessDbClass1();
db.AccessDbClass2(a);
System.Data.DataTable table = db.SelectToDataTable(sql);
db.Close();
return table;
}
public void AccessDbclass(string sql, string file_dir)
{
AccessDbClass1 db = new AccessDbClass1();
db.AccessDbClass2(file_dir);
bool dd = db.ExecuteSQLNonquery(sql);
db.Close();
}
public bool AccessDbclassdd(string sql)
{
string str5 = System.Windows.Forms.Application.StartupPath;
string a = str5 + "\\db.accdb";
AccessDbClass1 db = new AccessDbClass1();
db.AccessDbClass2(a);
bool dd = db.ExecuteSQLNonquery(sql);
return dd;
db.Close();
}
