can i set the value of numeric up down from database in c# window application

Question

1.00/5 (1 vote)

See more:

i want to set the value of Numeric up down control from the database,
i m using this code. but it gives me "Object reference not set to an instance of an object. " error.

NumericUpdown1.Value = Convert.ToDecimal(dr[0].ToString());

anyone please help me

Thanks in advance!

Posted 14-Feb-12 2:55am

jeet786

Add a Solution

Comments

Sergey Alexandrovich Kryukov 14-Feb-12 16:34pm

Could you run it under Debugger? asking such questions makes no sense.
--SA

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)

Paul E Davies · Answer 1 · 2012-02-14T03:16:00

Solution 1

Either dr[0] is null or NumericUpdown1 is null. I would suspect it's dr[0], confirm your query returns a value or check it for being null prior to converting it and assigning the value to your updown control.

Posted 14-Feb-12 3:16am

Paul E Davies

Comments

jeet786 14-Feb-12 9:24am

yes my query returns value from database.
and minimum and maximum value of numeric updown is 1 and 30 respectively

Sergey Alexandrovich Kryukov 14-Feb-12 16:39pm

Don't you see that the whole idea makes no sense, even if it was not null?! Converting to string and then back to numeric type...

Please see my answer.
--SA

Paul E Davies 15-Feb-12 2:28am

As SA suggests run it under a debugger and put a break point on that line (assuming you're using VS) you can then use a watch or locals to see which object is null.

Sergey Alexandrovich Kryukov · Answer 2 · 2012-02-14T10:38:00

Solution 2

The whole idea makes no sense. You have something potentially numeric (dr[0] was not numeric, you could not expect numeric on parsing the string, but in fact it is null), try to convert it to string using ToString, and then try to parse this string back to numeric type Decimal. It tells only one thing: you have no idea what are you doing.

—SA

Posted 14-Feb-12 10:38am

Sergey Alexandrovich Kryukov

Comments

Paul E Davies 15-Feb-12 2:20am

Whilst the question does have problems your "solution" does not answer the question. Sure once we've established why he's getting a null reference exception we can advise on good practise. To say "you have no idea what you are doing" does not help, except perhaps to massage your ego.