How to fix “The ConnectionString property has not been initialized”

by

Referencing the connection string should be done as such:

MySQLHelper.ExecuteNonQuery(
ConfigurationManager.ConnectionStrings["MyDB"].ConnectionString,
CommandType.Text,
sqlQuery,
sqlParams);

ConfigurationManager.AppSettings["ConnectionString"] would be looking in the AppSettings for something named ConnectionString, which it would not find. This is why your error message indicated the "ConnectionString" property has not been initialized, because it is looking for an initialized property of AppSettings named ConnectionString.

ConfigurationManager.ConnectionStrings["MyDB"].ConnectionString instructs to look for the connection string named “MyDB”.

Here is someone talking about using web.config connection strings

More Related Contents:

  1. Entity Framework Timeouts
  2. SQL Express connection string: mdf file location relative to application location
  3. Read connection string from web.config
  4. Persist Security Info Property=true and Persist Security Info Property=false
  5. How can I strip HTML tags from a string in ASP.NET?
  6. Get connection string from App.config
  7. How to force HTTPS using a web.config file
  8. How to get the public IP address of a user in C#
  9. Return View as String in .NET Core
  10. How to write some data to excel file(.xlsx)
  11. How to update a claim in ASP.NET Identity?
  12. How do I get the kestrel web server to listen to non-localhost requests?
  13. Sending an array of values to Oracle procedure to use in WHERE IN clause
  14. Setting dropdownlist selecteditem programmatically
  15. How can I remove item from querystring in asp.net using c#?
  16. No authenticationScheme was specified, and there was no DefaultChallengeScheme found with default authentification and custom authorization
  17. How to add cross domain support to WCF service
  18. How does Request.IsAuthenticated work?
  19. How can I handle forms authentication timeout exceptions in ASP.NET?
  20. Inline code in head tag – ASP.NET
  21. How require authorization within whole ASP .NET MVC application
  22. What is the difference between Debug Mode and Release Mode in Visual Studio 2010? [duplicate]
  23. Accessing controls created dynamically (c#)
  24. asp.net web service using office 2010 COM
  25. System.web.mvc missing
  26. How to route EVERYTHING other than Web API to /index.html
  27. How can I ensure that appsettings.dev.json gets copied to the output folder?
  28. How to add config transformations for a custom config file in Visual Studio?
  29. The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine.
  30. JavaScript: Alert.Show(message) From ASP.NET Code-behind

Leave a Comment