62,046
社区成员
发帖
与我相关
我的任务
分享
public OleDbConnection ocon = null;
public OleDbCommand ocmd = null;
String reportPath = @"\Identify.accdb";
string ConStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data source=" + reportPath;
ocon = new OleDbConnection(ConStr);
//ocon.Open();
String strupdate = "SELECT * FROM IdentifiedTab";
OleDbCommand myCommand = new OleDbCommand(strupdate, ocon);
//myCommand.ExecuteNonQuery();
OleDbDataAdapter oda = new OleDbDataAdapter();
oda.SelectCommand = myCommand;
DataSet ds = new DataSet();
oda.Fill(ds,"IdentifiedTab"); //加上这句,放这儿
DataTable dt = ds.Tables[0];
//ocon.Close();
public OleDbConnection ocon = null;
public OleDbCommand ocmd = null;
String reportPath = @"\Identify.accdb";
string ConStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data source=" + reportPath;
ocon = new OleDbConnection(ConStr);
//ocon.Open();
String strupdate = "SELECT * FROM IdentifiedTab";
OleDbCommand myCommand = new OleDbCommand(strupdate, ocon);
//myCommand.ExecuteNonQuery();
OleDbDataAdapter oda = new OleDbDataAdapter();
oda.Fill(ds,"IdentifiedTab"); //加上这句
oda.SelectCommand = myCommand;
DataSet ds = new DataSet();
DataTable dt = ds.Tables[0];
//ocon.Close();