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

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\" />";
                         }

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

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

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

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us