response.write to display record id after form updates sql

[melrse]

Hi. Have had much success with obtaining help and am muddled.
I have a form updating a sql db which works fine. After the form updates the db and the connection for that single update is complete before closing, I want to display what the associated recordID for that form is back.

Have a book and see the response.write.

Also see sqldatareader. Do I need to do this when I already have the record opened for insert?

I just want to obtain after the submit button is pressed, what the recordID is for that single updated record.

Please direct me. Seems like this should be easy but obviously its not or its me.
Thanks...

 

[SiriusBlackOp]

I'm not sure if this is the best way... but it is a way.

http://forums.asp.net/p/606382/606642.aspx#606642

Basically you will have to create a Stored Procedure for your insert that returns the RecordID from the insert. Then you query the DB for your new record using the returned record ID. After the insert and query you can then close your connection.


Senior Software Developer

http://www.scoutsft.com

 

[melrse]

thank you.

 

[RiverGuy]

If you are updating a record, you would already have the record id in your DataTable or should be pulling it down into a variable if using a DataReader. If you are inserting a record, you want to use a ;SELECT SCOPE_IDENTITY() at the end of your INSERT statement. This will give you the unique identifier of the record which you just inserted.

 

[SiriusBlackOp]

SELECT SCOPE_IDENTITY()


That was what I couldn't remember! I knew there was a better way then to select the greatest id, but I couldn't remember the SQL Function at the time. Thanks for posting that.

Senior Software Developer

http://www.scoutsft.com

 

[melrse]

thank you for your help.