In ado.net, connection object is used to create a connection between database and application and then you fetch or manipulate the data on database

ADO connection object is a way to open connection to a database . Through this connect , you can fetch the data from database and manipulate a database.

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. You can also make a connection to a database by passing a connection string via a Command or Recordset object. However, this type of connection is only good for one specific, single query.

http://www.dotnetfunda.com/interviews/show/3681/what-is-the-use-of-connection-object

connection object s used to get connection from front end to back end.