110,534
社区成员
发帖
与我相关
我的任务
分享
DataTable dt = dataSet.Tables["route"];
var query = (from row in dt.AsEnumerable() select new { rowIpAdess = row.Field<string>("IP地址") }).Distinct();
foreach (var row in query)
{
List<DataRow> drs = (from d in dt.AsEnumerable()
where d["下行速率"].ToString() == (from f in dt.AsEnumerable()
where f["IP地址"].ToString() == row.rowIpAdess.ToString()
select f).Max(p => p["下行速率"]).ToString()
select d).ToList();
}
var query = (from row in dt.AsEnumerable() select new { rowIpAdess = row.Field<string>("IP地址") }).Distinct();
foreach (var row in query)
{
DataRow[] dr = dataSet1.Tables["routestata"].Select("IP地址='" + row.rowIpAdess.ToString() + "'");
object max = dr.Max(p => p["下行速率"]);
object d = dr.Where(p => p["下行速率"]==max);
}