I am using the formview control to insert records.

The table receiving the inserts has an ID field that is an identity integer. The insert is done with the button supplied by the formview control. The formview does all the inserting. I write no insert code.

So how do I determine the identity integer of a newly Inserted record?

Right now I am adding a unique field to the table and after the insert I do a select to get the new identity ID. With all the new functionality in ASP.NET 2.0 I can't believe I have to do it this way.

Any ideas?

You can do some of this visually but it is hard to show that here.

In the INSERT command add a select statement to select the SCOPE_IDENTITY().
Be sure to put a semi colon after the INSERT statement.

InsertCommand="INSERT INTO Employees(LastName, FirstName) VALUES (@LastName, @FirstName);
                 SELECT @EmpID = SCOPE_IDENTITY()"


Define an OUTPUT parameter for the SQLDatasource.
You can change the InsertQuery property for the SQLDataSource to do this part visually.
<InsertParameters>
    <asp:Parameter Name="EmpID" Direction="Output" Type="Int32" DefaultValue="0" />
</InsertParameters>


In the SqlDataSource1_Inserted event......

   Protected Sub SqlDataSource1_Inserted(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceStatusEvent Args) Handles SqlDataSource1.Inserted

        Dim intID As Integer
        intID = Convert.ToInt32(e.Command.Parameters("@EmpID").Val ue)

    End Sub

This will do it in 1 query instead of 2.

InsertCommand="INSERT INTO Employees(LastName, FirstName) VALUES (@LastName, @FirstName);
                 Set @EmpID = SCOPE_IDENTITY()"

I thank you myself for that. I have a 2 quesry storeprocedure that i am reducing down. I did basically the same thing you did in my apps in your first example. Like your second one better. :)