I am writing a web application in asp.net using c sharp. I have a web page that lets the user create a program. In this system a program is made up of many applications and an Application can belong to many programs hence a many to many relationship. I have made a application, program, and ProgramApplicationMapping tables.
On this webpage there is a few textboxes (ex Program_Id , Program_Name) follows by a checklist of application (set number) followed by a save button.
when i hit the save button i want to INSERT into the database ProgramApplicationMapping
which just has two col ( program_id, application_id).
i dont know how to script the sql statement since the number of entries is dependent on the users selections of apps.
Please help me with my problem. Thank you