Get Data from Datatable using LINQ
Hi
I need some data from a DataTable, I like to get this using LINQ
Somthing like this
[check code snippet]
But with this code I get the error message:
Could not find an implementation of the query pattern for source type 'System.Data.DataTable'. 'Where' not found.
I need some data from a DataTable, I like to get this using LINQ
Somthing like this
[check code snippet]
But with this code I get the error message:
Could not find an implementation of the query pattern for source type 'System.Data.DataTable'. 'Where' not found.
Var someData= from o in myDataTable where o.TestColumn1 == "SomeText" select o.TestColumn2;
ASKER
Found this..
var query = from r in employeeDataTable.AsEnumer
where r.Field<string>("LastName"
select r.Field<string>(“FirstName
var query = from r in employeeDataTable.AsEnumer
where r.Field<string>("LastName"
select r.Field<string>(“FirstName
Hi AWestEng;
Your last post should give you what you need. Is that working?
Fernando
Your last post should give you what you need. Is that working?
Fernando
ASKER
any tips how to get the data from query ? convert it to a string?
ASKER
I can see that the data is in the var, but I can't get it out.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
please refer the following link, it willbe very useful.
http://www.c-sharpcorner.com/UploadFile/VIMAL.LAKHERA/LINQResultsetToDatatable06242008042629AM/LINQResultsetToDatatable.aspx