Typed and Untyped dataset

jerry_hokh

Active member
Joined
Mar 14, 2006
Messages
25
Programming Experience
1-3
hi all,

I have 2 typed dataset corresponding to 2 tables (Student, Book)
then I would like to bind this two dataset to a datagid to list all student and their borrowed book,

What i will do is:
Get Student dataset, then make a for loop run through it's items, for each item i will make a query to get Book dataset corresponding to the student ID... i dont know whether it is a good way or not...

(I dont want to use 1 sql statement to query from those 2 tables then put the result into 1 untyped dataset and show on the grid)

Pls suggest a good way to do that...

thanks a lot.

Jerry.
 
Back
Top