An Access database cannot use output to write its own sequence like Oracle.
1 Public intInsertex (user user)2 {3 intID =-1;4 5 using(OleDbConnection conn =NewOleDbConnection (accesshelper.connectionstring))6 {7 Conn. Open ();8 9OleDbCommand cmd =NewOleDbCommand {Connection = conn, CommandType =CommandType.Text};Ten One stringCommandText = A$"INSERT INTO Tb_user (USERNAME,USERPASSWORD,INSDATE,DR) VALUES (@username, @userpwd, Date (), 0)"; -List<oledbparameter> paras =NewList<oledbparameter> - { the NewOleDbParameter ("username", user. UserName), - NewOleDbParameter ("userpwd", user. UserPassword) - }; - + -Cmd.commandtext =CommandText; + cmd. Parameters.addrange (paras. ToArray ()); A cmd. ExecuteNonQuery (); at - -Cmd.commandtext ="SELECT @ @identity as ID"; - cmd. Parameters.clear (); -ID =Convert.ToInt32 (cmd. ExecuteScalar ()); - } in - returnID; to}
Access gets the self-growing primary key ID of the newly inserted data