"Jason" <some***@ms.net> wrote in message
news:eTRP1HKeHHA.1220@TK2MSFTNGP03.phx.gbl...
> 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]" <mvp@spam.guard.caspershouse.com> wrote in
message news:%23ShX2dKeHHA.3272@TK2MSFTNGP03.phx.gbl...
> 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]
>          - mvp@spam.guard.caspershouse.com
>
> "Jason" <some***@ms.net> wrote in message
> news:eTRP1HKeHHA.1220@TK2MSFTNGP03.phx.gbl...
>> 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.
>>
>>
>>
>
>

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

"Arne Vajhøj" <a***@vajhoej.dk> wrote in message
news:4616f47d$0$90276$14726298@news.sunsite.dk...
> Jason wrote:
>> 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