Check for DBEmpty like DBNull in C#

Question

I have a table Employee having a column JoiningDate of type DateTime.

I am fetching this value in asp.net.

I know to check DBnull we use dr["JoiningDate"] != DBNull.Value .

But if this JoiningDate is empty like '', which fetching it is making it like 1/1/1900.

What is the best way to check DB EMPTY in asp.net for a datetime column.

Details :

JoiningDate is a DateTime field..I made it empty string in stead of NULL..

And while fetching this in asp.net in dr["JoiningDate"] which is a datarow, it gave 1/1/1900.

Code Example

DataSet dsEmployee = null;
dsEmployee = Data.Select("SELECT * FROM Employee WHERE EmployeeID = '" + _id + "'");

DataRow drEmployee = dsEmployee.Tables[0].Rows[0];

if(drEmployee["JoiningDate"] != string.Empty)
{

}

You need a bit more detail in your question. What SQL server? What data types are the SQL column and the C# variable? Some additional sample code (for context) would be nice, too. — Xcelled
– Xcelled, Commented Jul 31, 2013 at 7:23
How is it automatically fetching it as 1/1/1900, Can you show the select i guess somwething there is doing the transform or is it the default value for that column ? — V4Vendetta
– V4Vendetta, Commented Jul 31, 2013 at 7:36

Microsoft DN · Accepted Answer · 2013-07-31 07:25:44Z

0

Try this-

 if(!String.IsNullOrEmpty(Convert.ToString(dr["JoiningDate"])))
 {

 }

answered Jul 31, 2013 at 7:25

Microsoft DN

10.1k10 gold badges54 silver badges74 bronze badges

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

Comments

A.T. · Accepted Answer · 2013-07-31 07:27:41Z

0

you can do something like this to check...

 if(  dr["JoiningDate"] != DBNull.Value && (DateTime)dr["JoiningDate"] != DateTime.Parse("1/1/1900")) {
//do...
}

answered Jul 31, 2013 at 7:27

A.T.

26.7k8 gold badges50 silver badges68 bronze badges

Comments

Mahmoud Gamal · Accepted Answer · 2013-07-31 07:28:36Z

0

if(string.IsNullOrEmpty(........))
{

......

}

edited Jul 31, 2013 at 7:28

Mahmoud Gamal

80.2k18 gold badges143 silver badges168 bronze badges

answered Jul 31, 2013 at 7:27

FlemGrem

8144 silver badges9 bronze badges

Comments

Ehsan · Accepted Answer · 2013-07-31 07:29:17Z

0

You have to edit your check like this

if(dr["JoiningDate"] != DBNull.Value && !string.IsNullOrEmpty(Convert.ToString(dr["JoiningDate"])))
{
     //Your Code
}

answered Jul 31, 2013 at 7:29

Ehsan

32.8k6 gold badges61 silver badges66 bronze badges

Comments

V4Vendetta · Accepted Answer · 2013-07-31 07:41:05Z

0

If you say dr["JoiningDate"] is not returning null then

you are changing the value in the SELECT query
The default value of the column is set to 1/1/1900

Also please check where you insert the records in that case you would be passing null for that particular column so that it assumes the default value which is being returned

So you should rely on checking the condition by making a DateTime instance like new DateTime(1900,1,1) and then compare

answered Jul 31, 2013 at 7:41

V4Vendetta

38.5k9 gold badges83 silver badges84 bronze badges

Collectives™ on Stack Overflow

Check for DBEmpty like DBNull in C#

Details :

Code Example

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Details :

Code Example

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related