i have a gridview and a lesson table, lessondate table and LessonWithDate table
i want to have a drop down list which when click it, it show all the lesson
if i click on one of the lesson in drop down list, there will be the date available and lessonName show in the gridview
because 1 lesson can have many lessonDate and 1 lessonDate can have many lesson
thereby i create a combine table called LessonWithDate
so how should show in the gridview the result i want? cause i need to click on one of the date among those date available in the one of the lesson in the gridview
then i will click on add to list button
if i want only one row, which mean all dates will be show in a column, is there a way to allow user to select one of the date, take example in my drop down list, i click on English, then it will show a row of grid, in a column in will show all the list of date available in the radio button, user can click on one of it and then obtain the date that select inserting into the datebase which in click on AddToList button because i want to show another column the detail of the lesson ENGLISH
Table: Lesson
lessonID lessonName
1 English
2 Chinese
3 Maths
Table: LessonDate
lessonDateID date
1 12/2/2012
2 13/2/2012
3 20/3/2012
4 25/4/2012
Table: LessonWithDate
lessonWithDateID lessonDateID lessonID
1 1 1
2 1 2
3 2 2
4 3 1
5 4 3