Date From A DataBase

[Eyal]

I Know The Answer Is Probably Something very Easy But I'll Ask Anyway:

 

I Am Upgrading A Project Which Have A Field Of Type Date

And Some Of The Records R Null In It.

When I Try To Bind The Date Field To A DateTimePicker It Thorws Me An Error Because The DateTimePicker Can't Get Null As A Value.

 

I Am Trying To Make The DateTimePicker Get The Null Value And Show An Empty Text And That It Will Return A Null If The Text Is Empty.

 

I Hope Somebody Can Tell Me A Way To Do This

Thank U

[Datahighway]

Try it with the Function IsDBNull()

For More Details see the Framework Docu.

 

Regards DataHighway

[Nerseus]

If you're using binding, you'll have to implement the Format and Parse events. The Format will have to convert the System.DBNull.Value to an empty string (or whatever the DateTime picker wants for a blank value). The Parse will have to convert the empty string to System.DBNull.Value.

 

-Ner