[RESOLVED] Datagridview checkbox problem

[coolwater]

Hello. Please bear with me I'm new to vb.net.
I have this datagridview problem.

Scenario:

My Database columns.

-isCleared (boolean)
-DateCleared (DateTime)

My DGV Columns:

-isCleared Column (CheckBox)
-DateCleared Column (Readonly Textbox)

My DGV will only accept edits.

What I want to accomplish in a row level (logic). I can't find the right DGV event to execute this logic.

if dgv.CurrentRow.Cells("IsCleared").Value = True then
   dgv.CurrentRow.Cells("DateCleared").Value = Date.Today
else
    dgv.CurrentRow.Cells("DateCleared").Value = nothing or dbnull?
end if

I tried experimenting with the DGV events I can't seem to make it work. All I get is a delayed effect.

[coolwater]

I got it. I read a solution from this link http://geekswithblogs.net/FrostRed/a...07/125001.aspx

[IanRyder]

Hi,

Good to see that you have solved this for yourself but here is another option for you using the CellContentClick Event of the DataGridView:-

Private Sub DataGridView1_CellContentClick(sender As System.Object, e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellContentClick
  If e.ColumnIndex = 0 Then
    If CBool(DataGridView1.CurrentCell.EditedFormattedValue) Then
      DataGridView1.CurrentRow.Cells("DateCleared").Value = Today
    Else
      DataGridView1.CurrentRow.Cells("DateCleared").Value = DBNull.Value
    End If
  End If
End Sub

Cheers,

Ian

[coolwater]

Hi,

Good to see that you have solved this for yourself but here is another option for you using the CellContentClick Event of the DataGridView:-

Private Sub DataGridView1_CellContentClick(sender As System.Object, e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellContentClick
  If e.ColumnIndex = 0 Then
    If CBool(DataGridView1.CurrentCell.EditedFormattedValue) Then
      DataGridView1.CurrentRow.Cells("DateCleared").Value = Today
    Else
      DataGridView1.CurrentRow.Cells("DateCleared").Value = DBNull.Value
    End If
  End If
End Sub

Cheers,

Ian

Thanks IanRyder. I like your solution. It's better.