ExecuteNonQuery: Connection property has not been initialized.

Question

0.00/5 (No votes)

See more:

Error:
System.InvalidOperationException was unhandled by user code
Message="ExecuteNonQuery: Connection property has not been initialized."
Source="System.Data"
StackTrace:
at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at _Default.btnSubmit_Click(Object sender, EventArgs e) in c:\Users\Somesh\Desktop\assigment\Default.aspx.cs:line 32
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
InnerException:

Code:

C#

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["siteConnectionString1"].ConnectionString);
        SqlCommand cm = new SqlCommand("insert into new_user (first,last,email,mobile,gender,country) values(@first,@last,@email,@mobile,@gender,@country)");
        cm.CommandType = CommandType.Text;
                cm.Parameters.AddWithValue("@first", txtFirstName.Text);
                cm.Parameters.AddWithValue("@last", txtSecondName.Text);
                cm.Parameters.AddWithValue("@email", txtFirstName.Text);
                cm.Parameters.AddWithValue("@mobile", txtFirstName.Text);
                cm.Parameters.AddWithValue("@gender", txtFirstName.Text);
                cm.Parameters.AddWithValue("@country", txtFirstName.Text);
                con.Open();
                cm.ExecuteNonQuery();
                con.Close();
    }
    protected void btnClear_Click(object sender, EventArgs e)
    {

    }
}

Config file:

add name="siteConnectionString1" connectionstring="Data Source=SOMESH-PC\SQLEXPRESS;Initial Catalog=site;Integrated Security=True" providerName="System.Data.SqlClient"

Posted 9-Jul-13 12:34pm

Somesh Pursnani

Updated 9-Jul-13 14:12pm

_Damian S_

v3

Add a Solution

7 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)

Garth J Lancaster · Answer 1 · 2013-07-09T13:11:00

Solution 1

How about

C#

con.Open();

between these 2 lines ..

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["siteConnectionString1"].ConnectionString);
SqlCommand cm = new SqlCommand("insert into new_user (first,last,email,mobile,gender,country) values(@first,@last,@email,@mobile,@gender,@country)");

ok, this is skipping error handling, you should be using a try/catch here as well, lets ignore that for the moment

Posted 9-Jul-13 13:11pm

Garth J Lancaster

Comments

Somesh Pursnani 9-Jul-13 19:17pm

ohk, after many debugging exercise i missed passing CONNECTION argument in "SqlCommand cm = new SqlCommand("insert into new_user (first,last,email,mobile,gender,country) values(@first,@last,@email,@mobile,@gender,@country)", con);"
compare with the one posted. :)

Garth J Lancaster 9-Jul-13 19:18pm

yup, I did wonder about that, but got distracted before I could check the syntax :-(
ah well - debugging skills are useful

senthil kumar - 2185 · Answer 2 · 2013-07-12T20:14:00

Solution 2

C#

SqlCommand cm = new SqlCommand("insert into new_user (first,last,email,mobile,gender,country) values(@first,@last,@email,@mobile,@gender,@country)",con);

Posted 12-Jul-13 20:14pm

senthil kumar - 2185

bunzitop · Answer 3 · 2013-07-14T04:57:00

Solution 4

I think you are missing

cm.connection = Databaseconnection;

Posted 14-Jul-13 4:57am

bunzitop

Tony Tom.k · Answer 4 · 2013-07-14T06:16:00

        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["siteConnectionString1"].ConnectionString);
con.Open();
        SqlCommand cm = new SqlCommand("insert into new_user (first,last,email,mobile,gender,country) values(@first,@last,@email,@mobile,@gender,@country)",con);

You have missed the con variable in Sql Command Please Check The article for more info
Insert Operations[^]

Zafar A khan · Answer 5 · 2013-07-14T18:44:00

Solution 6

C#

cm.Connection=con;

Posted 14-Jul-13 18:44pm

Zafar A khan

Sagar Tajpara · Answer 6 · 2013-07-12T22:37:00

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

con.open();
sqlcommand cmd=con.createcommand();
cmd.commandType=commandtype.Text;
cmd.commandtext ="insert into new_user (first,last,email,mobile,gender,country) values(@first,@last,@email,@mobile,@gender,@country)";
cm.Parameters.AddWithValue("@first", txtFirstName.Text);
cm.Parameters.AddWithValue("@last", txtSecondName.Text);
cm.Parameters.AddWithValue("@email", txtFirstName.Text);
cm.Parameters.AddWithValue("@mobile", txtFirstName.Text);
cm.Parameters.AddWithValue("@gender", txtFirstName.Text);
cm.Parameters.AddWithValue("@country", txtFirstName.Text);
cmd.ExecuteNonQuery();
con.Close();

I hope this work ...

Member 11871351 · Answer 7 · 2015-10-20T01:32:00

Even after passing connection string, I am getting the error...?
Can Any One Help me out....???
Please
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Drawing;
using System.Windows;
using System.ComponentModel;
using System.IO;
using System.Runtime;
public partial class Add : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack) { }
}
protected void SubmitButton_Click(object sender, EventArgs e)
{
try
{
//Label lblMessage;
SqlConnection con = new SqlConnection();
con.ConnectionString = "data source=opTLP-4\\SQLExpress;User Id=test;Password=test;Initial Catalog=test";
//SqlCommand cmd = new SqlCommand();
try
{
if (txtUserId.Text == "null")
{
con.Open();
SqlCommand cmd = new SqlCommand("AddUpdateEmpData_sp", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter UserId = cmd.Parameters.Add("@UserId", SqlDbType.NVarChar);
UserId.Direction = ParameterDirection.Output;
SqlParameter Title = cmd.Parameters.Add("@Title", SqlDbType.NVarChar);
Title.Value = txtTitle.Text;
SqlParameter FirstName = cmd.Parameters.Add("@FirstName", SqlDbType.NVarChar);
FirstName.Value = txtFirstName.Text;
SqlParameter MiddleName = cmd.Parameters.Add("@MiddleName", SqlDbType.NVarChar);
MiddleName.Value = txtMiddleName.Text;
SqlParameter LastName = cmd.Parameters.Add("@LastName", SqlDbType.NVarChar);
LastName.Value = txtLastName.Text;
SqlParameter DisplayName = cmd.Parameters.Add("@DisplayName", SqlDbType.NVarChar);
DisplayName.Value = txtDisplayName.Text;
SqlParameter Salutation = cmd.Parameters.Add("@Salutation", SqlDbType.NVarChar);
Salutation.Value = txtSalutation.Text;
SqlParameter Gender = cmd.Parameters.Add("@Gender", SqlDbType.NChar);
Gender.Value = ddlGender.Text;
SqlParameter ManagerID = cmd.Parameters.Add("@ManagerID", SqlDbType.NVarChar);
ManagerID.Value = txtManagerID.Text;
SqlParameter Email = cmd.Parameters.Add("@Email", SqlDbType.NVarChar);
Email.Value = txtEmail.Text;
SqlParameter AlternateEmail = cmd.Parameters.Add("@AlternateEmail", SqlDbType.NVarChar);
AlternateEmail.Value = txtAlternateEmail.Text;
SqlParameter Phone = cmd.Parameters.Add("@Phone", SqlDbType.NVarChar);
Phone.Value = txtPhone.Text;
SqlParameter PhoneExt = cmd.Parameters.Add("@PhoneExt", SqlDbType.NVarChar);
PhoneExt.Value = txtPhoneExt.Text;
SqlParameter Phone1 = cmd.Parameters.Add("@Phone1", SqlDbType.NVarChar);
Phone1.Value = txtPhone1.Text;
SqlParameter Phone1Ext = cmd.Parameters.Add("@Phone1Ext", SqlDbType.NVarChar);
Phone1Ext.Value = txtPhone1Ext.Text;
SqlParameter Fax = cmd.Parameters.Add("@Fax", SqlDbType.NVarChar);
Fax.Value = txtFax.Text;
SqlParameter Mobile = cmd.Parameters.Add("@Mobile", SqlDbType.NVarChar);
Mobile.Value = txtMobile.Text;
SqlParameter Pager = cmd.Parameters.Add("@Pager", SqlDbType.NVarChar);
Pager.Value = txtPager.Text;
SqlParameter CreatedOn = cmd.Parameters.Add("@CreatedOn", SqlDbType.DateTime);
CreatedOn.Value = txtCreatedOn.Text;
SqlParameter CreatedBy = cmd.Parameters.Add("@CreatedBy", SqlDbType.NVarChar);
CreatedBy.Value = txtCreatedBy.Text;
SqlParameter ModifiedOn = cmd.Parameters.Add("@ModifiedOn", SqlDbType.DateTime);
ModifiedOn.Value = txtModifiedOn.Text;
SqlParameter ModifiedBy = cmd.Parameters.Add("@ModifiedBy", SqlDbType.NVarChar);
ModifiedBy.Value = txtModifiedBy.Text;
// con.Open();
cmd.ExecuteNonQuery();
con.Close();
//ClearAll();
lbloutput.Text = "Record inserted successfully. ID = " + UserId.Value.ToString();

}
}
catch (Exception ex)
{
Response.Write(ex.Message.ToString());
}
finally
{
con.Close();
}
}
catch(Exception ex)
{ Response.Write(ex.Message.ToString()); }
Response.Redirect("Default.aspx");
}
}