Inserting data from multiple related tables - need help

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filling in a field based on data in another table 1
Using UpdateDataSet from Enterprise Library January 2006 2
Update Multiple Tables in Database using DataRelations 8
how to add xml data to listbox? 1
Filling a Parent/Child DS - Parent WHERE Clause 1
Trying to display data in a datagrid 2
Multiple tables in DataSet - various questions... 4
Entity Framework table related to multiple entities 0

Top