TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
supersonic_skymaster
NA
52
0
joining datatables??
Jul 31 2004 7:47 PM
I want to join two datatables which are in a dataset, and then display the join table on a datagrid. I have tried to create relations in the dataset, but everytime the datagrid displays the parent table and it has that plus sign on the left side. I can't find a way to display the child fields. An example: There are three datatables. one contains the id number of a teacher and the id of the course taught by that teacher. the other table contains the id of the teacher and the name of the teacher. the last table contains the id of the course and the name of the course. I created the relations between the table that contains only the ids to the other tables, but I cannot find a way to join all three of them together for the display. Is there a way? Thank you.
Reply
Answers (
1
)
DataGrid for dummies please
Setup Program