how to make a connection in c# with a sql server data base

var connectionString="Persist Security Info=False;Integrated Security=true;Initial Catalog=Northwind;server=(local)";

//then use it for sqlConnection
var con=new SqlConnection(connectionString);

try to read this for you to know the basic in connection string.



you can also set it in web config

<appsettings>
<add key="myConnectionString" value="server=localhost;database=myDb;uid=myUser;password=myPass;" />
</appsettings>

//then call it in code behind

string connStr = ConfigurationSettings.AppSettings("myConnectionString");

make this as reference. . :)

Refereed this link:

http://jubayerdevs.blogspot.hk/2011/03/read-connection-string-from-xml-file.html[^]