Help with Linq expression

[Nahid_Sultana]

Hi, I am very new at this can anyone explain me in detail. I was using the linq expression:

(From row In dt Order By DateTime.ParseExact(row.Item(“Database date”).ToString, “dd MMMM yyyy HH:mm:ss”,System.Globalization.CultureInfo.InvariantCulture) Descending Select row).CopyToDataTable

But everytime I am having this error,

Compiler error(s) encountered processing expression “(From row In dt Order By DateTime.ParseExact(row.Item(“Database date”).ToString, “dd MMMM yyyy HH:mm:ss”,System.Globalization.CultureInfo.InvariantCulture) Descending Select row).CopyToDataTable”.
Expression of type ‘System.Data.DataTable’ is not queryable. Make sure you are not missing an assembly reference and/or namespace import for the LINQ provider

I have imported the namespace system.linq but dont know what I am doing wrong or whether I need to install the package.

[Yoichi]

Hi,

It seems same problem as the following post.
Can you try #2 post of the following?

AsEnumerable is not a member of 'System.Data.Datatable'

When trying to use the AsEnumerable() method on a data table, i receive a error stating that AsEnumerable is not a member of ‘System.Data.Datatable’. I’ve seen someone else with this problem and their solution was to use temporary data table activities in their project to load in the System.Data.DataSetExtension library. However this has not worked for me. Any help would be greatly appreciated. Thank you.

Regards,

[Nahid_Sultana]

Thank you. It worked.