sql参数数组，及调用。SqlParameter[] Parameters

来源：互联网发布：windows更新过程中关闭编辑：程序博客网时间：2024/05/29 08:09

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);

0 0