ExecuteNonQuery: Connection property has not been initialize

parthiban karnan

13y25.9k.NET

String strConnString = ConfigurationManager.ConnectionStrings["EMPLOYEEConnectionString2"].ConnectionString;

//SqlConnection con = new SqlConnection();

protected void btnSave_Click(object sender, EventArgs e)

{

SqlConnection con = new SqlConnection(strConnString);

con.Open();

// con.ConnectionString = new SqlConnection(strConnString);

SqlCommand cmd = new SqlCommand();

cmd.CommandType = CommandType.StoredProcedure;

cmd.CommandText = "JOINMAX";

cmd.Parameters.Add("@NAME", SqlDbType.VarChar).Value = txtName.Text.Trim();

cmd.Parameters.Add("@EMAIL", SqlDbType.VarChar).Value = txtEMAIL.Text.Trim();

cmd.Parameters.Add("@PHONENO", SqlDbType.VarChar).Value = txtPHONE.Text.Trim();

cmd.Parameters.Add("@ERROR", SqlDbType.Char, 500);

cmd.Parameters["@ERROR"].Direction = ParameterDirection.Output;

cmd.ExecuteNonQuery();

// Label1.Text = "Record inserted successfully";

string message = (string)cmd.Parameters["@ERROR"].Value;

con.Close();

}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Shankar M13y ago
Hi Parthiban,

You can Pass the Parameters to SqlParameter class like this,

cmd.Parameters.Add("@NAME",txtName.Text);

For using SqlParameter class, Please view this link,

http://www.c-sharpcorner.com/Blogs/11027/sqlparameter-class.aspx

And, Using the ExecuteNonQuery method of SqlCommand class hope this like will be useful

http://www.c-sharpcorner.com/UploadFile/c5c6e2/working-with-command-object/
parthiban karnan13y ago
code working..records got inserted..but i did'nt get the insert message[Registered Successfully] as specified in storeprocedure..

CREATE proc [dbo].[joinmax]
@name varchar(50),@email varchar(50),@phoneno varchar(50),@ERROR VARCHAR(100) OUT

as

begin
SET NOCOUNT ON;
IF ((select count(id) from joinees
where year(regdate) = year(getdate())
and month(regdate) = month(getdate())
and day(regdate) = day(getdate())) <10 )

begin

INSERT INTO joinees(name,email,phoneno) values(@name,@email,@phoneno)

SET @ERROR=@name+' Registered Successfully'
END
ELSE
SET @ERROR=@name + 'maxlimit reached today'

end
Vishal Gilbile13y ago
SqlCommand cmd=new SqlCommand("ProcedureName",con);
cmd.CommandType=CommandType.StoredProcedure;
cmd.Parameters.Add("@NAME", SqlDbType.VarChar).Value = txtName.Text.Trim();
cmd.Parameters.Add("@EMAIL", SqlDbType.VarChar).Value = txtEMAIL.Text.Trim();
cmd.Parameters.Add("@PHONENO", SqlDbType.VarChar).Value = txtPHONE.Text.Trim();
cmd.Parameters.Add("@ERROR", SqlDbType.Char, 500);
cmd.Parameters["@ERROR"].Direction = ParameterDirection.Output;
con.Open();

cmd.ExecuteNonQuery();
// Label1.Text = "Record inserted successfully";
string message = (string)cmd.Parameters["@ERROR"].Value;
con.Close();
Ish Bandhu13y ago
after SqlCommand cmd = new SqlCommand();
give cmd.Connection=con;