110,535
社区成员
发帖
与我相关
我的任务
分享
//打开mdb数据库
string fileName = MainManageFilePathFmtCfgTextBox.Text.ToString();
string CsvFolder = Path.GetDirectoryName(fileName);
string csvConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;"
+ "Data Source=" + CsvFolder + "\\"
+ ";Extended Properties='Text;HDR=No;FMT=CSVDelimited'";
OleDbConnection csvConn = new OleDbConnection(csvConnectionString);
csvConn.Open();
OleDbDataAdapter csvDa = new OleDbDataAdapter("select * from " + fileName + "", csvConn);
DataSet csvDs = new DataSet();
csvDa.Fill(csvDs, "tbl_name");
foreach (DataRow dr in csvDs.Tables["tbl_fmt_list"].Rows)
{
MessageBox.Show(dr[0].ToString()+dr[1].ToString()+dr[2].ToString(), "系统测试",
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
csvDa.Fill(csvDs, "tbl_name");
foreach (DataRow dr in csvDs.Tables["tbl_fmt_list"].Rows)
//不是同一个表
//tbl_fmt_list
//tbl_name