how to insert the Gridview values in tab container to database using session

See more:

C#5.0

In run mode as follows

i have dropdownlist for each tab.in each dropdownlist four items as follows

Poor,Fair,Good,Excellent
For Poor 1,Fair 2,Good 3,Excellent 4.

For example when user select the Poor 1 value to be saved in the database.
when user select the Fair 2 value to be saved in the database.
when user select the Good 3 value to be saved in the database.
when user select the Excellent 4 value to be saved in the database.


Faculty Instrcutor Managment Adminisration(Tab container)

Faculty(Tab container) When i click the Faculty in gridview record as follows

Facname    Question1       Question2        Question3        Question4
   xxx       Dropdownlist1   Dropdownlist2    Dropdownlist3    Dropdownlist4
   yyy       Dropdownlist5   Dropdownlist6    Dropdownlist7    Dropdownlist8

Instructor(Tab container) When i click the Instructor in gridview record as follows

Insname    Question1       Question2        Question3        Question4
   xxx       Dropdownlist1   Dropdownlist2    Dropdownlist3    Dropdownlist4
   yyy       Dropdownlist5   Dropdownlist6    Dropdownlist7    Dropdownlist8

Management(Tab container) When i click the Management in gridview record as follows

List of Questions        Ratings
     MgtQuestions1        Dropdownlist1
     MgtQuestions2        Dropdownlist2
     MgtQuestions3        Dropdownlist3
     MgtQuestions4        Dropdownlist4

Administration (Tab container) When i click the Administration in gridview record as follows

List of Questions          Ratings
     AdminQuestions1        Dropdownlist1
     AdminQuestions2        Dropdownlist2
     AdminQuestions3        Dropdownlist3
     AdminQuestions4        Dropdownlist4

i created three table.Three table structure as follows

Faculty table structure as follows

ID         Autoincrement
   FID         varchar(50)
   Facname     varchar(50)
   Question1     int
   Question2     int
   Question3     int
   Question1     int

Instructor table structure as follows

ID         Autoincrement
   IID         varchar(50)
   Insname     varchar(50)
   Question1     int
   Question2     int
   Question3     int
   Question1     int

Feedback table structure as follows

ID                 Autoincrement
   MgtQuestions1        int
   MgtQuestions2        int
   MgtQuestions3        int
   MgtQuestions4        int
   AdminQuestions1      int
   AdminQuestions2      int
   AdminQuestions3      int
   AdminQuestions4      int

1.i want to save Faculty(tabcontainer) gridview details in Faculty table.
Instructor (tabcontainer) gridview details in Instructor table.

2.i want to save Management and Adminsitration(tab container) gridview details in Feedback table.

For saving the above record in database. can i use session and store the all the gridview values details in session and then save into database.

for that how can i do in asp.net using c#.
Regards,
Narasiman P.