Click here to Skip to main content
15,885,366 members
Search within:


How to update a foreign key in table B with primary key of another table A via cursor and also to rollback if any issue occurs on running cursor?
Please Sign up or sign in to vote.
1.75/5 (4 votes)
See more:
C#2.0
C#
ASP.NET
How to update a foreign key in table B with primary key of another table A via cursor and also to rollback if any issue occurs on running cursor?
There are 1000 records in Table B with foreign key value to be inserted fetching the primary Key value of Table A. I am using asp.net with c#.
Posted
Add a Solution
Comments
Prasad Avunoori 21-May-14 7:53am    
Can you please share your two tables structure? That could be helpful.
Prasad Avunoori 21-May-14 7:55am    
For Transaction:
Begin Try
Begin Transaction
--Cursor comes here
Commit
End Try
Begin Catch
Rollback
Raiserror("Erro occured", 16,1)
End Catch
ZurdoDev 21-May-14 8:06am    
This does not make sense. Can you explain more clearly what you need to do?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
Alter table FOREIGN KEY error
Python MYSQL primary key insert as foreign key in table
How do I insert a row of values to a table with a composite foreign key that includes the primary key?
How to update primary key table?
How to insert data to table in database with transaction although foreign key in another table null
change name of the primary key which is a foreign key for another table
Failed to add the foreign key constraint. Missing index for constraint ' in the referenced table ''
Entity framework migration C# GUID foreign keys
Django.db.utils.integrityerror: the row in table 'jobs_jobs' with primary key '1' has an invalid foreign key:
inserting values into foreign key table and primary key table

Advertise
Privacy
Cookies
Terms of Use
Last Updated 21 May 2014
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web03 2.8:2024-04-02:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900