Hello guys...
          I have a problem which deals with the connection string for database.
I am using SQLserver Desktop engine.It is installed in WindowsNT Authentication mode.
I used to give the connection string as

<appSettings>
 <add key="ConnectionString" value="server=ServerName;uid= ;pwd= ;database=DatabaseName"/>
    </appSettings>

inside the "web.config" file.Is this connection string is enough or i need to change this? Please Help me..

Regards.

Well, does the connection work?

yes that is the string you need to connect to database and just keep the below string in the page you need to connect to the database.
cn = New SqlConnection(ConfigurationSettings.AppSettings("s trConn"))

cn is connection object,str connection is the key value you gave after add key.

when i folloe your appsettings i have to give connectionstring insted of strconn..but i thought it will be bit confusing...

hope this will be useful for you-Ashok

No the connection string should be as follows

"Server=<server>;Database=<db name>;Trusted_Connection=True;Integrated Security=SSPI"

For connection strings you can try the following URL which has all connection string samples

http://www.connectionstrings.com



It is not how much we do,
but how much love we put in the doing.

-Mother Theresa