making master-detail datatables from one datatable?


I have a datatable object in memory and I want to separate it into 2 tables wich they are mater-detail. I know how can I make relationships between two tables, but I don't know how can I make a datatable object from another datatable object. (Because of my app limits, I can't change source datatable or select statement)

as a simple example, suppose that my datatable has these columns:

Customers_Orders:( customerName, customerID, orderID, orderDate )

Now I want to make two datatables with these colums:

Customers:( customerName, customerID )

Orders:( customerID, orderID, orderDate )

Then I want to relate them in a dataset object. How can I do that???

Thanks for your help.

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!