After inserting data into the SqlServer database using TableAdapter, how to obtain the ID of the auto-increment type?

ctert2

After inserting data into the SqlServer database using TableAdapter, how to obtain the ID of the auto-increment type?
Can not use stored procedures, I do not know which master can help solve.
The key is whether the InsertCommand in the TableAdapter can return @@ Indentity, or create a new OUTPUT parameter and return @@ Indentity.

maggic

SELECT @@ Indentity returns.

ctert2

INSERT INTO TM_Class
      (D_ClassName, D_RootID, D_Level, D_Order, D_Summary)
VALUES (@ D_ClassName, @ D_RootID, @ D_Level, @ D_Order, @ D_Summary)
GO
SELECT SELECT @@ Indentity FROM TM_Class

Is this written in the InsertCommand of the TableAdapter? But TableAdapter's InsertCommand does not support running two SQL statements at the same time! !! !!

ctert2

This is a question about strongly typed DataSets.

我爱圣骑士

You can use transactions, insert to start, and select to end.