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[^].
Communication with database in .NET is easy but sometimes one gets stuck by wrong format of connection string
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 !!