Re: ASP/ADO/VB.NET: How to update multiple datatables with typed datasets ?



Basically, the problem is this: the field PizzaNr is a primairy key in 3 tables (Pizza, PizzaOnderdelen and PizzaPrijs). If PizzaNr was a foreign key in the other 2 tables, then it wouldnt be a problem.
So I have to adjust my VB code so that the 3 tables are updated together, but how do I do that ? Could I use an SQL statement ?

.


Loading