how to save the mutiple gridview values using union all in C#

See more:

C#3.5

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