C# DataGridView and Numeric data

Question

0.00/5 (No votes)

See more:

Hi
I have a datagridview in my C# application which is bound to an array of user defined objects. Some of the data items in my objects are numeric data type - float and uint to be specific. The data gridview has been populated with data and I am doing the cell level data validation.

During validation, anytime I try to convert data by using Convert.ToSingle() or Convert.ToUInt16(), and if the input cell value is "0", I get a "Input String was not in a correct format" exception. But if my cell value is "00" or any other non-zero numeric value, the convert functions (Convert.ToSingle() or Convert.ToUInt16()) are successful.

I do not understand why "0" input value for Convert.ToSingle() or Convert.ToUInt16() will throw a format exception. Any idea what I should do to prevent this exception? I appreciate any help!

Thanks
K

Posted 11-Aug-10 3:43am

Kalyani Kailasamoni

Add a Solution

2 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)

OriginalGriff · Answer 1 · 2010-08-11T03:56:00

I suspect that it's your other code that is the problem - I tried it here with the code below and had no problem. Check you are actually accessing the right cell, and post a code fragment if necessary. It may be worth your using Singe.TryParse rather than Convert.ToSingle, as that reports problems via a bool, rather than excepting on user input.

String s = "0";
Single si = Convert.ToSingle(s);
if (Single.TryParse(s, out si))
    {
    ...
    }

Kalyani Kailasamoni · Answer 2 · 2010-08-11T05:10:00

Hi
Thank you for your response. I tried the piece of code you posted, I still have the exception raised in Convert.ToSingle(s). Then I commented Convert.ToSingle(s) and the TryParse() was successful, when I had the hardcoded string as "0".

But the TryParse() is not successful with the datagridview input as "0". Here is the piece of code, which is giving me the issue:

private void LKDataGridView_CellValidating(object sender,
           DataGridViewCellValidatingEventArgs CellEvent)
{
    Single TempFloatVal = 0.0f;
    switch ((ELKCol) CellEvent.ColumnIndex)
    {

      case ELKCol.Delta:
         if (Single.TryParse(CellEvent.FormattedValue.ToString(),
                               out TempFloatVal))
             MessageBox.Show("Value of Delta: " +
                              TempFloatVal.ToString());
         else
             MessageBox.Show("Input value: " +
                   CellEvent.FormattedValue.ToString());

          break;

       default:   break


     }
}

The data type for "Delta" is float. Any time i have non-zero numeric value entered for Delta in datgridview, Single.TryParse() succeeds. Any time I enter a 0 value for Delta in datgridview, Single.TryParse() fails.

I just am not able to figure out what is going on. Any suggestions is very much appreciated!

Thanks
K

C# DataGridView and Numeric data

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0