473,320 Members | 1,861 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Programming against MS Access using C#

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

--

Nov 13 '08 #1
6 3457
On 13/11/2008 in message
<C9**********************************@microsoft.co mBen 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
Nov 13 '08 #2
"Ben" <Be*@discussions.microsoft.comwrote in message
news:C9**********************************@microsof t.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

Nov 13 '08 #3
"Jeff Gaines" <wh*********@newsgroups.nospamwrote in message
news:xn****************@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

Nov 13 '08 #4
On 13/11/2008 in message <OV**************@TK2MSFTNGP03.phx.gblMark Rae
[MVP] wrote:
>"Jeff Gaines" <wh*********@newsgroups.nospamwrote in message
news:xn****************@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?
Oh dear, Freudian slip!

--
Jeff Gaines Damerham Hampshire UK
640k ought to be enough for anyone.
(Bill Gates, 1981)
Nov 13 '08 #5

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.

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

"Ben" <Be*@discussions.microsoft.comwrote in message
news:C9**********************************@microsof t.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

--

Nov 13 '08 #6
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
Nov 15 '08 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

21
by: Jon Slaughter | last post by:
I have a class that is basicaly duplicated throughout several files with only members names changing according to the class name yet with virtually the exact same coding going on. e.g. class...
2
by: Hans Kamp | last post by:
I am programming an easy game (not with a commercial purpose, just with learning purpose), but I doubt whether the following way of programming is proper or advisable. The main form...
9
by: Michael Lindsey | last post by:
I need to write a server app to send images to client GUIs that are outside of the server's domain. The client will have the file system path to the image but can not access the file system. I am...
42
by: Kevin Spencer | last post by:
Is it just me, or am I really observing a trend away from analysis and probem-solving amongst programmers? Let me be more specific: It seems that every day, in greater numbers, people are coming...
4
by: Java Challenge | last post by:
I am trying to work hard to become a programmer and eventually get a job as a programmer, I have a low paying job at the moment as technical support and a family to maintain. 1 - I started to...
55
by: pduncan00 | last post by:
I've been reading here frequently, and I'm finally posting. Can anybody recommend a textbook to replace K&R2? It should explain all of the new C99 features.
29
by: SG | last post by:
Hi everyone, I am a complete novice at computers and programming and right now, all i need to know is that why do many people prefer C to C++? Is it just because they are used to using C and are...
51
by: bigHairy | last post by:
Hello. I have been teaching myself .NET over the last few months and have had some success. I would like to ask a question though... A number of examples I have followed have the following in...
1
weaknessforcats
by: weaknessforcats | last post by:
C++: The Case Against Global Variables Summary This article explores the negative ramifications of using global variables. The use of global variables is such a problem that C++ architects have...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.