The ConnectionString property has not been initialized.

Question

0.00/5 (No votes)

See more:

I have uploaded my project with database files and also attached both database files. But when I try to do anything it gives me following error.

The ConnectionString property has not been initialized.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.InvalidOperationException: The ConnectionString property has not been initialized.

Source Error: 


Line 149:    public int userid()
Line 150:    {
Line 151:        con.Open();
Line 152:        cmd3 = new SqlCommand("select max(usrid) from register", con);
Line 153:        id1 = Convert.ToString(cmd3.ExecuteScalar());

Source File: c:\MemberSites\MemberSites_AspSpider_Info\projectdemo\webroot\App_Code\class1.cs    Line: 151 

Stack Trace: 


[InvalidOperationException: The ConnectionString property has not been initialized.]
   System.Data.SqlClient.SqlConnection.PermissionDemand() +5092770
   System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection) +20
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +126
   System.Data.SqlClient.SqlConnection.Open() +125
   class1.userid() in c:\MemberSites\MemberSites_AspSpider_Info\projectdemo\webroot\App_Code\class1.cs:151
   register.Page_Load(Object sender, EventArgs e) in c:\MemberSites\MemberSites_AspSpider_Info\projectdemo\webroot\register.aspx.cs:32
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +91
   System.Web.UI.Control.LoadRecursive() +74
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207

Posted 2-Apr-14 1:46am

Member 10142753

Add a Solution

Comments

King Fisher 2-Apr-14 7:51am

connectionstring ?

5 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

vsrikanth87 · Answer 1 · 2014-04-02T01:50:00

Solution 1

Looks Like you Haven't Initialized Connection String

C#

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MEMBERSConnectionString2"].ConnectionString);

Posted 2-Apr-14 1:50am

vsrikanth87

Updated 2-Apr-14 2:07am

v3

jacobjohn196 · Answer 2 · 2014-04-02T02:18:00

Add Connection string in web.config file.

XML

<connectionStrings>
    <add name="Conn" connectionString="Data Source=Server Name;Initial Catalog=DB Name;User id=userid;Password=password;Persist Security Info=true;Pooling=true" providerName="System.Data.SqlClient"/>
  </connectionStrings>

Add Namespaces in C#,

C#

using System.Data.SqlClient;
using System.Configuration;

In your C# code, Initialize connection string.

 SqlConnection con = new SqlConnection();
        string cnstr = ConfigurationManager.ConnectionStrings["Conn"].ConnectionString.ToString();
con.ConnectionString = cnstr;
                con.Open();
//your code
con.Close();

Code Help 2014 · Answer 3 · 2014-04-02T03:25:00

The error message clearly states that you have not set the ConnectionString property of your SqlConnection object "con". So check the code where you are setting the value of this property and make sure that the code to set this property is called with a proper value of the connection string.

Member 10142753 · Answer 4 · 2014-04-02T03:28:00

Solution 4

Silly mistake!! Solved it.
Thank you.

"Data Source=HOME\SQLEXPRESS;Initial Catalog=cloudimg;Integrated Security=True;Pooling=False"

Posted 2-Apr-14 3:28am

Member 10142753

Krunal Rohit · Answer 5 · 2014-04-02T05:17:00

The error is self-explanatory: The ConnectionString property has not been initialized.

So apart from above solution, you need to assign connection to your SqlCommand as well.
Like this,

C#

SqlConection con = new SqlConnection("YourDatabaseConnectionString");
con.Open();
SqlCommand cmd = new SqlCommand("YourQuery"); 
cmd.Connection = con;
// or, new SqlCommand(""YourQuery", con);
/*
...
...
...
*/
con.Close();

-KR

The ConnectionString property has not been initialized.

5 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Solution 5

Add your solution here

Preview 0