1、参数数组:
SqlParameter[] Parameters = new SqlParameter[] { new SqlParameter("@ID", ID), new SqlParameter("@Bh", Bh), new SqlParameter("@StuffName", StuffName), new SqlParameter("@Sex", Sex), new SqlParameter("@Folk", Folk), new SqlParameter("@Birthday", Birthday), new SqlParameter("@Age", Age), new SqlParameter("@Kultur", Kultur), new SqlParameter("@Marriage", Marriage), new SqlParameter("@Visage", Visage), new SqlParameter("@IDCard", IDCard), new SqlParameter("@workdate", workdate), new SqlParameter("@WorkLength", WorkLength)};
2、sqlhelper定义调用方法
public static int ExecuteNonQuery(string sql, CommandType type, params SqlParameter[] pms)
{
using (SqlConnection con = new SqlConnection(M_str_sqlcon))
{
using (SqlCommand cmd = new SqlCommand(sql, con))
{
cmd.CommandType = type;
if (pms != null)
{
cmd.Parameters.AddRange(pms);
}
con.Open();
cmd.CommandTimeout = 180;
return cmd.ExecuteNonQuery();
}
}
}
3、sqlhelper调中参数数组
MyMeans.ExecuteNonQuery(insertSql, CommandType.Text, Parameters);