The error is shown at select when i write next LINQ query:
DataTable dtbl = //...
int count = (from p in dtbl select p.RecordID).Max();
please help me out.
Add a comment
|
2 Answers
Try this.
int count = dtbl.Max(p => p.RecordID);
Edit:
You can't easily use Linq on a DataTable.
6 Comments
The_Butcher
isn't that just rewriting it :D?
abatishchev
@The_Butcher: It is and is better
Daniel A. White
@The_Butcher - no its not rewriting it. Its fixing the intention.
hari
dtbl is a datatable. it is giving error "'System.Data.DataTable' does not contain a definition for 'Max' and no extension method 'Max' accepting a first argument of type 'System.Data.DataTable' could be found (are you missing a using directive or an assembly reference?)" when i add this line.
Øyvind Bråthen
Try dtbl.AsEnumerable().Max(p => p.RecordID);
|
According to your comment that dtbl is a DataTable you can do:
int count = dtbl.AsEnumerable().Max(r => r.Field<int>("RecordID"));
You will need to add a reference to System.Data.DataSetExtensions.dll and add a using System.Data directive to the source file.
