G
Guest
I'm new to .NET.. I have multiple related tables that I need to insert data
into. Lets say for example: Customers and Orders. Orders has a foreign key
Customer_Number column in it. I want to use the dataadapter update method to
do the inserts for me. Ideally I'd use a stored procedure that will generate
a unique id for the Customer Number column on insert. But I can't figure out
how will I fill the Customer_Number in the orders table?
I really have no clue here, can someone link me to an example of code that
does something like this?
Thanks!
Tom
into. Lets say for example: Customers and Orders. Orders has a foreign key
Customer_Number column in it. I want to use the dataadapter update method to
do the inserts for me. Ideally I'd use a stored procedure that will generate
a unique id for the Customer Number column on insert. But I can't figure out
how will I fill the Customer_Number in the orders table?
I really have no clue here, can someone link me to an example of code that
does something like this?
Thanks!
Tom