Connection Object is used to establish a connection between database and appliaction...

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

Connection object is used to establish connection with the database from UI.