@ Identity

@ Identity is the last identifier generated by the current dialog.

Today, I suddenly thought about how to get the ID of the new student after inserting a student.

Later, Xiaowei introduced @ identity.

I thought of a solution. I don't know if there is any problem.

String sqlstring = "insert into [userinfor] (name, age) values (@ name, @ age); select @ identity from [userinfor]";

Object result = sqlcommand. executescalar ();

In this way, the student ID just inserted is received as the result.