Jason,
I've got VS.net 2005 and since I am a novice, I've
been reading through books, that pertain to C# 2005.
All the examples I find are making a SQL connection and use the MSDE.
Yes, many code examples available use SQL Server as the example database,
because in many applications don't find Access to be a robust enough
database. But the other side of the coin is that at least Microsoft is a
company doing business for money. There's obviously more money to be made
with SQL Server than Access.
One way or other, I agree that there could be more basic Access material
available. But even so, there's a lot of material available, trust me!
Thats great if you download and install that, but if I do will my clients
also need to do that same?
The short answer is, yes, they would. If you write your C# application to
use SQL Server, then one has to be available. For simple solutions/single
user databases, Access is usually just fine.
Can I use ADO Jet to connect to a MS Access DB.
Yes, you definitely can. You would just have to use the OLEDB provider, and
a different connection string. That's basically all you need, although this
isn't just so simple in practice. See this page for example, or your Visual
Studio documentation under Data Access:
http://msdn.microsoft.com/library/en...onetanchor.asp
Or:
http://samples.gotdotnet.com/quickstart/winforms/
Do you know of any examples that connect to the Northwind DB so I can use
something else as a working example rather then having to involve MSDE.
I think there's an Access version of the Northwind database available, but
then again I haven't been using Access much. In any case, here one tutorial
for you:
http://msdn.microsoft.com/library/de...dotutorial.asp
And another:
http://www.csharphelp.com/archives/archive70.html
Try googling with "C# data access oledb" and you should find plenty more
tips. Make also sure you read through your Visual Studio documentation,
there's a lot to learn!
Good luck!
--
Regards,
Mr. Jani Järvinen
C# MVP
Helsinki, Finland
ja***@removethis.dystopia.fi http://www.saunalahti.fi/janij/