none
retrieve identity following a dataSet.Update() RRS feed

  • Question

  • I'm using asp.net and a strongly typed DataSet as my Data access Layer. In my business logic layer I'm inserting a new row and calling the DataSet.Update() method. How do I retrieve the id of the newly inserted row. I've done this before in standard insert SQL by adding select SCOPE_IDENTITY() after the insert but how do you do this using dataSets and table adapters?

     

    Thanks

     

    mark

    Tuesday, June 12, 2007 2:04 PM

All replies