how to save multiple records in gridview with checkbox

[cyberdaemon]

i want to save multiple selected records from the gridview. once the checked box is selected inside the gridview maybe 2 or more records in it.. all i want is to save all selected records from it. I already created a table type parameter in my sql..

thanks

[Mitja Bonca]

loop through rows of gridview and check the column of checkbox (if checked (true) add to database, if not do nothing.

            foreach(DataGridViewRow row in dgv.Rows)
            {
                DataGridViewCheckBoxCell check = row.Cells[0] as DataGridViewCheckBoxCell; 
                //0 represents 1st column; change the index to your column
                if ((bool)check.Value)
                {
                    //insert this row (checkBox is checked
                }
            }