How using DataSet with several tableshttp://forums.asp.net/t/301803.aspx/1?How+using+DataSet+with+several+tablesWed, 06 Aug 2003 18:52:06 -0400301803301803http://forums.asp.net/p/301803/301803.aspx/1?How+using+DataSet+with+several+tablesHow using DataSet with several tables 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: <pre class="prettyprint">... Dim strSQL as String = &quot;Select FirstName, LastName from Employees&quot; Dim objDataSet as new DataSet() Dim objConn as new Oledbconnection(strConnection) Dim objAdapter as new OledbDataAdapter(strSql, objConnection) <b>Objadapter.Fill(ObjDataSet, &quot;Employees&quot;)</b> Dim ObjDataView as New DataView(ObjDataSet.Tables(&quot;Employees&quot;)) dgNameList.DataSouce = ObjDataView dgNameList.DataBind() ...</pre> Thanks for any help 2003-08-06T18:37:22-04:00301825http://forums.asp.net/p/301803/301825.aspx/1?Re+How+using+DataSet+with+several+tablesRe: How using DataSet with several tables A good way is nesting controls, like Repeater or DataList. See this post I send some code that uses nested repeaters using a dataset: <a href="http://www.asp.net/Forums/ShowPost.aspx?tabindex=1&amp;PostID=301662">http://www.asp.net/Forums/ShowPost.aspx?tabindex=1&amp;PostID=301662</a> 2003-08-06T18:52:05-04:00