急，在线等。一个Linq问题

[zfy244]

DataTable dt = new DataTable();
			dt.Columns.AddRange(new DataColumn[] { new DataColumn("KeyName", typeof(string)),
                                         new DataColumn("KeyCode", typeof(string)),
										 new DataColumn("KeyValue",typeof(int)),
                                         new DataColumn("DateTime", typeof(DateTime)) });
			dt.Rows.Add(new object[] { "温度", "6.1.1.2", 120, new DateTime(2013, 1, 1, 0, 12, 5) });
			dt.Rows.Add(new object[] { "温度", "6.1.1.2", 100, new DateTime(2013, 1, 1, 0, 12, 5) });
			dt.Rows.Add(new object[] { "温度", "6.1.1.2", 50, new DateTime(2013, 1, 1, 5, 0, 0) });
			dt.Rows.Add(new object[] { "温度", "6.1.1.2", 90, new DateTime(2013, 1, 1, 5, 0, 12) });
			dt.Rows.Add(new object[] { "温度", "6.1.1.2", 80, new DateTime(2013, 1, 1, 0, 12, 5) });


			var query = from t in dt.AsEnumerable()
						group t by new { keyName = t.Field<string>("KeyName"), dateTime = t.Field<DateTime>("DateTime").ToString("yyyy-MM-dd HH") } into m
						select new
						{
							KeyName = m.Key.keyName,
							DateTime = m.Key.dateTime,
							Count = m.Sum(n => n.Field<int>("KeyValue"))
						};

如何把这里的返回类型Var类型变成DataRow

[bdmh]

遍历query结果，创建datarow

            foreach (var v in query)
            {
                //这里访问v的值，并创建datarow
                MessageBox.Show(v.DateTime);
            }

[threenewbee]

foreach (var item in query) dt.Rows.Add(new string[] { item.KeyName, item.... });

[q107770540]

			var query = from t in dt.AsEnumerable()
						group t by new { keyName = t.Field<string>("KeyName"), dateTime = t.Field<DateTime>("DateTime").ToString("yyyy-MM-dd HH") } into m
						select new
						{
							KeyName = m.Key.keyName,
							KeyCode= m.First().Field<string>("KeyCode"),
							KeyValue= m.Sum(n => n.Field<int>("KeyValue")),
							DateTime =DateTime.ParseExact(m.Key.dateTime,"yyyy-MM-dd HH",null),
						};
			var result=dt.Clone();
			query.ToList().ForEach(q=>result.Rows.Add(q.KeyName,q.KeyCode,q.KeyValue,q.DateTime));