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>
<add name="ConnctionStringName" connectionString="Server=localhost or ipAddress;Database=dbname;uid=sqlserver username; pwd=sqlserver user password" providerName="System.Data.SqlClient"/>
</connectionStrings>
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.