CODEWITHSUNDEEP
vb.netvalidationdatagridviewrestriction
stackexchange12
stackexchange12

Reputation: 652

How to restrict non-numeric input in datagridview

I'm hoping to find out a way to restrict a user from entering any non-numeric input into my datagridviewcolumn. Also I have already restricted the user from entering any negative numbers and from leaving the cell blank. If anyone can find a way to restrict the user from entering letters and non-numeric input I would greatly appreciate it!

If (e.ColumnIndex = 8) Then 'This specifies the column number
        Dim cellData = DataGridView1.Rows(e.RowIndex).Cells(e.ColumnIndex).Value
        If cellData Is Nothing OrElse IsDBNull(cellData) OrElse cellData.ToString = String.Empty Then
            MessageBox.Show("Cannot Be Empty")
            DataGridView1.Rows(e.RowIndex).Cells(e.ColumnIndex).Value = 0
        ElseIf cellData < 0 Then
            MessageBox.Show("Negatives Values Not Allowed")
            DataGridView1.Rows(e.RowIndex).Cells(e.ColumnIndex).Value = 0

            Exit Sub

        End If
    End If

Upvotes: 1

Views: 6883

Answers (2)

TrustedInSci
TrustedInSci

Reputation: 148

You can always use Integer.TryParse().

You can read more about it here: http://msdn.microsoft.com/en-us/library/f02979c7.aspx

Upvotes: 2

Dave H
Dave H

Reputation: 653

Give this a try. If you use the DataGridView.KeyPress event to monitor what was just typed, you can check what that character is with Char.IsDigit(e.KeyChar).

Private Sub DataGridView1_KeyPress(sender As Object, e As     System.Windows.Forms.KeyPressEventArgs) Handles DataGridView1.KeyPress
    If (Char.IsDigit(e.KeyChar)) Then
        'this is a number
    Else
        'not a number
    End If
End Sub

Upvotes: 1

Related Questions