写写程序,一种成就的感觉

写写程序,一种成就的感觉

导航

我的OleDbParameter类必须注意的问题

Posted on 2009-11-23 17:35  hateyoucode  阅读(3497)  评论(0编辑  收藏  举报

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