Here im posting some of the pieces for coding in vb.net
For Each row As DataGridViewRow In DataGridView1.Rows
For i = 0 To DataGridView1.Columns.Count - 1
If (row.Cells(Column1.Name).Value = True) Then
' row.Cells(txt.Name).Value = "hello"
'DataGridView1.Rows(i).Selected = True
'row.Cells(2).Value = TextBox1.Text
row.Cells(3).Style.BackColor = Color.White
row.Cells(3).Value = "Received"
com1.CommandText = "update IOC_status set status='" & row.Cells(3).Value & "' where IOC_no='" & row.Cells(2).Value & "'"
com1.Connection = con
com1.ExecuteNonQuery()
End If
# a method to highlight rows in data grid and also to update values in datagrid rows to a database
For Each row As DataGridViewRow In DataGridView1.Rows
For i = 0 To DataGridView1.Columns.Count - 1
If (row.Cells(Column1.Name).Value = True) Then
' row.Cells(txt.Name).Value = "hello"
'DataGridView1.Rows(i).Selected = True
'row.Cells(2).Value = TextBox1.Text
row.Cells(3).Style.BackColor = Color.White
row.Cells(3).Value = "Received"
com1.CommandText = "update IOC_status set status='" & row.Cells(3).Value & "' where IOC_no='" & row.Cells(2).Value & "'"
com1.Connection = con
com1.ExecuteNonQuery()
End If
# a method to highlight rows in data grid and also to update values in datagrid rows to a database