How to Insert Data in SQL table with Gridview?

Question

I am creating a school management system in c-sharp and i am using SQL to store students and teachers details. 

I have two tables in SQL Database one is STUDENT_ENROLLMENT and other is ATTENDANCE.
what i want to do is that, take REGISTRATION_ID Column and STUDENT_NAME Column from the STUDENT_ENROLLMENT Table to the GRIDVIEW and after retrieval i want check boxes in front of all the Student_Names in the gridview for the attendance purpose, after checking and unchecking the check boxes when user clicks on a Button named SUBMIT, the gridview must send REGISTRATION_ID,STUDENT_NAME and CHECKBOX Value as YES for Checked ones and NO for Unchecked to the ATTENDANCE Table.

please help me...


Thank You