PC Review


Reply
Thread Tools Rate Thread

Custom data type conversion in DataAdapter

 
 
Olivier Oswald
Guest
Posts: n/a
 
      23rd Jul 2003
I'm using the OleDbDataAdapter to fill a DataSet with rows from an
Access table.

My problem: in the database, date/time values are stored as strings
formatted as "yyyyMMddHHmmss". However, in the DataSet I need these
values as .NET DateTime type.

As the DataAdapter cannot convert these types properly, I have to do
this manually, but I couldn't find a way to hook into the
DataAdapter's conversion process.

I could handle this at the business objects level but I would really
prefer to have it build into the DataAdapter. Because that's what this
class is for: data mapping and conversion

Any ideas? Thanx,
Olivier
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. M. Bruil Microsoft Access 2 26th Mar 2009 08:30 AM
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. M. Bruil Microsoft Access 0 25th Mar 2009 08:10 PM
Changing the data type of dataadapter? xlar54 Microsoft C# .NET 1 26th Jul 2008 09:50 AM
Data type conversion Thomas Beyerlein Microsoft VB .NET 1 8th Jun 2005 03:53 PM
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. luna Microsoft ASP .NET 1 13th Feb 2004 01:15 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:57 AM.