DataTable.Column.DefaultValue ??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark - 25 May 2006 17:01 GMT

Hi,

I have a DataTable in my DataSet with a "datetime" Column. I can specify a
DefaultValue for this Column using a String such as "01/01/2006" etc but can
I set it to default to today?

Something like ".DefaultValue = DateTime.Today" but do this in the designer
and not in code (if I did it in code then I would have to remember to do it
everytime I create an instance of the DataSet).

Signature

Best regards
Mark

Reply to this Message

Mark Tompkins - 30 May 2006 00:17 GMT

Hello Mark,

I have the same issue and I'm trying to fix it at the DataSet Designer DefaultValue
property.

I have tried Now(), GetDate() and neither are acceptible. Interestingly
at the SQL table level the GetDate() is accepted but does not seem to carrier
over to the DataSet.

Any help would be appreciated.

Kindest,
Mark Tompkins

> Hi,
>
[quoted text clipped - 5 lines]
> designer and not in code (if I did it in code then I would have to
> remember to do it everytime I create an instance of the DataSet).

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...