Hello
I want insert some data in my Education_Degree_TB but I face to bellow error
why it happen what I do?
Please help me
An exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll but was not handled in user code
Additional information: Procedure or function 'Insert_Education_Degree_TB' expects parameter '@Person_ID', which was not supplied.
my Procedure code
CREATE procedure [dbo].[Insert_Education_Degree_TB]
@Person_ID int,
@Field_ID int,
@SubField_ID int,
@Degree_Education nvarchar(50),
@University_Name nvarchar(100),
@Data_Graduated date,
@Experience_Job nvarchar(50)
as
begin
Insert into Education_Degree_TB values(@Person_ID,@Field_ID,@SubField_ID,@Degree_Education,@University_Name,
@Data_Graduated,@Experience_Job )
end
My C# code
protected void ButtonEducationDgree_Click(object sender, EventArgs e)
{
SqlCommand cmd2 = new SqlCommand("Insert_Education_Degree_TB", con);
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.AddWithValue("@Person_ID",Session["PersonID"].ToString());
cmd2.Parameters.AddWithValue("@Field_ID", DropDownList_PersonField.SelectedValue.ToString());
cmd2.Parameters.AddWithValue("@SubField_ID", DropDownList_PersonSubField.SelectedValue.ToString());
cmd2.Parameters.AddWithValue("@Degree_Education", DropDownList_PersonDegree.SelectedValue.Trim());
cmd2.Parameters.AddWithValue("@University_Name", TextBox_UniversityNmae.Text.Trim());
cmd2.Parameters.AddWithValue("@Data_Graduated", TextBox_DateGraduated.Text.Trim());
cmd2.Parameters.AddWithValue("@Experience_Job", DropDownList_Experience.SelectedValue);
cmd2.Parameters.Clear();
con.Open();
cmd2.ExecuteNonQuery();
Labelsucces.Visible = true;
Labelsucces.Text = "Insert Education was Sucsessfuly";
TextBox_UniversityNmae.Text = "";
TextBox_DateGraduated.Text = "";
LblErorr.Visible = false;
con.Close();
}