Loading

Foreign Key constraints

Asish Raj

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Asish Raj19y ago

dsTimeCard.Tables("TimeCardDetails").Constraints.Add("TimeCardDetailsFK", New DataColumn() {All Pks}New DataColumn() {All Fks})

All da best mate.
Jan Montano19y ago
Hi Asish,

I'm interested with your solution. Could you please post your solution? Thanks.

Regards,
Jan
Asish Raj19y ago
i manage to solve it myself

Thanks for the help.