How to get unique datatables from single dataset

Question

0.00/5 (No votes)

See more:

Hello Experts,

Here is something tricky. I have Dataset1 as below

Tireline	Class	Item
glass1	        2	
glass1       	10	
Eagle1	        2	
Eagle1	        10

And I want them in two different datatables as below

class	Tireline	Item
2	glass1	
2	Eagle1

And

class	Tireline	Item
10	glass1	
10	Eagle1

Please help me with this

Posted 14-May-15 8:54am

sudevsu

Updated 14-May-15 9:05am

v3

Add a Solution

Comments

Sascha Lefèvre 14-May-15 15:05pm

Your question is not quite clear to me. Do you speak of a System.Data.DataSet? Those only contain System.Data.DataTables but you showed the "content" of the DataSet in form of a single table.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Answer 1 · 2015-05-14T09:19:00

Solution 1

This is easy to do with LINQ:

C#

DataTable sourceTable = dataSet.Tables[0];

foreach (var group in sourceTable.AsEnumerable().GroupBy(row => row.Field<int>("Class")))
{
    var newTable = group.CopyToDataTable();
    newTable.TableName = "Class" + group.Key;
    dataSet.Tables.Add(newTable);
}

Posted 14-May-15 9:19am

Richard Deeming

v2

Comments

Maciej Los 16-May-15 7:16am

5ed!

How to get unique datatables from single dataset

1 solution

Solution 1

Add your solution here

Preview 0

How to get unique datatables from single dataset

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us