The ADO Connection Object is used to create an open connection to a data source. Through this connection, you can access and manipulate a database. If you want to access a database multiple times, you should establish a connection using the Connection object.

When should you use the SqlConnection object?

Using a SqlConnection. The purpose of creating a SqlConnection object is so you can enable other ADO.NET code to work with a database. Other ADO.NET objects, such as a SqlCommand and a SqlDataAdapter take a connection object as a parameter.

What is the difference between Dao and Adodb?

Data Access Objects. DAO stands for "Data Access Objects" and ADO stands for "ActiveX Data Objects". ... There are many compatibilities between the two methods, but the most significant difference between them is the ability to work with data outside of Access and the JET engine environment.