C# How do i merge two DataTable Row into one row

Question

I have a datatable that looks like below which have been populated from Database

How can i make the result to look like below

Sorry for my bad explanation,Thank you very much

The thing is , this datatable i have manually insert row from another datatable, is there anyway to use C# to di it? — Ku Han, Sep 24 '20 at 03:19
@KuHan I have added an [answer](https://stackoverflow.com/a/64040600/5519709) for C#, take a look. — Selim Yildiz, Sep 24 '20 at 06:22

score 1 · Answer 1 · answered Sep 23 '20 at 19:14

1

You would need to write something like this:

Select
PN,
[Description],
Sum(January) AS January,
Sum(February) AS February,
Sum(March) AS March,
Sum(April) AS April
FROM [YourTable]
GROUP BY
PN,
[Description]

answered Sep 23 '20 at 19:14

Brimbles

11
1

The thing is , this datatable i have manually insert row from another datatable, is there anyway to use C# to di it? – Ku Han Sep 24 '20 at 03:19

score 0 · Accepted Answer · answered Sep 24 '20 at 06:22

If you want to do it with Datatable instead of SQL you can use:

dt = dt.AsEnumerable()
       .GroupBy(r => new {PN = r["PN"], Description = r["Description"]})
       .Select(g => 
       {  
            var row = dt.NewRow();

            row["PN"] =  g.Key.PN;
            row["Description"] = g.Key.Description;
            row["January"] =  g.Sum(r => r.Field<int>("January"));
            row["February"] =  g.Sum(r => r.Field<int>("February"));
            row["March"] =  g.Sum(r => r.Field<int>("March"));
            row["April"] =  g.Sum(r => r.Field<int>("April"));
            
            return row;
       
       })
       .CopyToDataTable();

See: How do I use SELECT GROUP BY in DataTable.Select(Expression)?

C# How do i merge two DataTable Row into one row

2 Answers2