Click here to Skip to main content
15,847,264 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
how to update multiple tables with one common column in C#

i have one table with systeminfo which inserts system data in one row with userid.
i have anther table with ServiceInfo which inserts Services in another table.
but now i want to update all services in table when it's updates the SystemInfo table.
in both tables UserId is common.

but am not getting idea how to update the services .


can anyone help me solving this query.


Thanks & Regards
Sam.198979
Posted

1 solution

i guess you mean as soon SystemInfo table has some values (userId) inserted or Updated you should insert the respective UserId values of Serviceinfo to your "another table".

yes you can do it with triggers.

If it's MS SQL Server...

Refer this MSDN page-
Creation of Triggers[^]

take this as dummy example-

SQL Fiddle [^]


Regards,
 
Share this answer
 
Comments
sam.198979 26-Jun-13 3:34am    
i guess you mean as soon SystemInfo table has some values (userId) inserted or Updated you should insert the respective UserId values of Serviceinfo to your "another table".

Yes but i have more then 200 services in that table they need to update.

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



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