Here is a tutoral or a novice programmer. This tutorial assumes you have a basic knoladge of databases and VB.NET. It also assumes that you have a MS access database named Testdb.mdb with a table called "Table1" that has at least one column called "Col1". You must start with a form with one label on it. If you need any help email me at bob3695@gmail.com.

The first step is connecting to the database.

The first thing you must do is add the ADODB reference. To do this in the "Project" menu click "Add Reference" then select ADODB from the list and click "Select".

The next thing you need is at least two variables. One for the connection and one for the record set. A record set is used to query the database. To make these variable add the next two lines at the top of the form.



Now that we have our variables we need to set-up the connection. In order to set up the connection you need a connection string. The one I use works for me but in order to meet your needs you may need to make your own. To set-up the connection string in the "FormLoad" event add this code.



Great...we are ready to connect to the database. Add this line under the connection string set-up line.



We now have a connection to the database. Now we need to find out how to get data from it. In order to do this you need to open a table in the database. To do this you must add these lines to your code.



Now that we have a table open we need to actually get data from it. In order to do this add the following code. This code goes through all the rows in the table and does what you want with the data.



All this code does is take all the data from the column named "Col1" From "Table1" and put it all in Label1. Now that we have our data we need to edit the record and add a new one. To edit the current record use this code.



Now we need to add a new record. Use this code to do that.



The code to add a record is very simialer except you need on more line of code. The Rec.AddNew(). All this does is add a new record to the database then selects it. Now that we are done playing around with the database we need to close it. Use this code.



Thats it! You opened a database, Got information from the database, Changed and added some records, and closed the database.

Thanks,
Rich

connecting database with vb.net web application and download it in different path?
How To: Connect, Read, Write, Close A Database

I want to connect the access database with website by vb.Net by useing your way but it fails how can I connect it and let the program recognize db location after I upload the web site in a differnt path?

-reply by Lamis

I have a access database, my program is reading data from DB into dataset-also deleting-updating-adding properly into dataset.

But fails to do any of these manipulation onto server DB. I have used oledconnection; instead of AODB is that where I am going wrong. This is my first project in VB2005- I am a foxpro programmer originally. My thanks in advance to whover helps me

-reply by Prashant. C

I have a access database, my program is reading data from DB into dataset-also deleting-updating-adding properly into dataset.

But fails to do any of these manipulation onto server DB. I have used oledconnection; instead of AODB is that where I am going wrong. This is my first project in VB2005- I am a foxpro programmer originally. My thanks in advance to whover helps me

-reply by Prashant. C