Operations on DataGridView In Visual Basic - Part 1

1. Adding a Row to DataGridView Programmatically,

Dim col1content,col2content As String

Dim col2content As Integer

myDataGridView.Rows.Add(col1content,col2content,col3content)

2. Clearing contents of all the rows,

myDataGridView.Rows.Clear()

3. To read all cells row by row,

For i = 0 To myDataGridView.Rows.Count - 2

' -2 bcoz we are starting with i=0 and last row is empty row added

col1 = myDataGridView.Row(i).Cells(0).Value.ToString()

col2 = myDataGridView.Row(i).Cells(1).Value.ToString()

col3 = myDataGridView.Row(i).Cells(3).Value 'Integer Value

Next

4. Reading a column of selected row,

Dim s As String = myDataGridView .CurrentRow.Cells("ColumnName").Value

5. To change color of text of selected row,

Dim low_score_style As New DataGridViewCellStyle()

low_score_style.ForeColor = Color.Red

myDataGridView .CurrentRow.DefaultCellStyle = low_score_style

6. To change colors of all rows iteratively,

For i = 0 To myDataGridView.Rows.Count - 2

myDataGridView.Rows(i).DefaultCellStyle = low_score_style

Next

7. Alternate way of achieving 6,

myDataGridView.ForeColor = Color.Red

To come up with some of the above tips on DataGridView, I had dived deep into Internet for days to make your life easier ...