Create Procedure "InsertnewOrder"

As

Insert into Orders(orderDate, orderStatus) Values(getdate(),'Shopping')

RETURN (@@IDENTITY)

Dim myCon As SqlConnection
myCon = New SqlConnection(conString)
Dim myCmd As SqlCommand
myCmd = New SqlCommand("InsertnewOrder", myCon)
myCmd.CommandType = CommandType.StoredProcedure
myCmd.Parameters.Add("@return", SqlDbType.Int)
myCmd.Parameters("@return").Direction = ParameterDirection.ReturnValue
myCon.Open()
myCmd.ExecuteNonQuery()
Session("orderID") = myCmd.Parameters("@return").Value.ToString()