vb 2008 - datagrid column

[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

[abhay1234]

You can use the IsNumeric boolean property

If(IsNumeric(...)) Then
msgbox("is a number")
End If

[markdean.expres]

Thanks. I think this code will help me

[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.