How to solve Procedure or function 'StaffApplyLeave' expects parameter '@h_id', which

[karenkksh]

HI,
protected void btnUpdate_Click(object sender, EventArgs e)
{

SqlConnection MyConnection;
SqlCommand MyCommand;

MyConnection = new SqlConnection();
MyConnection.ConnectionString =
ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
MyConnection.Open();

MyCommand = new SqlCommand("StaffApplyLeave", MyConnection);
MyCommand.CommandType = CommandType.StoredProcedure;
MyCommand.Parameters.Add("@h_id", Request.QueryString["h_id"]);
MyCommand.Parameters.Add("@sh_id", Request.QueryString["staff_id"]);
MyCommand.Parameters.Add("@h_name", txtName.Text);
MyCommand.Parameters.Add("@h_from", txtFrom.Text);
MyCommand.Parameters.Add("@h_till", txtTill.Text);
MyCommand.Parameters.Add("@h_add", txtA1.Text + txtA2.Text);
MyCommand.Parameters.Add("@h_post", txtPost.Text);
MyCommand.Parameters.Add("@h_dept", txtDept.Text);
MyCommand.Parameters.Add("@h_staffno", txtStaff.Text);
MyCommand.Parameters.Add("@h_hp", "+6" + txtH.Text + txtP.Text);
MyCommand.Parameters.Add("@h_email", txtEmail.Text);
MyCommand.Parameters.Add("@h_day", txtDay.Text);
MyCommand.Parameters.Add("@h_date_apply", DateTime.Today.ToString());

MyCommand.ExecuteScalar();


MyConnection.Close();

MyConnection.Close();
Response.Redirect("aHolidayLeave.aspx?staff_id=" + Request.QueryString["staff_id"]);
}

Here's the related stored procedure

ALTER PROCEDURE dbo.StaffApplyLeave
(
@h_id int,
@sh_id int,
@h_name varchar(50),
@h_from datetime,
@h_till datetime,
@h_add varchar(50),
@h_post varchar(50),
@h_dept varchar(50),
@h_staffno varchar(10),
@h_hp varchar(12),
@h_email varchar(50),
@h_day int,
@h_date_apply datetime

)

AS
insert into holiday (h_id,sh_id,h_name,h_from, h_till, h_add, h_post, h_dept,h_staffno,h_hp,h_email,h_day, h_date_apply)
values(@h_id,@sh_id,@h_name,@h_from, @h_till, @h_add, @h_post, @h_dept,@h_staffno,@h_hp,@h_email, @h_day,@h_date_apply)
RETURN.

Plz help solving this. Tq

[balabaster]

HI,
protected void btnUpdate_Click(object sender, EventArgs e)
{

SqlConnection MyConnection;
SqlCommand MyCommand;

MyConnection = new SqlConnection();
MyConnection.ConnectionString =
ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
MyConnection.Open();

MyCommand = new SqlCommand("StaffApplyLeave", MyConnection);
MyCommand.CommandType = CommandType.StoredProcedure;
MyCommand.Parameters.Add("@h_id", Request.QueryString["h_id"]);
MyCommand.Parameters.Add("@sh_id", Request.QueryString["staff_id"]);
MyCommand.Parameters.Add("@h_name", txtName.Text);
MyCommand.Parameters.Add("@h_from", txtFrom.Text);
MyCommand.Parameters.Add("@h_till", txtTill.Text);
MyCommand.Parameters.Add("@h_add", txtA1.Text + txtA2.Text);
MyCommand.Parameters.Add("@h_post", txtPost.Text);
MyCommand.Parameters.Add("@h_dept", txtDept.Text);
MyCommand.Parameters.Add("@h_staffno", txtStaff.Text);
MyCommand.Parameters.Add("@h_hp", "+6" + txtH.Text + txtP.Text);
MyCommand.Parameters.Add("@h_email", txtEmail.Text);
MyCommand.Parameters.Add("@h_day", txtDay.Text);
MyCommand.Parameters.Add("@h_date_apply", DateTime.Today.ToString());

MyCommand.ExecuteScalar();


MyConnection.Close();

MyConnection.Close();
Response.Redirect("aHolidayLeave.aspx?staff_id=" + Request.QueryString["staff_id"]);
}

Here's the related stored procedure

ALTER PROCEDURE dbo.StaffApplyLeave
(
@h_id int,
@sh_id int,
@h_name varchar(50),
@h_from datetime,
@h_till datetime,
@h_add varchar(50),
@h_post varchar(50),
@h_dept varchar(50),
@h_staffno varchar(10),
@h_hp varchar(12),
@h_email varchar(50),
@h_day int,
@h_date_apply datetime

)

AS
insert into holiday (h_id,sh_id,h_name,h_from, h_till, h_add, h_post, h_dept,h_staffno,h_hp,h_email,h_day, h_date_apply)
values(@h_id,@sh_id,@h_name,@h_from, @h_till, @h_add, @h_post, @h_dept,@h_staffno,@h_hp,@h_email, @h_day,@h_date_apply)
RETURN.

Plz help solving this. Tq

I would think that making sure a value exists in Request.QueryString["h_id"] should suffice. If it's not passed, default it to some acceptable value.