Access db to ado.net data type conversions?

B

Brian Henry

is there info about data type conversions between access to ado.net? I have
tried a lot of the ones that say oledb data types should work for and get a
lot of "data type mismatch" errors using them.. is there a sheet somewhere
or a refrence for them? all i really need to know is

Access ADO.NET
Numeric Integer/numeric?
Memo VarWChar?
Text VarWChar?
Date/Time ? (dbdate never seems to work)
Yes/No Boolean

what are the correct conversions of oledb.oledbtype? thanks!
 
W

WizyDig

I'll give a very simple way to solve your problem and hopefully help you
stream line your develpment. Open a connection to you access mdb using the
server expolerer. Drag the table you want to use onto your form this will
create a connection object and a data adpater. Look on the tool bar for the
Data menu item click on it the click generate dataset. This will give you a
strongly type dataset that you can use through out your app.

FYI you can even specify which column you want by opening up the table and
highlighting specific fields. You can also change these by opening the data
adapters select commands text attribute. it will open a query builer that
will allow to build what ever type of query make you happy.

Hope this helps you!

-Wiz
 
P

Paul Clement

¤ is there info about data type conversions between access to ado.net? I have
¤ tried a lot of the ones that say oledb data types should work for and get a
¤ lot of "data type mismatch" errors using them.. is there a sheet somewhere
¤ or a refrence for them? all i really need to know is
¤
¤ Access ADO.NET
¤ Numeric Integer/numeric?
¤ Memo VarWChar?
¤ Text VarWChar?
¤ Date/Time ? (dbdate never seems to work)
¤ Yes/No Boolean
¤
¤ what are the correct conversions of oledb.oledbtype? thanks!
¤

OLE fields are System.Data.OleDb.OleDbType.LongVarBinary

You can compare the System.Data.OleDb.OleDbType enum with ADOX.DataTypeEnum in order to determine
the corresponding data column types.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 

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

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top