记录Access数据库更新操作大坑一个

　　对于更新Access数据库的操作，必须保持参数数组与sql语句中参数顺序一致，如下：

 public bool Update(MyModel model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update table1 set ");
            strSql.Append(" column1 = @column1 , ");
            strSql.Append(" column2 = @column2, ");
            strSql.Append(" where ID=@ID ");

            OleDbParameter[] parameters =
                {
                    // 必须要这个顺序 ヾ(。￣□￣)ﾂ゜゜゜
                    new OleDbParameter("@column1", OleDbType.Integer, 4),
                    new OleDbParameter("@column2", OleDbType.Integer, 4),
                    new OleDbParameter("@ID", OleDbType.Integer, 4)
                };

            parameters[0].Value = model.column1;
            parameters[1].Value = model.column1;
            parameters[2].Value = model.ID;

            int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

　　如果改成下面这样，顺序不一致了，就妥妥的更新失败，还不报任何异常。。。。

        public bool Update(MyModel model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update table1 set ");
            strSql.Append(" column1 = @column1 , ");
            strSql.Append(" column2 = @column2, ");
            strSql.Append(" where ID=@ID ");

            OleDbParameter[] parameters =
                {
                    // 顺序与sql语句不一致了 ヾ(。￣□￣)ﾂ゜゜゜
                    new OleDbParameter("@ID", OleDbType.Integer, 4),
                    new OleDbParameter("@column1", OleDbType.Integer, 4),
                    new OleDbParameter("@column2", OleDbType.Integer, 4)
                };

            parameters[0].Value = model.ID;
            parameters[1].Value = model.column1;
            parameters[2].Value = model.column1;

            int rows = DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }