empty date field in the datagrid

I have a column in SQL database table with date datatype. If user does not enter date in this field adding a new record the datagrid displays 1/1/1900. How can I avoid this and display an empty cell? Please, help.
MarinasoutAsked:
Who is Participating?
 
bladefistConnect With a Mentor Commented:
maybe your database puts that date as a default. Visual Basic wouldnt just randomly do that. Check your database metadata
0
 
ampapaCommented:
Are you sure the field is empty? The field should be NULL if it is truly empty. It looks like something is being added to the record as indicated by what usually is an invalid date "1/1/1900"?
0
 
MarinasoutAuthor Commented:
Hi, bladefist
you area right. Database puts that date as default. How can I check metadata?
0
 
planoczCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
No response from Marinasout from 12/12/2003 comment
Award points to bladefist is recommend.
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

planocz
EE Cleanup Volunteer
0
 
MarinasoutAuthor Commented:
Yes, the field was NULL and in this case it shows 1/1/1900. To avoid this i added requird field validator. Thank you. I accepted the answer.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.