Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Linq Blues
Message
From
14/01/2015 08:10:30
John Baird
Coatesville, Pennsylvania, United States
 
General information
Forum:
ASP.NET
Category:
Other
Title:
Environment versions
Environment:
C# 4.0
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01613589
Message ID:
01613595
Views:
41
>>Succeeded in getting this passed the editor. Note that customers is a DataTable.
>>
>>  IEnumerable<DataRow[]> r1 = (IEnumerable<DataRow[]>) customers.AsEnumerable().Where(r => (r["ID"] == ID));
>>
>>
>>now how do I get the first row cast as a DataRow?
>
>var Rows = customers.AsEnumerable().Where(r => (r["ID"] == ID));
>
>DataRow r1 = new DataRow();
>int i = 0
>foreach (var Row in Rows)
>
>{
>  if (i=0)
>    {
>     r1 = Row;
>     break;
>   }
>}
>
>from the top of my head - not tested.


What?
var q = customers.AsEnumerable().FirstOrDefault(r => r.Field<int>("id") == ID);
In this case, q is TRow which is DataRow by default. Why would you suggest such a klunky work-around?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform