• 我的OleDbParameter类必须注意的问题


    asp.net

    OleDbParameter

    string sql = @"Insert Into User_Table(UserId,UserName,UserSex,
    UserNickName,LowPassword,HighPassword,IdNumber,Grade,BankAcc,BankNo,BankOpeningAddress,Address,Tel,
    Email,PostCode,RegTime,RolType,ParentUserId,CenterId,TuiJianId) Values(@UserId,@UserName,@UserSex,
    @UserNickName,@LowPassword,@HighPassword,@IdNumber,@Grade,@BankAcc,@BankNo,@BankOpeningAddress,@Address,@Tel,
    @Email,@PostCode,@RegTime,RolType,@ParentUserId,@CenterId,@TuiJianId)";
                OleDbParameter[] para ={
                new OleDbParameter("@UserId",User.UserId),
                new OleDbParameter("@UserName",User.UserName),
                new OleDbParameter("@UserSex",User.UserSex),
                new OleDbParameter("@UserNickName",User.UserNickName),
                new OleDbParameter("@LowPassword",FormsAuthentication.HashPasswordForStoringInConfigFile(User.LowPassword, "SHA1")),
                new OleDbParameter("@HighPassword",FormsAuthentication.HashPasswordForStoringInConfigFile(User.HighPassword, "SHA1")),
                new OleDbParameter("@IdNumber",User.IdN

    顺序要严格控制,这个OleDbParameter(不知道是不是我的数据访问类有问题),必须顺序完全也一样,要不就会出现莫名其妙的问题(执行数据操作失败,但不报错)

  • 相关阅读:
    linux自动获得mac地址,修改网络配置
    Linux上java环境变量配置
    linux下rz,sz安装
    linux环境变量设置
    cenos6.5安装vsftp
    tomcat打开gzip、配置utf-8
    java基础50 配置文件类(Properties)
    java基础49 IO流技术(对象输入流/对象输出流)
    java基础48 IO流技术(序列流)
    java基础47 装饰着模式设计
  • 原文地址:https://www.cnblogs.com/hateyoucode/p/1608907.html
Copyright © 2020-2023  润新知