How to fillter the database null values of integer column in C# using if condition?

Question

I am passing data value, to a database, using integer data type (accepting null).

If in front-end I do not pass any integer it takes null value in db. While retrieving table data in front-end I am using if condition to filter the integer empty values. I have only integers to display, how to write the if condition?

int x;
if(x!=(which code this place write)
{
textbox.text=x; //x value not empty working if condition else goto else condition
}
else
{
}

what if condition you have tried?

Maheep
– Maheep

2011-12-13 06:37:07 +00:00
Commented Dec 13, 2011 at 6:37 — Maheep
– Maheep, Commented Dec 13, 2011 at 6:37
Please rephrase your question. Edit your post and add code.

KV Prajapati
– KV Prajapati

2011-12-13 06:43:21 +00:00
Commented Dec 13, 2011 at 6:43 — KV Prajapati
– KV Prajapati, Commented Dec 13, 2011 at 6:43
Why use if and not LINQ?

atoMerz
– atoMerz

2011-12-13 07:06:41 +00:00
Commented Dec 13, 2011 at 7:06 — atoMerz
– atoMerz, Commented Dec 13, 2011 at 7:06

Neha · Accepted Answer · 2011-12-13 08:08:54Z

1

 if (dt.Rows[0]["ToAge"] == DBNull.Value)

Hope it helps

answered Dec 13, 2011 at 8:08

Neha

3,0153 gold badges21 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Chun Lin Yen · Accepted Answer · 2011-12-13 06:46:38Z

0

if you are using Entity Framework ,you could use

if(yourvalue.HasValue){ ...}

answered Dec 13, 2011 at 6:46

Chun Lin Yen

392 bronze badges

1 Comment

Kamil Over a year ago

It is not working for integers. Integers has not "HasValue" property

NoviceProgrammer · Accepted Answer · 2012-10-30 12:40:05Z

0

Not clear from your question but I guess you want to use DBNull

ex:

if(your value == System.DBNull.Value)

edited Oct 30, 2012 at 12:40

answered Dec 13, 2011 at 6:43

NoviceProgrammer

3,3651 gold badge25 silver badges32 bronze badges

Collectives™ on Stack Overflow

How to fillter the database null values of integer column in C# using if condition?

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related