Gaining Access to an Identity value

  • Thread starter Thread starter Jerry Camel
  • Start date Start date
J

Jerry Camel

When I add a new row to a table that has an Identity column, how can I
access the value of the identity column for the row that I just added. Do I
have to re-fill the dataset through the adapter? If I do that, how can I
tell which is the row I just added?

Thanks

Jerry
 
You do have to use the data adapter, because the value of the identity
column has no meaning until you have updated the server. You can subscribe
to the data adapter's RowUpdated event, and then SELECT @@IDENTITY.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to get the value of ID columns from older tables? 2
SQLDataSource and Identity column 3
VBA - retrieve data on last create named range from previous inserted named range 0
Retrieving Identity Values after DetailsView Insert 4
@@identity 2
How to add a new row to a DataList 7
Old digital copier machines store what was copied on an internal hard drive! 8
Problem returning identity from SQL Server when string contains semicolon 3

Back
Top