I have denormalized data in a DataTable. The data contains employee names, and the pay they got over a series of pay cycles. i.e.: My DataTable contains: Employee 1 Jan-1-2012 $100 Employee 2 Jan-1-2012 $300 Employee 1 Feb-1-2012 $400 Employee 2 Feb-1-2012 $200 Employee 1 Mar-1-2012 $150 Employee 2 Mar-1-2012 $325 How can load this data into a DataSet where the parent DataTable contains the employees name, and the child DataTable contains details of the paycheck?

How can I convert a datatable to a related dataset

I have denormalized data in a DataTable.

The data contains employee names, and the pay they got over a series of pay cycles. i.e.:

My DataTable contains:

Employee 1  &nbsp; Jan-1-2012  &nbsp;  $100
Employee 2  &nbsp; Jan-1-2012  &nbsp;  $300
Employee 1  &nbsp; Feb-1-2012  &nbsp;  $400
Employee 2  &nbsp; Feb-1-2012  &nbsp;  $200
Employee 1  &nbsp; Mar-1-2012  &nbsp;  $150
Employee 2  &nbsp; Mar-1-2012  &nbsp;  $325

How can load this data into a DataSet where the parent DataTable contains the employees name, and the child DataTable contains details of the paycheck?

How can I convert a datatable to a related dataset

3 Answers