Need help in getting value of output parameter
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()))
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
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();
cmd.Connection = con;
string message = (string)cmd.Parameters["@ERROR"].Value;
con.Close();
}
}
}