reading from related tables of access.
Database
1
Posts
1
Posters
0
Views
1
Watching
-
Hello ! I have created two tables in access. The 1st table is "products" and the 2nd is "components". I have also established a relation of one to many using the editor in access. Now, from ASP.NET I wish to read a product, television, and its component, screen. Is it enough to call: StrCommand = "SELECT TVscreenID FROM products WHERE ID = " + x + " ORDER BY ID" OleDbDataAdapter da = new OleDbDataAdapter(StrCommand, conn); da.Fill(ds,"products"); for accessing the details of the component 'screen' which is elaborated within the table components ? how do I access the details of the screen through the member 'TVscreenID' ? GetChild() or something? should I change the sql-string command to relate the both tables ?