//MSSQLServer Public Static intGetinsertid (stringSQL) { Try{SqlCommand cmd=NewSqlCommand (); using(SqlConnection conn =NewSqlConnection (connectionString)) {PrepareCommand (CMD, conn, SQL,NULL); Cmd. ExecuteNonQuery (); PrepareCommand (CMD, conn,"Select @ @Identity",NULL); intval =Convert.ToInt32 (cmd. ExecuteScalar ()); returnVal; } } Catch(Exception err) {Throwerr; } }Private Static voidPrepareCommand (SqlCommand cmd, SqlConnection conn,stringCmdtext, SqlTransaction Trans) { Try { if(Conn. State! =ConnectionState.Open) {conn. Open (); } cmd. Connection=Conn; Cmd.commandtext=Cmdtext; if(Trans! =NULL) {cmd. Transaction=Trans; } Cmd.commandtype=CommandType.Text; } Catch(Exception err) {Throwerr; } }//Access Public Static intGetinsertid (stringSQL) { Try{OleDbCommand cmd=NewOleDbCommand (); using(OleDbConnection conn =NewOleDbConnection (ConnectionString)) {PrepareCommand (CMD, conn, SQL,NULL); Cmd. ExecuteNonQuery (); PrepareCommand (CMD, conn,"Select @ @Identity",NULL); intval =Convert.ToInt32 (cmd. ExecuteScalar ()); returnVal; } } Catch(Exception err) {Throwerr; } } Public Static voidPrepareCommand (OleDbCommand cmd, OleDbConnection conn,stringCmdtext, OleDbTransaction Trans) { Try { if(Conn. State! =ConnectionState.Open) {conn. Open (); } cmd. Connection=Conn; Cmd.commandtext=Cmdtext; if(Trans! =NULL) {cmd. Transaction=Trans; } Cmd.commandtype=CommandType.Text; } Catch(Exception err) {Throwerr; } }
There is also a method that can be obtained by querying the maximum ID of the current table after inserting, but if the data concurrency is large, the problem may occur
Gets the ID of the current row inserted with the Access database MSSQLServer