VB.Net Datagridview - Return to edited cell

Hi Experts. On CeIlEndEdit I am trying to check the number of digits in the cell and if incorrect get the focus back to the cell so that the next key pressed appears in the cell to be corrected. It works sometimes but most times the next key pressed appears in the cell that was selected after leaving the first cell. Any help would be appreciated.

Relevantcell = DataGridView2.CurrentCell
If DataGridView2.CurrentCell.ColumnIndex = 2 Then
If Relevantcell.FormattedValue.ToString.Length < 10 Then
MsgBox("The number is too short")
DataGridView2.CurrentCell = Relevantcell
DataGridView2.BeginEdit(True)
Exit Sub
End If
End If

PNRT

Asked: 2014-02-05

Advertise Here

Visual Basic.NET

2 Solutions

LVL 83

CodeCruiserCommented: 2014-02-05

Have you tried using CellValidating event instead?

http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridview.cellvalidating(v=vs.110).aspx

LVL 28

ArkCommented: 2014-02-06

why are you using 'CurrentCell'?

 
    Private Sub DataGridView1_CellEndEdit(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellEndEdit
        Dim relevantcell = CType(sender, DataGridView).Rows(e.RowIndex).Cells(e.ColumnIndex)
    End Sub

Open in new window

LVL 2

PNRTAuthor Commented: 2014-02-06

Thanks for the reply. I changed the code to the following. The messagebox appears, then the focus moves to the correct cell ready for editing but the next key stroke then appears in the cell that was clicked after the incorrect data was added. Also, if I manually return to the cell, the error checking does not work twice. Thanks again for the reply

Dim Relevantcell As DataGridViewCell

Relevantcell = CType(sender, DataGridView).Rows(e.RowIndex).Cells(e.ColumnIndex)
If DataGridView2.CurrentCell.ColumnIndex = 2 Then
If Relevantcell.FormattedValue.ToString.Length < 10 Then
MsgBox("The number is too short")
DataGridView2.CurrentCell = Relevantcell
DataGridView2.BeginEdit(True)
Exit Sub
End If
End If

LVL 28

ArkCommented: 2014-02-07

Actually CodeCruiser was correct - for your task you need validating event and setting e.Cancel=True to continue editing same cell

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Expand your skills with this month's free Premium course.

VB.Net Datagridview - Return to edited cell

Join & Write a Comment Already a member? Login.

Featured Post