updating for many to many relaitonship

[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

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