Insert statement
Hi.....i did insert statement and encountered error......but could not solve it..this is the error.....can anybody correct it?
Error Message: Incorrect syntax near '@job_intro'.
this is my code...
SqlConnection con;
string insertStr;
SqlCommand cmdInsert;
String constr = ConfigurationManager.ConnectionStrings["tarStreetConnectionString1"].ConnectionString;
con = newSqlConnection(constr);
con.Open();
insertStr = "Insert Into JobPost(Job_Id,Job_Desc,Job_Specialization,Job_Min Qualification,Job_PositionLevel,Job_Title,Job_CmpN ame,Job_Location,Job_Employment,YrsOfExperience,Jo b_CmpIntroduction)Values(@id,@desc,@Special,@min_Q ua,@position,@title,@cmpName,@location,@job_Employ ,@yrsExpe,@job_intro";
cmdInsert = newSqlCommand(insertStr, con);
cmdInsert.Parameters.AddWithValue("@id", TextBox17.Text);
cmdInsert.Parameters.AddWithValue("@desc",TextBox9.Text);
cmdInsert.Parameters.AddWithValue("@Special",DropDownList6.SelectedItem.Text);
cmdInsert.Parameters.AddWithValue("@min_Qua",ListBox1.SelectedItem.Text);
cmdInsert.Parameters.AddWithValue("@position",DropDownList5.SelectedItem.Text);
cmdInsert.Parameters.AddWithValue("@title",txtPosition.Text);
cmdInsert.Parameters.AddWithValue("@cmpName",TextBox10.Text);
cmdInsert.Parameters.AddWithValue("@location",DropDownList8.SelectedItem.Text);
cmdInsert.Parameters.AddWithValue("@job_Employ",CheckBoxList1.SelectedItem.Text);
cmdInsert.Parameters.AddWithValue("@yrsExpe",TextBox7.Text);
cmdInsert.Parameters.AddWithValue("@job_intro", TextBox11.Text);
//cmdInsert.Parameters.AddWithValue("@job_candidate" ,);
cmdInsert.ExecuteNonQuery();
con.Close();
}
|
