How Do I Update Database With Datagrid Selected Record Using Button Click Event

See more:

C#5.0

Hello Everyone,

I am trying to carryout database update, i want to be able to retrieve record from datagrid based on checkbox value(s) and update the database with it using button click event.

i have tried this:

if ( e.RowIndex < 0 || e.ColumnIndex < 0 )
            {
                return;
            }

            string deviceType = "", deviceName = "", modelNumber = "", macAddress = "";
            string  isActive, isInUse;
            int deviceId=0;
            deviceId = int.Parse(dataGridView1.Rows[e.RowIndex].Cells[0].Value + "");
           
                   
                    deviceType = dataGridView1.Rows[e.RowIndex].Cells[1].Value + "";
                    deviceName = dataGridView1.Rows[e.RowIndex].Cells[2].Value + "";
                    modelNumber = dataGridView1.Rows[e.RowIndex].Cells[3].Value + "";
                    macAddress = dataGridView1.Rows[e.RowIndex].Cells[4].Value + "";
                    isActive = dataGridView1.Rows[e.RowIndex].Cells[5].Value + "";
                    isInUse = dataGridView1.Rows[e.RowIndex].Cells[6].Value + "";

This seem to work only on a cellclick event, please how do i achieve this in a button click event