Custom data type conversion in DataAdapter


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,


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question