Member Avatar for markdean.expres

Guys how do I set a column of a datagrid so that it will only accept numbers? I have this column labeled "Grade" which of course, should not accept letters. I have done setting its Format property but it is not working... Please

  • 3 Contributors
  • 3 Replies
  • 94 Views
  • 3 Months Discussion Span
  • Latest Post Latest Post by Mitja Bonca
Member Avatar for abhay1234

You can use the IsNumeric boolean property

If(IsNumeric(...)) Then
msgbox("is a number")
End If
Edited by abhay1234 because: n/a
Member Avatar for markdean.expres

Thanks. I think this code will help me

Member Avatar for Mitja Bonca

YOu have to use CellValidating event:

Private Sub dataGridView1_CellValidating(ByVal sender As Object, _
    ByVal e _
    As DataGridViewCellValidatingEventArgs) _
    Handles dataGridView1.CellValidating

    Me.dataGridView1.Rows(e.RowIndex).ErrorText = ""
    Dim newInteger As Integer

    ' Don't try to validate the 'new row' until finished 
    ' editing since there
    ' is not any point in validating its initial value.
    If dataGridView1.Rows(e.RowIndex).IsNewRow Then Return
    If Not Integer.TryParse(e.FormattedValue.ToString(), newInteger) _
        OrElse newInteger < 0 Then

        e.Cancel = True
        Me.dataGridView1.Rows(e.RowIndex).ErrorText = "the value must be a non-negative integer"

    End If
End Sub

For more info check here.
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.