>Hi again,
>
>I have a dataset that I need to break into several (one at a time) based on the following logic. I will refer to this, initial, data set as BigDataSet.
>
>The dataset has a column (defined as a variable, e.g. ColumnGroup='MYCOL1'). I need to group the BigDataSet on the column ColumnGroup. Then get all rows for first group into a SmallDataSet (rows of the same MYCOL1). Then go to the next group and create another SmallDataSet. Once I create a SmallDataSet I will write it to an XML file. Therefore, I don't need all SmallDataSets, just one at a time.
>
>TIA for any suggestions.
Assuming the BigDataSet we are talking about is actually just a single DataTable, you should be able to use the LINQ GroupBy method (
https://msdn.microsoft.com/en-us/library/bb534501%28v=vs.100%29.aspx) to group by the data in that column followed by the CopyToDataTable method (
https://msdn.microsoft.com/en-us/library/bb396189%28v=vs.110%29.aspx) to put them back into separate DataTables if need be.