How using dataset to view(join?) several tables content? From what I've heard instead of datareader, dataset is good for it: shows several tables content Just know how to see just one table, as follows:

...
Dim strSQL as String = "Select FirstName, LastName from Employees"
Dim objDataSet as new DataSet()
Dim objConn as new Oledbconnection(strConnection)
Dim objAdapter as new OledbDataAdapter(strSql, objConnection)
Objadapter.Fill(ObjDataSet, "Employees")
Dim ObjDataView as New DataView(ObjDataSet.Tables("Employees"))
dgNameList.DataSouce = ObjDataView
dgNameList.DataBind()
...

Thanks for any help