asked on

Nullable System.DateTime in Web.Config (System.DateTime?)

I use the Stored Procedure Profile Provider in my ASP.NET web Project.

One of the values I need to store on the User Object is called PaymentDate. The datatype need to be DateTime, but since the value can be NULL I need the datatype it to be nullable.

In web.config I do like this:

<add name="PaymentDate" defaultValue="[null]" type="System.DateTime?" customProviderData="PaymentDate;DateTime;8" />

Open in new window

The code compile, and everything seems to work fine. But, when I open the web page I get a web.config error saying "Cannot load type System.DateTime?".

If I change "System.DateTime?" to "System.DateTime" it is not possible to set p.PaymentDate = null; (PaymentDate cannot be null).

So, how can I set the PaymentDate Type to be Nullable DateTime in web.config?

kaufmed

Try this:

type="System.Nullable<System.DateTime>"

Open in new window

SOLUTION

Vikram Singh Saini

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

webressurs

ASKER

kaufm:

When writing type="System.Nullable<System.DateTime>" I get the error : Tag was not closed. When running the website I get the error: Configuration file is not well-formed XML.

ASKER CERTIFIED SOLUTION

kaufmed

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial