How to handle Nullable Datetime with 3 tier in asp.net 2.0 (VB)


shivam

Hi there,

This is a way too broad question and simply begs for a Google search on the topic and some serious reading and self study.

Did you do that? Did you already read up a little about nullable types? If so, do you have any specific questions?

And to what chapter of the book is this related?

Imar
---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Thanks for reply.
It is not related to any chapter but in whole book there is no mention of how to handle nullable value. In practical time we come accross very often where we want null value in database.
As per book i am making 3 tier architecture whenever i am using datetime field i have to compularily fill the date in practise it is not possible.
Shortly i want to keep textbox of datetime to be inserted as null value in database & also how to handle with datareader.
Thanks

shivam

You can declare your date times as nullable date times. Then, whenever you need them you can use the Value and HasValue properties to get at the actual date.

With a reader, you would check for IsDBNull and only when it isn't assign the value from the reader to the DateTime object.

HtH,

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.