How to connect to the database in vb

Collection Like

In VB, connecting to the database is usually achieved using the two technologies of ADO (ActiveX Data Objects) or DAO (Data Access Objects): 1. Introducing the ADO library; 2. Creating the ADO connection object; 3. Configuring the connection string; 4. Open the connection; 5. Execute the SQL statement; 6. Process the query results; 7. Close the connection.