Retrieve ID when Inserting from a ObjectDataSource

Hi, does anyone know how to retrieve the ID when using a objectdatasource to insert records. Here's what I'm trying to do.

I have a ODS that calls an insert method.

<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" DataObjectTypeName="Person"
InsertMethod="InsertPerson" TypeName="Person"
oninserted="ObjectDataSource1_Inserted">
</asp:ObjectDataSource>

Insert Method Inserts a record into the database.

public void InsertPerson(Person p)
{

SqlConnection con = new SqlConnection(_connectionString);
SqlCommand cmd = new SqlCommand("Insert into Person (UserName, PersonNo, FirstName, LastName, MiddleName, PersonSuffix, PersonPrefix, FullName, BirthDate, Gender, EmergencyContactName, EmergencyContactPhone, EmergencyContactEmail, EmergencyContactRelationship, LegacyPersonIdentifier, Attribute1, Attribute2, Attribute3, Attribute4, Attribute5, Attribute6, Attribute7, Attribute8, Attribute9, Attribute10, ActiveFlag, StartDate, EndDate, CreationDate, CreatedBy, LastUpdateDate, LastUpdatedBy) values (@username, @personno, @firstname, @lastname, @middlename, @personsuffix, @personprefix, @fullname, @birthdate, @gender, @emergencycontactname, @emergencycontactphone, @emergencycontactemail, @emergencycontactrelationship, @legacypersonidentifier, @attribute1, @attribute2, @attribute3, @attribute4, @attribute5, @attribute6, @attribute7, @attribute8, @attribute9, @attribute10, @activeflag, @startdate, @enddate, @creationdate, @createdby, @lastupdatedate, @lastupdatedby)", con);
cmd.Parameters.AddWithValue("@username", p.UserName);
cmd.Parameters.AddWithValue("@personno", p.PersonNo);
cmd.Parameters.AddWithValue("@firstname", p.FirstName);
//removed other parameters to shorten code
using (con)
{
con.Open();
cmd.ExecuteNonQuery();
}
}
}

When I try to output the ID of the inserted record, I only get zero.

protected void ObjectDataSource1_Inserted(object sender, ObjectDataSourceStatusEventArgs e)
{

int id = Convert.ToInt32(e.ReturnValue);
lblFormviewResult.Text = "Record Successfully Added." + id.ToString();
}

Any help would be greatly apprecated. Jason

Re: Retrieve ID when Inserting from a ObjectDataSource

Two changes. First to your sql command, add this at the very end:

...@lastupdatedate, @lastupdatedby); SELECT SCOPE_IDENTITY();", con);

Then change this:

cmd.ExecuteNonQuery();

to this:

int id = cmd.ExecuteScalar();

Re: Retrieve ID when Inserting from a ObjectDataSource

Thank you Tab. It worked!