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.
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.