how to check integer column if it is null value or zero store in datatable c#

Question

0.00/5 (No votes)

See more:

I have one table in which it store null value for integer column when I insert the value only string. There are some string column and some integer whenever I update any integer column it update all the integer column by zero.
In my code I want to check the if it is null/zero. I use the DBNull.Value but its only check for null not for zero i want to check both at a time.
Can anyone help me please.

My code is as follow

if (dt.Rows[i]["IsSaved"]!=DBNull.Value && dt.Rows[i]["IsApplied"]!=DBNull.Value)
                                 {
                                     str += " <input style=\"border: none;background-color:gray;\" id=\"unsave" + JobID + "\" type=\"button\" class=\"log_in\" value=\"UNSAVE\" onclick=\"ShowCurrentTime(" + JobID + ",'unsave')\"/>" +
                                         " <input style=\"border: none;background-color:gray;\" id=\"applied" + JobID + "\" type=\"button\" class=\"sign_up_cc\" value=\"APPLIED\" />";
                                 }

Posted 10-Dec-15 17:45pm

asplover1

Add a Solution

2 solutions

Solution 1

C#

if (dt.Rows[i]["IsSaved"]!=DBNull.Value && dt.Rows[i]["IsApplied"]!=DBNull.Value     &&     dt.Rows[i]["IsSaved"]!=0 && dt.Rows[i]["IsApplied"]!=0)
                                 {
                                     str += " <input style=\"border: none;background-color:gray;\" id=\"unsave" + JobID + "\" type=\"button\" class=\"log_in\" value=\"UNSAVE\" onclick=\"ShowCurrentTime(" + JobID + ",'unsave')\"/>" +
                                         " <input style=\"border: none;background-color:gray;\" id=\"applied" + JobID + "\" type=\"button\" class=\"sign_up_cc\" value=\"APPLIED\" />";
                                 }

Posted 10-Dec-15 18:00pm

Arasappan

Comments

asplover1 11-Dec-15 6:00am

Thanks for reply

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)

asplover1 · Accepted Answer · 2015-12-10T23:58:00

I solve this problem using this code

if ((dt.Rows[i]["IsSaved"].Equals(DBNull.Value) ? 0 : Convert.ToInt32(dt.Rows[i]["IsSaved"] ?? "0")) != 0 && (dt.Rows[i]["IsApplied"].Equals(DBNull.Value) ? 0 : Convert.ToInt32(dt.Rows[i]["IsApplied"] ?? "0")) != 0)
                         {
                             str += " <input style=\"border: none;background-color:gray;\" id=\"unsave" + JobID + "\" type=\"button\" class=\"log_in btn_sm\" value=\"UNSAVE\" onclick=\"ShowCurrentTime(" + JobID + ",'unsave')\"/>" +
                                 " <input style=\"border: none;background-color:gray;\" id=\"applied" + JobID + "\" type=\"button\" class=\"sign_up_cc btn_sm\" value=\"APPLIED\" />";
                         }