读书人

asp.net+access insert into 语法附加

发布时间: 2012-02-15 12:09:44 作者: rapoo

asp.net+access insert into 语法附加有错误
一直用sql刚试下access就出错了

SQL code
  /// <summary>       /// 注册       /// </summary>       /// <param name="user"></param>       /// <returns></returns>       public static int AddLoginUser(User user)       {                    string sql = "INSERT INTO User ([Name],[Password],[PurviewID]) VALUES (@Name ,@password ,@purviewId)";           OleDbParameter[] paras ={ new OleDbParameter("@Name",user.Name),new OleDbParameter("@password",user.Password),                                     new OleDbParameter("@purviewId",user.Purview.Id)};           return DBHelper.ExecuteNonQuery(sql,paras);       }


报insert into语法附近有错误 求助

[解决办法]
string sql = "INSERT INTO [User] ([Name],[Password],[PurviewID]) VALUES (@Name ,@password ,@purviewId)";

读书人网 >Access

热点推荐