Creating Simple desktop database application

I am here to write a small database application that will be running in desktop (offline mode).

I am using MSAccess 2007 as my database file and trying to write code in vb.net.

I used to write the code vb6 an usually had global variables for storing database connection and executing every query from that.

I am trying to upgrade myse开发者_如何学Golf from vb6 to vb.net.

do i need to read some more simple starter books also?

In .NET, talking to a database is handled with ADO.NET, which uses something called "connection pooling". The connection pool is basically a collection of open connections to your database that ADO.NET manages for you. In your code, when you create and open a Connection object, ADO.NET first looks in the connection pool to see if it already has an open connection to your data source, and if it finds one it uses that (instead of actually creating and opening a new connection). When you close your connection, ADO.NET does not really close it, but instead returns it to the connection pool.

Therefore, you do not need (and in face do not want) to maintain open connection objects inside your application (in a global variable or anywhere). The correct approach with data access in ADO.NET is to create and Open a Connection object, do whatever you need to do with the database, and then Close and Dispose your Connection.

Store the connection string in the config file (in the solution explorer, open the My Project folder and doubleclick on Settings.settings).

I'd suggest that you create one or more classes to contain your database code and let those classes convert between the database data and your application objects, most VB6 projects I saw had the GUI hard linked to the DB which can make future maintenance or new features very difficult and limits the possiblity of code reuse.

If you've got VB6 experience I'd thought that you could probably start trying to create the application right away but you should definitely read either a good book or good articles about it at the same time so that you pick up things like that you need to Dispose of your database objects after user etc.

It's probably a good idea to get a book, a lot has changed since VB6.

Also consider using a more robust db, like SQL compact or SQLite. It will allow you you use the Entity Framework which will make writing your app a whole lot easier.