how do i use ADO in visual basic? like connect a database?

Answer 1

first you have to establish a connection with a data source
then you have to create a sql statement to execute
get result

Answer 2

First you should know what ADO is and to explain that you need to know what a RDBS is. A relational database system is a collection of data that is indexed and cross referenced in ways that allow you to define the relationships between different records and how likely you will be using a given field to retrieve data. The data is kept in such a way that you just can't 'open it up' - it must be interpreted and delivered. SQL statements are the way to request the data and a Data Source Provider is the tool which interprets and returns the information usually in 'Recordsets' with 'Rows' and 'Columns'
ADO is one such tool for returning recordsets from relational databases.
Now, as far as how to use it, first the ADO library must be loaded into your project. If you look under 'Project -> Add Reference...' you should see a fairly long list of libraries or DLL's (for the most part). Select the one that you want, in this case it will probably be 'adodb'.
Once you get there, you are going to have to look up in MSDN the exact syntax to connect to the data source you want and how to extract recordsets.
On the other hand, if you have VB 2005 and you want most of the work done for you, try adding a BindingNavigator control to your form and setting the properties to access your data provider. Then drop some text fields on the form and change their properties to use the data dished out by the BindingNavigator. Voila! Cheap, cheesy db front end.
If you have non-stupid questions about this, contact me at [e-mail]. Stupid questions will be ignored.

Answer 3

Read the manual or contact me at [e-mail]

Answer 4

read the manual.