how to use foreign key with two tables

Question

1.00/5 (1 vote)

See more:

Hi, I have two tables

SQL

TABLE - projectpaymentschedule

COLUMN - ppsID(primary key,auto increment),milestone,completiondate,billingdate,billingrupee,projectid

TABLE - projectpaymentreceipt

COLUMN - pprID(primary key,auto increment),receiptdate,receiptamount,projectid,ppsID(Foreign key)

how to make foreign key in second table and i want when i insert data in first table automatically ppsID value inserted in second table.

Thanks in Advance.

Posted 17-Apr-12 19:44pm

mayankshrivastava

Updated 17-Apr-12 19:48pm

v2

Add a Solution

Comments

Sergey Alexandrovich Kryukov 18-Apr-12 1:46am

It has nothing to do with ASP.NET. Did you mean ADO.NET?
--SA

mayankshrivastava 18-Apr-12 1:48am

ya sory i want in ado.net or sql server

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Prasad_Kulkarni · Answer 1 · 2012-04-17T19:48:00

Solution 1

Try this:

SQL

TABLE - projectpaymentschedule

COLUMN - ppsID(primary key,auto increment),milestone,completiondate,billingdate,billingrupee,projectid

TABLE - projectpaymentreceipt

COLUMN - pprID(primary key,auto increment),receiptdate,receiptamount,projectid,ppsID FOREIGN KEY REFERENCES(ppsID)

Have a look on following threads:
Creating Primary & Foreign keys[^]
SQL-Foreign key[^]

Posted 17-Apr-12 19:48pm

Prasad_Kulkarni

Updated 17-Apr-12 19:57pm

v2

Comments

mayankshrivastava 18-Apr-12 1:52am

how to write this,
actually i don't no more about foreign key.

Prasad_Kulkarni 18-Apr-12 1:57am

Please see updated answer followed by some links..

mayankshrivastava 18-Apr-12 2:05am

I followed your links and made a foreign key.
But when i insert data in first table ppsID in not insert into second table.
is there any code write in insert query of first table ?

Abhinav S · Answer 2 · 2012-04-17T19:51:00

Solution 2

In ADo.Net you need to setup data constraints[^].
The System.Data.DataSet.EnforceConstraints property should be set to true.

Using the Cascade option will allow changes to be cascaded to related tables.

Posted 17-Apr-12 19:51pm

Abhinav S