Connection String

Connection string is one of the important part in database connectivity because without database connectivity we cannot connect the database with our project.

 Connection string is a string that specifies information about a data source and the means of connecting to it. It is passed in code to an underlying driver or provider in order to initiate the connection. Whilst commonly used for a database connection, the data source could also be a spreadsheet or text file.

The connection string may include attributes such as the name of the driver, server and database as well as security information such as user name and password


SqlConnection cn=new SqlConnection(“servername”;”database”;”uerid”;”password”);

For example:

 //these lines are for creating a new connection by passing server name,uid,password and name of the database 
SqlConnection con = new SqlConnection('server=abc-pc1\\sqlexpress; database=mind; uid=sa; password=sa ');
//open connection      
Last updated:8/26/2019 10:38:00 PM


Leave Comment