Output Parametes

[Khaledinho]

Hi all

In ADO.NET I use the SqlDataAdapter to update the database.
The primay key is an autonumber colums (Identity in SQL Server).

When inserting new rows to the dataset I generate unique values for them.
When Updating the database with the data adpater.update method the primary values will be different from the ones i have in the dataset because they autonumber in the database.
How do i return the newly generated ID number (in the sql server or access) to the column i have in the dataset.

Is this could be done with SQL Or OleDB Parameters

Thanks to all

 

[bri189a]

You need your update stored procedure to also return the last record inserted using the @@IDENTITY keyword. Then have youre UpdateRowSource for Insert command to FirstReturnedRecord