我的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(不知道是不是我的数据访问类有问题),必须顺序完全也一样,要不就会出现莫名其妙的问题(执行数据操作失败,但不报错)

原文地址:https://www.cnblogs.com/hateyoucode/p/1608907.html