Custom data type conversion in DataAdapter

  • Thread starter Thread starter Olivier Oswald
  • Start date Start date
O

Olivier Oswald

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
 
Back
Top