Foreign Key constraints

Question

i am new to VB.net. i need to create two Foreign Key Constraints. i am able to create a single constraint but unable to two constraints.

Syntax for one foreign key constraints.

ds.Tables(1).Constraints.Add("FK", ds.Tables(0).Columns(1), ds.Tables(1).Columns(1))

I need to reference two columns from the parent table as foreign key in the child table

Any help would be highly appreciated

Asish Raj · Answer

dsTimeCard.Tables(TimeCardDetails).Constraints.Add(TimeCardDetailsFK New DataColumn() {All Pks} New DataColumn() {All Fks}) All da best mate.

Jan Montano · Answer

Hi Asish I'm interested with your solution. Could you please post your solution? Thanks. Regards Jan

Asish Raj · Answer

i manage to solve it myself Thanks for the help.