asp.net数据库连接插入数据时出错,如下:???

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+"行!";
}
}
}

                ![图片说明](https://img-ask.csdn.net/upload/201605/18/1463582516_798536.png)

检查下那两个列的列名和列的类型是否正确。

这个大多数情况下是sql语句出错