Retrieve newly inserted record ID?

[11D.Universe]

I'm using the Insert button in a DetailsView to insert a record into a
SQL table. I've got part of what I need to recover the record ID...

The INSERT COMMAND is:
InsertCommand="INSERT INTO [inventory] ([Active], ...) VALUES
(@Active...); select SCOPE_IDENTITY();"

The Select Command is:
SelectCommand="SELECT * FROM [inventory] where [inventoryID] =
@identity ORDER BY [InventoryID] DESC"

The Insert Parameters are:
<InsertParameters>
<asparameter Name="Active" Type="Boolean" />
...
<asp:QueryStringParameter Name="@identity"
Direction="Output" Type="Int32" />
</InsertParameters>

The Select Parameters are:
<asparameter Name="identity" Type="Int32" />

I know I'm supposed to put some code in the SqlDataSource1_Inserted
sub, but not sure what code is needed to get the InventoryID from the
inserted record.

Am I on the right track??

Any help would be appreciated...

 

[Riki]

I'm using the Insert button in a DetailsView to insert a record into a
SQL table. I've got part of what I need to recover the record ID...

The INSERT COMMAND is:
InsertCommand="INSERT INTO [inventory] ([Active], ...) VALUES
(@Active...); select SCOPE_IDENTITY();"

The Select Command is:
SelectCommand="SELECT * FROM [inventory] where [inventoryID] =
@identity ORDER BY [InventoryID] DESC"

The Insert Parameters are:
<InsertParameters>
<asparameter Name="Active" Type="Boolean" />
...
<asp:QueryStringParameter Name="@identity"
Direction="Output" Type="Int32" />
</InsertParameters>

The Select Parameters are:
<asparameter Name="identity" Type="Int32" />

I know I'm supposed to put some code in the SqlDataSource1_Inserted
sub, but not sure what code is needed to get the InventoryID from the
inserted record.

Am I on the right track??

Yes, you are.

Put this code in SqlDataSource1_Inserted (VB.NET):

If (e.Exception IsNot Nothing) Then
' log error or show error
e.ExceptionHandled = True
Return
End If
Dim InventoryID As Integer =
CInt(e.Command.Parameters("@identity").Value)

You may have to modify your INSERT command to match the parameter:
select SCOPE_IDENTITY AS @identity;

Riki