Data Grid View question

Question

1.18/5 (3 votes)

See more:

how do i get this code to accept numbers 0-7 only

If (e.ColumnIndex = 4) Then   ' Checking numeric value for Column 4 only
    Dim value As String = DataGridView1.Rows(e.RowIndex).Cells(e.ColumnIndex).Value.ToString()
    For Each c As Char In value
        If Not Char.IsDigit(c) Then
            MessageBox.Show("Please enter number 0-7 only.", "Input Error", _
                            MessageBoxButtons.OK, MessageBoxIcon.Error)
            DataGridView1.Rows(e.RowIndex).Cells(e.ColumnIndex).Value = String.Empty
            Exit Sub
        End If
    Next

Posted 15-Aug-13 6:10am

PythonProgrammer

Updated 15-Aug-13 6:13am

Richard C Bishop

v2

Add a Solution

Comments

JasonMacD 15-Aug-13 12:27pm

It may be easier to use a drop down list, and let the user select hard coded values between 0-7. You will then have the SelectedIndex and SelectedValue with which you can work with. Just a thought. If it were a much larger range then a textbox would be optimal

PythonProgrammer 15-Aug-13 12:28pm

that is what i was going to do but the company does not want me to do that

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)

Thomas Daniels · Accepted Answer · 2013-08-15T06:29:00

Solution 1

Try:

VB

For Each c As Char In value
    Dim i As Integer = -1
    If Not (Int32.TryParse(c, i) AndAlso i >= 0 AndAlso i <= 7) Then
        ' your other code here

[UPDATE]

If you don't want to split the value into seperate chars, try this:

VB

Dim i As Integer = -1
If Not (Int32.TryParse(value, i) AndAlso i >= 0 AndAlso i <= 7) Then
    ' your other code here

If you use this code, DON'T use a For Each loop!

Posted 15-Aug-13 6:29am

Thomas Daniels

Updated 15-Aug-13 6:36am

v2

Comments

PythonProgrammer 15-Aug-13 12:31pm

i just used that you just gave me..however if i do a number like 12 it does not show the error

Thomas Daniels 15-Aug-13 12:34pm

The reason is: '12' is split in two chars: '1' and '2'. Because both are between 0-7, you don't get an error. I'll update my answer.

Thomas Daniels 15-Aug-13 12:36pm

I updated my answer. Use the second code.

PythonProgrammer 15-Aug-13 12:35pm

thank you very much

Thomas Daniels 15-Aug-13 12:36pm

You're welcome!

PythonProgrammer 15-Aug-13 12:38pm

thank u very much with the code i gave you at the top in my question how would you get a column to accept negative values

Thomas Daniels 15-Aug-13 12:40pm

Just use my second code, and change the range: change '0' into the minimum number (this number can be negative), and change '7' into the maximum number (this number can also be negative).

PythonProgrammer 15-Aug-13 12:42pm

thank you for all your help i have more questions but i dont wanna take all ur time

PythonProgrammer 15-Aug-13 12:47pm

i have a very tough formatting question if you can help that would be aweseome

Thomas Daniels 15-Aug-13 12:51pm

I'll try to help you. I can't promise that I can help you, but I'll try it.

PythonProgrammer 15-Aug-13 12:53pm

i have column 7 for total, column 8 for total v/f, and column 9 for total pa

in column 10...i want a Y to show up if the values in those three columns equal
col 7...>=14
col 8...>=35
col 9 >=2000
and if those values do not occur than an n will show in column 10

Thomas Daniels 15-Aug-13 13:29pm

Try:
If New Integer() {col7value, col8value, col9value}.SequenceEqual() Then
' show y in column 10
Else
' show n
End If

PythonProgrammer 15-Aug-13 13:49pm

that did not work...
for col 7...if the number in the column isnt greater than 14 then show n in col 1o
for col 8 ..if the number in the column isnt greater than 35 then show n in col 10
for col 9 .. if the number in column isnt greater than 2000 then show n in col 10

else show y

how do you code tht
ps thanks for all the help

Thomas Daniels 15-Aug-13 14:42pm

Create seperate if statements. Inside these statements, show n in col10. Outside the if statements, show y if the value in col10 isn't yet set.

PythonProgrammer 15-Aug-13 14:45pm

please make changes to this code to make it as exact as possilbe
if (e.columnIndex = 7) then
Dim value as string =DataGridView1.Rows(e.RowIndex).Cells(e.ColumnIndex).Value.ToString()
if value >= 14 then show n
else if
show y
end if