After inserting a record, you want to immediately obtain the primary key return value in the data table. This primary key is automatically generated. In fact, there are many implementation methods, such as performing another query and obtaining it. You can also extract the maximum value before inserting data and add one to the maximum value. There are many methods, but some are inconvenient.
In my opinion, the fastest way is to directly obtain the value of the primary key after inserting data, and then return it.
The method is as follows:
The SQL statement is as follows:
Insert into tablename (fieldname...) values (value...) Select @ identity as returnname;
Add select @ identity as returnname to the SQL statement to obtain the value of the primary key.
In ProgramTo obtain the return value:
Public int sqlexecutereader (string SQL)
{
Dbopen ();
Sqlcommand mycomm = new sqlcommand (SQL, connection );
Int newid = convert. toint32 (mycomm. executescalar ());
Dbclose ();
Return newid;
}
Of course, the primary key is automatically added for the int type here. The operations of dbopen (); dbclose (); are not described here.