Quest: SQL <-- --> ASP.NET DateTime capatibities...

[lewi]

I am looking to read/write a ASP.NET DateTime(.Now for now) obj to/from a
MSDE DB and using VS.NET 2000(on Win2000 Pro). What formats are support by
both SQL & ASP.NET so conversion code is low?...

Any help...

[Nick]

Well if you use parameters from the SqlCommand object and you set
DbType.DateTime you won't have any conversation problems because the class
will handle everything for you. So you will pass a DateTime.Now in and when
you pull it out it will be int he DateTime object format.

"lewi" <bj******@willapabay.org> wrote in message
news:vv************@corp.supernews.com...

I am looking to read/write a ASP.NET DateTime(.Now for now) obj to/from a
MSDE DB and using VS.NET 2000(on Win2000 Pro). What formats are support by
both SQL & ASP.NET so conversion code is low?...

Any help...

[lewi]

> Well if you use parameters from the SqlCommand object and you set

DbType.DateTime you won't have any conversation problems because the class
will handle everything for you. So you will pass a DateTime.Now in and when you pull it out it will be int he DateTime object format.

Strange it working on but eariler I was getting the runtime exception
error...

Thanks anyway...