Jump to content
Xtreme .Net Talk

Recommended Posts

Posted

Hi

 

I have a field in my database which stores a persons date of birth, its field type is datetime. When the user is submitting data, this field is optional. If the user does not submit data, then the default date of 01/01/1753 is inserted.

 

My problem occurs when I want to export all the data in the table to a csv file. I fill my dataset as per normal, now for each row in the dataset I am checking if the date of birth column has the default date 01/01/1753. I do not want my users to see the above default date and I am instead trying to remove the data completely, but the column requires that I insert some sort of datetime.

 

Can anyone recommend a possible solution?

 

Mike55.

A Client refers to the person who incurs the development cost.

A Customer refers to the person that pays to use the product.

------

My software never has bugs. It just develops random features. (Mosabama vbforums.com)

Posted
I used DbNull.Value

A Client refers to the person who incurs the development cost.

A Customer refers to the person that pays to use the product.

------

My software never has bugs. It just develops random features. (Mosabama vbforums.com)

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...