validating data in data gridview using c#.net

Question

0.00/5 (No votes)

See more:

Hello and Hi. Good Day.

I have a question. Im using a Datagridview. One of my cell I want to enter only a numeric number. How can I do it or what is the best example of codes. Please Help me.
for ex one of my column contains no of days i want to enter their only numeric values it should not allow alphabets...

help me plz

Thanks.

Posted 10-Jul-12 1:49am

Member 9068558

Updated 10-Jul-12 1:54am

v2

Add a Solution

Comments

AmitGajjar 10-Jul-12 8:43am

You have already posted same question. do not post your question again and again. user Improve question to change your question detail.

4 solutions

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)

Prasad_Kulkarni · Answer 1 · 2012-07-10T02:02:00

Solution 1

Try this:

C#

private void dataGridView1_CellValidating(object sender, DataGridViewCellValidatingEventArgs e)
    {

      if (e.ColumnIndex == dataGridView1.Columns["int1"].Index) //this is numeric column
      {
        int i;
        if (!int.TryParse(Convert.ToString(e.FormattedValue), out i))
        {
          e.Cancel = true;
          MessageBox.Show("must be numeric");
        }
      }

Refer details:
http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridview.cellvalidating.aspx[^]

Posted 10-Jul-12 2:02am

Prasad_Kulkarni

v2

Comments

Member 9068558 10-Jul-12 8:09am

sorry to ask u again...i dont want any msg of validation i just want to restrict alphabets to enter by using keypress event

Prasad_Kulkarni 10-Jul-12 9:16am

Man, what is this?? Just simply comment that line. Or should I need to tell you how to do that?
Well then move your cursor to MessageBox.Show line and simply press ctrl + c and ctrl + k to make it comments

Pete O'Hanlon · Answer 2 · 2012-07-10T02:31:00

Solution 4

An easy way to do this is to add a custom DataGridView column which hosts a MaskedTextBox. There's an example available here[^].

Posted 10-Jul-12 2:31am

Pete O'Hanlon

Comments

pradiprenushe 10-Jul-12 8:40am

I just forget concept as i am not having hand on window application. Thanks

pradiprenushe · Answer 3 · 2012-07-10T02:28:00

Solution 3

C#

private void textBox1_KeyPress(object sender, KeyPressEventArgs e)
{
   if (e.KeyChar >= 48 && e.KeyChar <= 57)
            {
        e.Handled = true;
    }

   
}

Posted 10-Jul-12 2:28am

pradiprenushe

Comments

Member 9068558 10-Jul-12 8:33am

i know how to keep validation in textbox...i want to keep validation in data gridview

**AmitGajjar** · Answer 4 · 2012-07-10T02:41:00

Solution 5

Hi,

You can also use javascript to check if entered value is numeric or not.

Check this link[^]

Let me know if you have any query.

Thanks
-Amit.

Posted 10-Jul-12 2:41am

AmitGajjar