Programming against MS Access using C#

[Ben]

Hi all,

Is there any good resource online that you can share with me about
programming Access using C#. I am trying to get my feet wet with C# and
vs2008.

I tried looking at kb317114, it didn't seem to offer much. If you have some
more code samples, please let me know.

Thanks,

Ben

--

 

[Jeff Gaines]

Hi all,

Is there any good resource online that you can share with me about
programming Access using C#. I am trying to get my feet wet with C# and
vs2008.

I tried looking at kb317114, it didn't seem to offer much. If you have
some
more code samples, please let me know.

I put something up on the Code Project:
http://www.codeproject.com/KB/XML/CreateXMLDB.aspx

it's not a tutorial but it will produce classes to access an Access db
using either Adobe or ADO.NET (the preferred way now). I have updated it
quite a lot but not re-submitted it, if it's of interest email me and I'll
send you a zip of the latest source which produces better code.

 

[Jeff Gaines]

Adobe? Do you mean ADODB?

Oh dear, Freudian slip!

 

[sloan]

I have a ~basic sample of using a JET database (using a .mdb file as a
datasource) at:

http://sholliday.spaces.live.com/Blog/cns!A68482B9628A842A!176.entry

It uses IDataReaders to talk to a JET database. I also show how to use
multiple IDataReaders to populate a single (multi tabled) strong DataSet.
Since JET does not support multiple ResultSet(s) per single query....this is
a work around.

................

 

[Arne Vajhøj]

Is there any good resource online that you can share with me about
programming Access using C#. I am trying to get my feet wet with C# and
vs2008.

I tried looking at kb317114, it didn't seem to offer much. If you have some
more code samples, please let me know.

Any tutorial about ADO.NET should do. For Access you just need to
use OleDbXxxx classes and the correct connection string.

Arne