Connection string syntax in ASP.NET


for windows authentication:
  <connectionStrings>
    <add name="ConnctionStringName" connectionString="Server=localhost;Database=dbname;Trusted_Connection=True;" providerName="System.Data.SqlClient"/>
  </connectionStrings>

For SQL Server authentication: 

  <connectionStrings>
    <add name="ConnctionStringName" connectionString="Server=localhost or ipAddress;Database=dbname;uid=sqlserver username; pwd=sqlserver user password" providerName="System.Data.SqlClient"/>
  </connectionStrings>
Share this post :

Post a Comment

Please give your valuable feedback on this post. You can submit any ASP.NET article here. We will post that article in this website by your name.

 
Support : Ranga Rajesh Kumar
Copyright © 2012. ASP.NET Examples - All Rights Reserved
Site Designed by Ranga Rajesh Kumar