How To Save Data In Different Tables C# [Resolved]

Posted by Kasani007 under C# on 8/2/2016 | Points: 10 | Views : 1513 | Status : [Member] | Replies : 5

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

I Have 3 Tables

1) Employee_Table

2) Insurance_Table

3) Employee_Insurance_Table

Employee_Table And Insurance_Table Have No Relation And 

Employee_Insurance_Table Have Foreign Key Relation With Employee_Table And Insurance_Table 's Primary Keys

How Can I Save Data In C# Having Domain Object and Business Object ?

[Resolved]

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Rajnilari2015 on: 8/3/2016 [Member] [Microsoft_MVP] [MVP] Platinum | Points: 50

0	@Kasani007 Sir, First you insert into Employee_Table and Insurance_Table. Then write a store procedure and inside that use Merge Statement ( https://technet.microsoft.com/en-us/library/bb522522(v=sql.105).aspx ) and ensure that while inserting into Employee_Insurance_Table table, both the PK's of the tables are present. Hope that helps. -- Thanks & Regards, RNA Team Kasani007, if this helps please login to Mark As Answer. \| Alert Moderator

@Kasani007 Sir,

First you insert into Employee_Table and Insurance_Table. Then write a store procedure and inside that use Merge Statement ( https://technet.microsoft.com/en-us/library/bb522522(v=sql.105).aspx ) and ensure that while inserting into Employee_Insurance_Table table, both the PK's of the tables are present.

Hope that helps.

--
Thanks & Regards,
RNA Team

Kasani007, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Barbara on: 9/16/2016 [Member] Starter | Points: 25

1	hi guys check this article.I hope it will help you https://www.mindstick.com/blog/404/save-values-in-multiple-tables-at-a-time-using-c-sharp-and-sql-server-2008-r2 http://www.functionx.com/csharp2/dataset/Lesson04c.html http://stackoverflow.com/questions/28230222/how-to-insert-data-into-multiple-tables-at-once Kasani007, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Jayakumars on: 8/2/2016 [Member] [MVP] Bronze | Points: 25

0	hi Step1: First Design UI Entry Page for Employee_Table ex: Name,Empno,Gender and etc if you want then another page design for Employee_Insurance_Table then put dropdown list for get employee table primary key so design ddl control loaded employee name set empid primary key in datavalue field after finally inserted to transaction table this Employee_Insurance_Table then get ddl id stored to this table Employee_Insurance_Table here now inserted in your primary key thats it. Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com Kasani007, if this helps please login to Mark As Answer. \| Alert Moderator

hi

Step1:

First Design UI Entry Page for Employee_Table ex:

Name,Empno,Gender and etc if you want

then another page design for Employee_Insurance_Table

then put dropdown list for get employee table primary key so

design ddl control loaded employee name set empid primary key in datavalue field

after finally inserted to transaction table this Employee_Insurance_Table then get ddl id stored to this table

Employee_Insurance_Table here now inserted in your primary key thats it.

Mark as Answer if its helpful to you

Kumaraspcode2009@gmail.com

Kasani007, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rajnilari2015 on: 8/2/2016 [Member] [Microsoft_MVP] [MVP] Platinum | Points: 25

0	@ Kasani007 Sir, Employee_Insurance_Table is known as junction table which gets involve while two entities have multiple relationships between them. Store the PK value of both Employee_Table And Insurance_Table in that junction table. -- Thanks & Regards, RNA Team Kasani007, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Kasani007 on: 8/2/2016 [Member] Starter | Points: 25

0	thanQ Rajnilari for your response, How To Store Both Employee_Table And Insurance_Table primary keys values in Junction Table.. please let me know your valuable Information. Kasani007, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts