用OleDbParameter参数类要注意参数顺序必须和SQL文中参数顺序一致

使用OleDbParameter参数类需要注意参数顺序必须要和SQL文中此参数出现的顺序一致。例如更新一条数据：

/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Maticsoft.Model.TContent model)
{
    StringBuilder strSql = new StringBuilder();
    strSql.Append("update TContent set ");
    strSql.Append("Title=@Title,");
    strSql.Append("Author=@Author,");
    strSql.Append("WebContent=@WebContent,");
    strSql.Append("WriteDate=@WriteDate,");
    strSql.Append(" where ID=@ID ");
    OleDbParameter[] parameters = {
			new OleDbParameter("@Title", OleDbType.VarChar,50),
			new OleDbParameter("@Author", OleDbType.VarChar,20),
			new OleDbParameter("@WebContent", OleDbType.VarChar,0),
			new OleDbParameter("@WriteDate", OleDbType.Date),
            new OleDbParameter("@ID", OleDbType.Integer,4)};
    parameters[0].Value = model.Title;
    parameters[1].Value = model.Author;
    parameters[2].Value = model.WebContent;
    parameters[3].Value = model.WriteDate;
    parameters[4].Value = model.ID;

    DbHelperOleDb.ExecuteSql(strSql.ToString(), parameters);
}

假如把以上参数数组中的WriteDate和ID的前后顺序互换下，就不能更新成功。