C# ACCESS database help

[Jason]

I've got a simple database that I need to create, and then I'll probably use
something like a data grid to display to users. It won't be anything major,
a few tables, maybe one relation, then just display, add, and delete.
Since I've never delt with anything that involves a DB, I have been looking
at alot of different C# books that have chapters on C# and database's. My
question is that I notice everything assumes I've got a SQL serve which is
fine, since it comes with VS 2005 so I could easily follow along with those
example, but when I go to deploy this to my users, in which the Database and
user interface will be installed onto the users PC, will it work, since I
wrote this with SQL?

I could easily get away with ACCESS and Jet database connections but
knowing nothing about databases, deleting cells, adding cells I find it hard
to find any good examples.

Anyone know of any good examples, books, tutorials that would talk about
such a thing?

Thanks ahead of time.

 

[Nicholas Paldino [.NET/C# MVP]]

Jason,

Whatever you do, I implore you to not use Access. Yes, it's a personal
opinion, but I really don't find it useful for anything really.

Instead, use SQL Server Express. It is free, and you can deploy it to
all your users. The great thing about that is that if you decide to upgrade
the server to SQL Server, the code doesn't have to change.

However, if you have multiple users, are you sure you want to have
individual databases on each machine? Why not use SQL Server with the data
in one central place?

 

[Jason]

Hello

I don't work in I.T. at my company, and I don't want to get them involved
for a very small project. A SQL would have to reside on the network, which
is in I.T.'s control.

So, if I do decide to use SQL, can I deploy SQL EXPRESS as part of the MSI
that would install the DB?

Jason,

Whatever you do, I implore you to not use Access. Yes, it's a personal
opinion, but I really don't find it useful for anything really.

Instead, use SQL Server Express. It is free, and you can deploy it to
all your users. The great thing about that is that if you decide to
upgrade the server to SQL Server, the code doesn't have to change.

However, if you have multiple users, are you sure you want to have
individual databases on each machine? Why not use SQL Server with the
data in one central place?


--
- Nicholas Paldino [.NET/C# MVP]
- (e-mail address removed)

I've got a simple database that I need to create, and then I'll probably
use something like a data grid to display to users. It won't be anything
major, a few tables, maybe one relation, then just display, add, and
delete. Since I've never delt with anything that involves a DB, I have
been looking at alot of different C# books that have chapters on C# and
database's. My question is that I notice everything assumes I've got a
SQL serve which is fine, since it comes with VS 2005 so I could easily
follow along with those example, but when I go to deploy this to my
users, in which the Database and user interface will be installed onto
the users PC, will it work, since I wrote this with SQL?

I could easily get away with ACCESS and Jet database connections but
knowing nothing about databases, deleting cells, adding cells I find it
hard to find any good examples.

Anyone know of any good examples, books, tutorials that would talk about
such a thing?

Thanks ahead of time.

 

[=?ISO-8859-1?Q?Arne_Vajh=F8j?=]

I've got a simple database that I need to create, and then I'll probably use
something like a data grid to display to users. It won't be anything major,
a few tables, maybe one relation, then just display, add, and delete.
Since I've never delt with anything that involves a DB, I have been looking
at alot of different C# books that have chapters on C# and database's. My
question is that I notice everything assumes I've got a SQL serve which is
fine, since it comes with VS 2005 so I could easily follow along with those
example, but when I go to deploy this to my users, in which the Database and
user interface will be installed onto the users PC, will it work, since I
wrote this with SQL?

I could easily get away with ACCESS and Jet database connections but
knowing nothing about databases, deleting cells, adding cells I find it hard
to find any good examples.

Anyone know of any good examples, books, tutorials that would talk about
such a thing?

Find a general tutorial on ADO.NET and another on SQL.

Do not worry so much if it is using SQLServer examples.

For simple stuff the difference between SQLServer and Access is:
- SQLServer classnames are SqlXxxx and Access classnames are OleDbXxxx
- you import System.Data.SQLClient and System.Data.OleDb respectively
- different connection string

The basic technique is the same.

Arne

 

[Mark Rae]

I don't work in I.T. at my company, and I don't want to get them involved
for a very small project. A SQL would have to reside on the network,
which is in I.T.'s control.

http://www.microsoft.com/sql/editions/compact/default.mspx

 

[Jason]

Thanks

Over the weekend, I was looking at a C# cookbook and saw an example that
went was in SQL the author went through the same example and made a few
changes for ODBC.