How to add boundary values to datagridview column

Question

0.00/5 (No votes)

See more:

The code I used below allows me to only accept integer values in a Column on my DataGridView.

I would now like to know how can I limit it so only the numbers 1 to 5 can be entered, or a message saying "Enter a number 1 to 5" comes up.

Thanks,

What I have tried:

Private Sub dataGVGeneral_CellValidating(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellValidatingEventArgs) Handles dataGVGeneral.CellValidating



If e.ColumnIndex = 3 Then
            If dataGVGeneral.IsCurrentCellDirty Then
                If Not IsNumeric(e.FormattedValue) Then
                    e.Cancel = True
                    MessageBox.Show("Please enter a Number in Priority")
                End If
            End If
        End If
End Sub

Posted 26-Jul-20 18:01pm

Shaheer Rizwan

Updated 26-Jul-20 18:23pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Accepted Answer · 2020-07-26T18:23:00

Try something like:

VB

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 < 1 And newInteger >5) Then
        e.Cancel = True
        Me.dataGridView1.Rows(e.RowIndex).ErrorText = "the value must be an integer between 1 to 5"

    End If
End Sub

To learn and know more, have a look at the following documentations:
Validate Data in DataGridView Control - Windows Forms | Microsoft Docs[^]
DataGridView.CellValidating Event (System.Windows.Forms) | Microsoft Docs[^]
Custom Numeric Edit Elements for DataGridView[^]