@@IDENTITY (without Stored Procedures)

Hi guys, I found this page which explains how to get hold of an @@IDENTITY/the last identity column added from your database without using a stored procedure (I haven't been using these).

http://blog.developers.ie/cgreen/archive/2007/08/20/sqldatasource-getting-identity-after-insert.aspx

 Using that as a basis, I have been using the following but nothing is showing in the label that should return the latest identity. Any ideas what I'm doing wrong? I can't figure out why it's not returning anything (the data is going into Orders table fine).


InsertCommand="INSERT INTO [Orders] (...) VALUES (...); SELECT @OrderID = @@Identity"


(Where the OrderID is the PK IDENTITY (auto inc) column of "Orders" table)


my insert command:

<InsertCommands>

            <asp:Parameter Direction="Output" Name="OrderID" Size="4" Type="Int16" />

</InsertCommands>

 


Then I click a button to update the orders table, and ideally I'd see the updated OrderID column appear in the label4 below, but I don't :(

 

C# Code:

    protected void SqlDataSource1_Inserted(object sender, SqlDataSourceStatusEventArgs e)
    {
       object newId = e.Command.Parameters["@OrderID"].Value;
       Label4.Text = newId.ToString();

    }