Member Avatar for jlivvers

Hi,

hopefully this is the right place to post this.
Whats the best way to handle a many to many relationship in a windows form?

The relationsip involves a student having multiple courses and vice verca. However each student would be viewed individually and it would just need to list the courses they were associated with and update, insert etc.

I hope thats not entirely vague..!

Thanks in advance

  • 2 Contributors
  • 1 Reply
  • 107 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by skatamatic
Member Avatar for skatamatic

select * from tbl_student_courses where studentID = myID

insert into tbl_student_courses values (@myID,@otherdata)

update tbl_student_courses set (otherdata=@myOtherdata) where studentID = myID

Hard to tell how to help you since you didn't give us your database schema. These are some standard, non-specific examples that hopefully you may learn from.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.