Linq to datatable conversion

[patrick]

Hello.

Datatable dt = from b in datatable.AsEnmerable() group b by b.Field<string>("column");

In above code, an errr ocurs.

 

[Skydiver]

What is the error?

 

[patrick]

What is the error?

Error CS0266 : Cannot implicitly convert type
System.collections.Generic.IEnumerable<System.Linq.IGrouping<string, System.Data.DataRow>>' to System.Data.Datatable.


I want to Return Datatable type, By Grouping Colum of Datatable.

The method of adding System.Data.DatasetExtention is Excluded.

 

[jmcilhinney]

The result of that query is not a DataTable so it can't be assigned to a variable of that type. If you want a DataTable, you have to create one. LINQ to DataSet does provide a CopyToDataTable method but that's not going to work in your case anyway, because you have performed grouping in your query so the result does not contain DataRows. If you want a new DataTable with a different schema to the old one, you're going to have to create it manually. If you're still confused, maybe you should provide more detail about your current input and your expected output.

 

[Skydiver]

Or he could do a SelectMany() to try to flatten the grouping back down to data rows, and then use the CopyToDataTable().

 

[jmcilhinney]

Or he could do a SelectMany() to try to flatten the grouping back down to data rows, and then use the CopyToDataTable().

True, but that seems like it would probably defeat the purpose of the grouping in the first place. I'm not sure that we have enough information to tell for sure either way. Mind you, the OP did say this:

The method of adding System.Data.DatasetExtention is Excluded.

so I'm not sure whether that means that it's a class assignment and they're not allowed to use CopyToDataTable anyway.

 

[patrick]

Or he could do a SelectMany() to try to flatten the grouping back down to data rows, and then use the CopyToDataTable().

Datatable dt = from b in datatable.AsEnmerable() group b by b.Field<string>("column");

the

Or he could do a SelectMany() to try to flatten the grouping back down to data rows, and then use the CopyToDataTable().

DataTable

Hello. The conversion must be done as shown in the picture below. I programmed the code below. I don't like the code below. How can I convert DataTable efficiently? DataRow[] rowKPS = originalDt.Select("subject = 'KPS'"); DataRow[] rowDPA = originalDt.Select("subject = 'DPA'"); DataRow[]...

csharpforums.net

I was here to do this.

 

[Skydiver]

so I'm not sure whether that means that it's a class assignment and they're not allowed to use CopyToDataTable anyway.

Given that the OP is @patrick , he or she (since they seem to be the body double of @Anwind) always seems to have some odd arbitrary inexplicable restriction, that would not be surprising.

 

[patrick]

Given that the OP is @patrick , he or she (since they seem to be the body double of @Anwind) always seems to have some odd arbitrary inexplicable restriction, that would not be surprising.

Please help me ㅠㅠ

 

[jmcilhinney]

Please help me ㅠㅠ

If you're still confused, maybe you should provide more detail about your current input and your expected output.

Apparently you are still confused, so please help us to help you by providing all the relevant information.

 

[cjard]

Please help me ㅠㅠ

It's difficult to help some people; instead of responding to questions they are asked, they just carry on repeating that they need help. This part we already know, given that they are asking questions in a help forum.

Make yourself easier to help for best effectiveness