When inserting the error is showing like this "'Conversion failed when converting the varchar value 'AP' to data type int.'"
This My Code (And Error is showing at ExecuteNonQuery());
Please Help me
protected void btn1_Click(object sender, EventArgs e)
{
string firsName = fn.Text;
string lName = ln.Text;
string DeptName = dept.SelectedItem.Text;
string Gender = string.Empty;
if (m.Checked == true)
{
Gender = m.Text;
}
else
{
Gender = f.Text;
}
string hobby = string.Empty;
if (h1.Checked == true)
{
hobby = h1.Text;
}
if (h2.Checked == true)
{
hobby = hobby+h2.Text;
}
if (h3.Checked == true)
{
hobby =hobby+h3.Text;
}
if (h4.Checked == true)
{
hobby =hobby+h4.Text;
}
string Dnum = dno.SelectedItem.Text;
string State = stat.SelectedItem.Text;
string City = ct.SelectedItem.Text;
con.Open();
string query = "Insert into emp values('" + firsName + "','" + lName + "','" + DeptName + "','" + Gender + "','" + hobby + "','" + Dnum + "','" + State + "','" + City + "')";
SqlCommand cmd = new SqlCommand(query, con);
int i = cmd.ExecuteNonQuery();
con.Close();
if (i == 1)
{
FillGrid();
Response.Write("Emp Added");
}
}