How to use Connection String parameter in ADO.net?

In this article we will discuss, to use Connection String parameter in ADO.net. It is a Key/Value pairs is required to create connection object.

Connect using windows authentication:

In windows authentication, you can define like this to connect the database ,

string ConnectionString = "data source=.; database=SampleDB; integrated security=SSPI";

Connect using SQL server authentication:

In SQL server authentication, you can connect the database like this,

 string ConnectionString = "data source=.; database=SampleDB; user id=MyUserName; password=MyPassword";