Get @@IDENTITY Of New Inserted Record,

I am using VS.net (2003) SQLcommand TEXT. with input params.


SQL server 2000








Can anyone tell me how to get the Identity value (field value, Idenity col) when you do an insert? I want to get the Identity value, then redirect the user to another page and use this identity value so they can update more (other) fields that are on that page.





My code so far that works... but Where do I put @@IDENTITY ?


How do I call or assign the @@IDENTITY value to a value in my aspx.vb code page?





Question: how do I get the Identity value from the ID column.


Question: How do I assign that value to some variable in code, say, assign it to (Session("App_ID")) = IdentityValueOrSomething?Help...


---------------------


INSERT INTO App


(AppName, Acronym, Description,bla bla bla bla........)


VALUES (@AppName, @Acronym, @Description, bla bla bla bla........)





-----------------------------





Private Sub btnAddApp_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAddApp.Click


With cmdAddApp


'.Parameters("@app_id").Value = Session("App_ID")


.Parameters("@AppName").Value = txtAppName.Text


.Parameters( bla bla bla.............


.Parameters( bla bla bla.............


.Parameters( bla bla bla.............





End With


Try


cnAppKBdata.Open()


cmdAddApp.ExecuteNonQuery()


cnAppKBdata.Close()


''''''''''''''Session("App_ID") = whatever the @@IDENTITY is....'''''''''''''''''''''''''''??


Response.Redirect("AppUpdate.asp")


Catch ex As Exception





End Try


End Sub








Anyone have the lines of code that does this?





Any advise or examples :) thanks you.