Parse From Sring to integer value

Question

1.00/5 (1 vote)

See more:

SQL-Server-2005

, +

Hi To All!! I want Text Box to accept Only Integer value so made one dll of text box like costume control.Now my question is that is there any need to parse the value of text box.
Because when i write like this

cmd.Parameters.Add(new SqlParameter("@PRollno", int.Parse(txtrolnum.Text)));

it gives error "Input String not in a correct format"

so i did this

cmd.Parameters.Add(new SqlParameter("@PRollno", txtrolnum.Text));

now program is working properly,I just want to know what is the reason behind this. I am fresher in c#.
thanks in advaance.
But earlier the same code were run perfectly.In backend i used int datatype and allow not null value..

Posted 26-Apr-13 1:53am

Arifa S

Updated 26-Apr-13 5:23am

v2

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 · 2013-04-26T02:07:00

If Int.Parse is returning "Input String not in a correct format", then there is a character (or characters) that are not correct for the current culture on the PC running the Paste operation. For example, the number in the textbox may use UK numbering: "1,234,567.89" where the PC culture is set to German or Greek: "1.234.567,89"

The computer running the SQL server may well be set to a different locale and interpret it correctly.

But why not have your custom control return a numeric value instead of a string? Just like the NumericUpDown control does? Then there is no need for conversion either way and confusion is removed. (Or use a NumericUpDown control instead)

Sergey Alexandrovich Kryukov · Answer 2 · 2013-04-26T05:03:00

Of course you should parse properly and take care about proper string format, take care of the culture you use, all of that.

But I think the problem is deeper and simpler. How come you store a string in your database, where the semantic requires to have a numeric type? I don't know why, but it looks like one problem really haunts the beginners these days: trying to work with strings representing data, instead of data itself. If you wan to work with numbers use the types like numeric, real, smallint, smallmoney and the like.

Please see: http://msdn.microsoft.com/en-us/library/ms187594%28v=sql.90%29.aspx[^].

—SA

Parse From Sring to integer value

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0