Insert Data w/ DataSet and Retrieve Identity

[jtgurkin]

I am using a dataset and sql express 2005 to handle my data. I need to be able to insert data in one table and then insert data in another related table at the same time taking the PK from on table to use as a FK in the other.

Is there anyway to accomplish this?

 

[ca8msm]

Yes, in a stored procedure using scope_identity() to retrieve the last inserted value.


____________________________________________________________
Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]

Need help finding an answer? Try the Search Facility or read FAQ222-2244.

 

[jtgurkin]

How can I edit the stored proceedure that the dataset builds for me?

 

[ca8msm]

Build the stored procedure on the database using the database tools (i.e. SQL Server uses Query Analyser, Management Studio, Enterprise Manager etc).


____________________________________________________________
Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]

Need help finding an answer? Try the Search Facility or read FAQ222-2244.