Click here to Skip to main content
11,639,554 members (62,642 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C#4.0
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 24-Jun-13 23:00pm

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

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,
  Permalink  
Comments
sam.198979 at 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)

  Print Answers RSS
0 Suvendu Shekhar Giri 330
1 Sergey Alexandrovich Kryukov 244
2 CPallini 177
3 F-ES Sitecore 170
4 himanshu agarwal 167
0 OriginalGriff 9,081
1 Sergey Alexandrovich Kryukov 8,812
2 Mika Wendelius 7,027
3 Suvendu Shekhar Giri 2,650
4 F-ES Sitecore 2,548


Advertise | Privacy | Mobile
Web03 | 2.8.150731.1 | Last Updated 25 Jun 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100