简单的c#连接access2007的问题

CNLAN 2010-01-21 11:54:02

原来一个使用sql server,这次帮朋友做个小东西,需要用到access,遇到几个问题:
1.好像access不是直接使用参数名,而是参数按赋值的先后顺序处理的?
2.access老提示语法错误,我把sql代码直接在access查询分析器能执行通过
3.access 不能直接使用了TransactionScope 处理 ,不知道大家平常使用事务用的是什么方法?



/// <summary>

        /// 创建一个用户

        /// </summary>

        /// <param name="user">用户</param>

        /// <returns></returns>

        public User CreateUser(User user)

        {

            //using (System.Transactions.TransactionScope ts = new System.Transactions.TransactionScope())

            //{

                

                //

                //创建混合码，同时对密码进行加密

                //

                string salt = SecurityHelper.CreateSalt(saltLength);

                string passwordHash = SecurityHelper.SaltAndHash(user.Password, salt);

                //

                //插入用户

                //



//

//在这里,一直报insert into 语法错误,我看了老半天就一直没看出来.

//



                string sql = "INSERT INTO [User] (UserName,UserNameToLower,Email,DisplayName,Password,Salt,CreateTime,LastLoginTime,State)"

                    + " VALUES (@UserName,@UserNameToLower,@Email,@DisplayName,@Passport,@Salt,@CreateTime,@LastLoginTime,@State)";

                DbCommand cmd = db.GetSqlStringCommand(sql);

                db.AddInParameter(cmd, "UserName", DbType.String, user.UserName);

                db.AddInParameter(cmd, "UserNameToLower", DbType.String, user.UserName.ToLower());

                db.AddInParameter(cmd, "Email", DbType.String, user.Email);

                db.AddInParameter(cmd, "DisplayName", DbType.String, user.DisplayName);

                db.AddInParameter(cmd, "Passport", DbType.String, passwordHash);

                db.AddInParameter(cmd, "Salt", DbType.String, salt);

                db.AddInParameter(cmd, "CreateTime", DbType.String, user.CreateTime);

                db.AddInParameter(cmd, "LastLoginTime", DbType.String, user.LastLoginTime);

                db.AddInParameter(cmd, "State", DbType.Int32, user.State);

                db.ExecuteNonQuery(cmd);

                //

                //默认给用户授Users权限

                //

                sql = "INSERT INTO UserInRoles (UserName,RoleName) VALUES (@UserName,@RoleName)";

                db.AddInParameter(cmd, "UserName", DbType.Int32, user.UserName);

                db.AddInParameter(cmd, "RoleName", DbType.String, "Users");

                db.ExecuteNonQuery(cmd);

                //ts.Complete();

                return user;

            //}

        }