What is the use of the Connection object?
The Connection object is used to connect your application to a specific data source by giving the needed authentication information in connection string. The connection object is used according to the type of the data source. For instance, the OleDbConnection object is used with an OLE-DB provider and the SqlConnection object is used with an MS SQL Server.