string constr = "data source=USER-20141030QL;initial catalog=ASP.net;integrated security=true";
using (SqlConnection con = new SqlConnection(constr))
{
string sql = string.Format("Insert into Employees values(N'{0}',N'{1}',N'{2}',N'{3}',{4},N'{5}',N'{6}',{7},N'{8}')",empNumber,empName,enpGender,empJoinData,empAge,empAddress,empPhone,empDepartmentID,empEmail);
using (SqlCommand cmd = new SqlCommand(sql,con))
{
con.Open();
int r = cmd.ExecuteNonQuery();
if (r > 0)
{
this.Text = "插入成功!";
LoadData();
}
else
{
this.Text = "插入了"+r+"行!";
}
}
}

检查下那两个列的列名和列的类型是否正确。
这个大多数情况下是sql语句出错