帮忙看个代码

Question

 public int RegCount(DateTime dt1, DateTime dt2)
        {
            SqlParameter[] parameter = new SqlParameter[]
            {
                new SqlParameter("@dt1",dt1),
                new SqlParameter("@dt2",dt2)
            };
            string sql = "select count(UserId) from AccountsInfo where RegisterDate between  @dt1 and @dt2";
            return DbHelperSQL.ExecuteScalar(sql);
        }怎木老是提示‘必须声明标量变量 "@dt1"’异常

Answer 1

参数parameter是怎么传给DbHelperSQL的？

Answer 2

试试
DbHelperSql.ExecuteScalar(sql, parameter);