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
"Brian Henry" <br******@adelp hia.net> wrote in message
news:uB******** ******@TK2MSFTN GP12.phx.gbl...
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!
