Programming against MS Access using C#

[=?Utf-8?B?QmVu?=]

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]

Re: Programming against MS Access using C#

On 13/11/2008 in message
<C9CC6AE7-FAE0-46C5-B478-8E6A686462A8@mi crosoft.comBen wrote:

>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 Damerham Hampshire UK
By the time you can make ends meet they move the ends

[Mark Rae [MVP]]

Re: Programming against MS Access using C#

"Ben" <Ben@discussion s.microsoft.com wrote in message
news:C9CC6AE7-FAE0-46C5-B478-8E6A686462A8@mi crosoft.com...

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.

Can you please clarify whether you mean simply using a Jet database (i.e.
the one which Access uses) as a data repository, or actually instantiating
Access so that you can work with e.g. forms and reports etc... There's a
world of difference...


--
Mark Rae
ASP.NET MVP

http://www.markrae.net

[Mark Rae [MVP]]

Re: Programming against MS Access using C#

"Jeff Gaines" <whitedragon@ne wsgroups.nospam wrote in message
news:xn0fxmeppc nvypd000@msnews .microsoft.com. ..

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 a Jet db using
either Adobe or ADO.NET (the preferred way now).

Adobe? Do you mean ADODB?


--
Mark Rae
ASP.NET MVP

http://www.markrae.net

[Jeff Gaines]

Re: Programming against MS Access using C#

On 13/11/2008 in message <OVDSryXRJHA.50 80@TK2MSFTNGP03 .phx.gblMark Rae
[MVP] wrote:

>"Jeff Gaines" <whitedragon@ne wsgroups.nospam wrote in message
>news:xn0fxmepp cnvypd000@msnew s.microsoft.com ...
>

>>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 a Jet db using
>>either Adobe or ADO.NET (the preferred way now).

>
>Adobe? Do you mean ADODB?

Oh dear, Freudian slip!

--
Jeff Gaines Damerham Hampshire UK
640k ought to be enough for anyone.
(Bill Gates, 1981)

[sloan]

Re: Programming against MS Access using C#


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

http://sholliday.space s.live.com/Blog/cns!A68482B9628 A842A!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.

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





"Ben" <Ben@discussion s.microsoft.com wrote in message
news:C9CC6AE7-FAE0-46C5-B478-8E6A686462A8@mi crosoft.com...

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

[=?UTF-8?B?QXJuZSBWYWpow7hq?=]

Re: Programming against MS Access using C#

Ben wrote:

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