Members may post updates or alternatives to this current article in order to show different
approaches or add new features.
Or you could just pop over to:http://www.connectionstrings.com/[^]Use the exhaustive samples they provide and not hard code your connection strings by using a standard .NET configuration file:http://msdn.microsoft.com/en-us/library/1xtk877y.aspx[^]
The ConnectionStringBuilder classes in .NET can be quite handy...http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnectionstringbuilder.aspx[^].
goto Server Explorer right Click on DataBase Click on properties in properties window you will get Connection String copy it & use where you want use !!
I get it from the web.config via ConfigurationManager.ConnectionStrings;This makes it possible to keep all connectionstring settings in the web.config file.For example: http://www.dreamincode.net/code/snippet1676.htm[^].