What is the use of connection object?
The connection objects are used to connect a data to the Command object.
1)An OleDbConnection object is used with the OLE-DB provider
2)The SqlConnection object uses the Tabular Data Services (TDS) with the MS SQL Server.