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)";