Setting up connection string in ASP.NET to SQL SERVER

by

You can also use this, it’s simpler. The only thing you need to set is “YourDataBaseName”.

  <connectionStrings>
    <add name="ConnStringDb1" connectionString="Data Source=localhost;Initial Catalog=YourDataBaseName;Integrated Security=True;" providerName="System.Data.SqlClient" />
  </connectionStrings>

Where to place the connection string

<?xml version='1.0' encoding='utf-8'?>  
  <configuration>  
    <connectionStrings>  
      <clear />  
      <add name="Name"   
       providerName="System.Data.ProviderName"   
       connectionString="Valid Connection String;" />  
    </connectionStrings>  
  </configuration>

More Related Contents:

  1. Escape quote in web.config connection string
  2. Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’
  3. Using different Web.config in development and production environment
  4. How do you modify the web.config appSettings at runtime?
  5. Access-control-allow-origin with multiple domains
  6. Forms authentication timeout vs sessionState timeout
  7. Avoid web.config inheritance in child web application using inheritInChildApplications
  8. Which gets priority, maxRequestLength or maxAllowedContentLength?
  9. Use Visual Studio web.config transform for debugging [duplicate]
  10. ASP.NET web.config: configSource vs. file attributes
  11. Difference between and ?
  12. Reading web.config from JavaScript
  13. A network-related or instance-specific error occurred while establishing a connection to SQL Server [closed]
  14. Web Application Problems (web.config errors) HTTP 500.19 with IIS7.5 and ASP.NET v2
  15. Setting up redirect in web.config file
  16. HTTP Error 500.19 – Internal Server Error
  17. How to configure invariant culture in ASP.NET globalization?
  18. What are the Web.Debug.config and Web.Release.Config files for?
  19. Nested ASP.NET ‘application’ within IIS inheriting parent config values?
  20. Store String Array In appSettings?
  21. How to encrypt one entry in web.config
  22. Web Config Transform not working
  23. Is it possible to configure a location in Web.config to only allow local connections
  24. How to fix error ::Format of the initialization string does not conform to specification starting at index 0::
  25. Programmatically register HttpModules at runtime
  26. The configuration section ‘system.web.extensions’ cannot be read because it is missing a section declaration
  27. web.config and app.config confusion
  28. Specify more than one directory in Web.Config’s Location Path element
  29. Editing Web.config programmatically
  30. How can I reference an appSetting in a different part of web.config

Leave a Comment