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.