Use of Connection Object

Question

Hi friends I want to know what is use of connection object when we try to create database connection in ADO.Net ? Thank you.

Kunal Vaishya · Answer

String sCon; sCon = Connection String; System.Data.SqlClient.SqlConnection cn = new System.Data.SqlClient.SqlConnection (sCon); System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText =  Insert Into Tablename (idname)values(1kunal) ; cmd.Connection = cn; cn.Open(); cmd.ExecuteNonQuery();