removing column and rows from DataTable using Linq

Question

I have a DataTable as an input which contains many columns and rows,

this is a sample table:

Input

I want get only the column Weather(sunny rows) with the column Play (any value)

so the output can be another DataTable like this:

Output

So any idea can help me a lot, thank you :)

I need tow columns as output, so list will contain what exactly ? — MBH
– MBH, Commented May 10, 2015 at 12:36
You can see my answer, you get a list with the values needed. Another DataTable would be really unuseful. — Paolo Costa
– Paolo Costa, Commented May 10, 2015 at 12:38

Sriram Sakthivel · Accepted Answer · 2015-05-10 12:34:44Z

3

Does the result has to another DataTable? I'd simply use a named or anonymous type.

var filtered = sourceTable.Rows.Cast<DataRow>()
.Where(x => x.Field<string>("WEATHER") == "sunny")
.Select(x => new
{
    Weather = x.Field<string>("WEATHER"),
    Play = x.Field<string>("PLAY")
})
.ToList();

Then you can use it as

foreach (var item in filtered)
{
    Console.WriteLine(string.Format("Weather ={0}, Play = {1}", item.Weather,item.Play));
}

If you need the result to beDataTable, you can create one and add the rows manually.

answered May 10, 2015 at 12:34

Sriram Sakthivel

73.8k7 gold badges118 silver badges200 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

MBH Over a year ago

So if I want to do another Linq statements, it is okey to be done on the new list ?

MBH Over a year ago

I may need to do group by on the new list for example

Sriram Sakthivel Over a year ago

@MBH Group by what column? You have only the filtered data in the list.

Sriram Sakthivel Over a year ago

@MBH Yes. foreach (var groupped in filtered.GroupBy(x => x.Play)) {int groupCount = groupped.Count();}

Sriram Sakthivel Over a year ago

I already answered your question. If you need more question ask another question please.

|

Paolo Costa · Accepted Answer · 2015-05-10 12:37:44Z

1

If it's ok to get an anonymous list you can do like this:

var result = dt.AsEnumerable()
               .Where(x => x["WEATHER"] == "sunny")
               .Select(x => 
                     new 
                        { 
                            WEATHER = x["WEATHER"] as string, 
                            PLAY = x["PLAY"] as string 
                        });

answered May 10, 2015 at 12:37

Paolo Costa

1,9891 gold badge12 silver badges15 bronze badges

Collectives™ on Stack Overflow

removing column and rows from DataTable using Linq

2 Answers 2

8 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related