mdb文件里有t1、t2、t3三个数据表,同时查询加入一个DateSet
mdb文件里有t1、t2、t3三个数据表,这样同时查询加入一个DateSet,可以么,语法是正确的吧,测试了一下,可以查询到结果,初学有什么理解不到的,请老师指教,谢谢!
Dim check_name As String
Dim check_file As String
Dim ado_con As OleDbConnection = New OleDbConnection
Dim ado_adater As New OleDbDataAdapter
Dim ado_builder As New OleDbCommandBuilder
Dim pDateset As New DataSet
ado_con.ConnectionString = "provider=microsoft.jet.oledb.4.0;data source=" & check_file & "\test.mdb"
ado_con.Open()
ado_builder.DataAdapter = ado_adater
ado_adater.SelectCommand = New OleDbCommand("select * from t1", ado_con)
ado_adater.Fill(pDateset, "t1")
ado_adater.SelectCommand = New OleDbCommand("select * from t2", ado_con)
ado_adater.Fill(pDateset, "t2")
ado_adater.SelectCommand = New OleDbCommand("select * from t3", ado_con)
ado_adater.Fill(pDateset, "t3")