How save datagridviewcomboboxcolumn in SQL server database using C#

See more:

SQL

C#6.0

I am going to develop a school management system and want to save attendance records in the database from DataGridViewComboBoxColumn each student in class with the Save button.

I mean set all student records e.g. present, absent, or leave the save record in the database when the "save" button is pressed.

This is my code - it works when I change cell of 1st student

What I have tried:

private void AttendanceDataGridVies_CurrentCellDirtyStateChanged(object sender, EventArgs e)
    {
        AttendanceDataGridVies.CommitEdit(DataGridViewDataErrorContexts.Commit);
    }

    private void AttendanceDataGridVies_CellValueChanged(object sender, DataGridViewCellEventArgs e)
    {
        string comboboxSelectedValue = string.Empty;

        if (AttendanceDataGridVies.Columns[e.ColumnIndex].GetType() == typeof(DataGridViewComboBoxColumn))
        {
            comboboxSelectedValue = AttendanceDataGridVies.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
            label2.Text = comboboxSelectedValue;
        }
    }