Click here to Skip to main content
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 25-Jun-13 0:00am

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 Sergey Alexandrovich Kryukov 504
1 Maciej Los 349
2 Kornfeld Eliyahu Peter 325
3 DamithSL 196
4 OriginalGriff 188
0 OriginalGriff 6,303
1 DamithSL 4,764
2 Maciej Los 4,306
3 Kornfeld Eliyahu Peter 3,914
4 Sergey Alexandrovich Kryukov 3,538


Advertise | Privacy | Mobile
Web02 | 2.8.141220.1 | Last Updated 25 Jun 2013
Copyright © CodeProject, 1999-2014
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