Hi,
I'm doing a student portal project. I'm using asp.net 3.5, and vb.net for codebehind.
I have a problem in the registration section.
See I have 3 gridviews, the first girdview lists all available courses for the current semester, it has a selection option.
when the user clicks on select, the second gridview appears showing availabe sections for a specific course, this gridview has a checkbox controler, when the user check it, the third gridview appears.
this third gridview is for the user to view all the possible going to register sections with a confirm button
once the confirm button is clicked, all needed data is saved in the database.
the thing is, I want the system to check if a specific student had registered for this course before, if he did he can't register to any sections of this course again. i'm having problem in doing that.
involved tables in database are : student, course, section and student2section
one course has many sections.
many student can register to many sections so we have an intermediary table called student2setcion
can anyone help please??
I'm doing a student portal project. I'm using asp.net 3.5, and vb.net for codebehind.
I have a problem in the registration section.
See I have 3 gridviews, the first girdview lists all available courses for the current semester, it has a selection option.
when the user clicks on select, the second gridview appears showing availabe sections for a specific course, this gridview has a checkbox controler, when the user check it, the third gridview appears.
this third gridview is for the user to view all the possible going to register sections with a confirm button
once the confirm button is clicked, all needed data is saved in the database.
the thing is, I want the system to check if a specific student had registered for this course before, if he did he can't register to any sections of this course again. i'm having problem in doing that.
involved tables in database are : student, course, section and student2section
one course has many sections.
many student can register to many sections so we have an intermediary table called student2setcion
can anyone help please??