In gridview as follows
For each dropdownlist 1 to 10.four items to be there Poor,Fair,Good,Excellent.
1 means Poor,2 means Fair,3 means Good,4 means Excellent.
Faculty gridview as follows
FacultyName Question1 Question2 Question3 Question4
Ram Dropdownlist1 Dropdownlist2 Dropdownlist3 Dropdownlist4
Sam Dropdownlist5 Dropdownlist6 Dropdownlist7 Dropdownlist8
Instructor gridview as follows
InstructorName Question1 Question2 Question3 Question4
Ram Dropdownlist1 Dropdownlist2 Dropdownlist3 Dropdownlist4
Sam Dropdownlist5 Dropdownlist6 Dropdownlist7 Dropdownlist8
Faculty Table strcutre as follows
id Autoincrement
FacName varchar(50)
Question1 int
Question2 int
Question3 int
Question4 int
Instructor Table structure as follows
id Autoincrement
InsName varchar(50)
Question1 int
Question2 int
Question3 int
Question4 int
I have one submit as follows.
In that submit button i want to save above two gridview records into Faculty and instructor table using union all.
we can use union all when inserting the mutiple gridview values.
why we use union all meanse when inserting the multiple gridview values in database. every time it disturbs the database for that we can union all to insert the records.
for that how can i do in asp.net using c#.
please help me for that how can i do in asp.net using C#.