How to establish connection MS Access to VB2008

Asked By 0 points N/A Posted on -
qa-featured

Hello,

I have created the following:

1 Form created in VB2008

3 Textbox [Name(string), Company(string), Contact(number)] 3 Buttons [New Record, Update Record, Delete Record]

2 Database created in MS Access 2003

File Name: Information.mbd

Fields: ID [Primary key] Name [Text] Company [Text] Contact [Number]

How to create connection? How to get data on form load from database in Textboxes? How to insert, update, delete data? Please provide information as I am not able to get any simplest way to understand these questions.

Thanks in advance

 

SHARE
Best Answer by Hoting Gracia
Go To Solution
Best Answer
Best Answer
Answered By 5 points N/A #118921

How to establish connection MS Access to VB2008

qa-featured

Hello Jimm!

Visual Basic is a language of .net which is developed by Microsoft and this language is similar to C and also it is majorly used in many programs for smooth execution.
 
Coming to Windows Application Form in Visual Basic it is simple as it is drag and drop and no need to generate any code for that as automatically code will be generated.
 
Remember the following 5 objects that are required in connecting to database which can be described as Connection, Command, DataReader, DataSet and DataAdapter.
 
To perform database with the data then you simply create a connection for database and then insert your queries and you can access data from the database.
 
Thank You.
 
About Hoting Gracia
Questions
0
Answers
154
Best Answers
65
  • Posted on -
  • Question Category:

Clicking Sounds In my CPU

Previous

How to have a fast connection pc to pc

Next

Related Questions