Public objConn As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\database\MediaTeach.mdb")
Public objComm As New OleDbCommand
Public objda As New OleDbDataAdapter
Public objds As New DataSet

objComm.CommandText = "select * from FirstList"
objComm.Connection = objConn
objda.SelectCommand = objComm

objConn.Open()
objda.Fill(objds)
objConn.Close()

上面的代码是把一个表的内容放在dataset中,
我想把ACCESS数据库名为MediaTeach.mdb中所有表都放在dataset怎么写代码呀?

所有表??
一个一个写,一个一个加./

把这里改一下
objConn.Open()
objda.Fill(objds)
objConn.Close()

改为如下
objConn.Open()
objda.Fill(objds,"T1")
objConn.Close()

objConn.Open()
objda.Fill(objds,"T2")
objConn.Close()

objConn.Open()
objda.Fill(objds,"Tn")
objConn.Close()