110,565
社区成员
发帖
与我相关
我的任务
分享
DataTable dt = new DataTable();
dt.Columns.Add("名称", typeof(string));
dt.Columns.Add("时间", typeof(int));
dt.Columns.Add("温度", typeof(int));
DataRow dr1 = dt.NewRow();
dr1["名称"] = "传感器1";
dr1["时间"] = 1;
dr1["温度"] = 11;
dt.Rows.Add(dr1);
DataRow dr2 = dt.NewRow();
dr2["名称"] = "传感器1";
dr2["时间"] = 2;
dr2["温度"] = 12;
dt.Rows.Add(dr2);
DataRow dr3 = dt.NewRow();
dr3["名称"] = "传感器1";
dr3["时间"] = 3;
dr3["温度"] = 13;
dt.Rows.Add(dr3);
DataRow dr4 = dt.NewRow();
dr4["名称"] = "传感器1";
dr4["时间"] = 4;
dr4["温度"] = 14;
dt.Rows.Add(dr4);
DataRow dr5 = dt.NewRow();
dr5["名称"] = "传感器1";
dr5["时间"] = 5;
dr5["温度"] = 15;
dt.Rows.Add(dr5);
DataRow dr6 = dt.NewRow();
dr6["名称"] = "传感器2";
dr6["时间"] = 1;
dr6["温度"] = 11;
dt.Rows.Add(dr6);
DataRow dr7 = dt.NewRow();
dr7["名称"] = "传感器2";
dr7["时间"] = 2;
dr7["温度"] = 12;
dt.Rows.Add(dr7);
DataRow dr8 = dt.NewRow();
dr8["名称"] = "传感器2";
dr8["时间"] = 3;
dr8["温度"] = 13;
dt.Rows.Add(dr8);
DataRow dr9 = dt.NewRow();
dr9["名称"] = "传感器2";
dr9["时间"] = 4;
dr9["温度"] = 14;
dt.Rows.Add(dr9);
DataRow dr10 = dt.NewRow();
dr10["名称"] = "传感器2";
dr10["时间"] = 5;
dr10["温度"] = 15;
dt.Rows.Add(dr10);
var vardt = from p in dt.AsEnumerable()
group p by p.ItemArray[0] into g
select new
{
GroupName = g.Key,
TempDataStr = string.Join(";", g.Select(p => { return string.Format("[{0},{1}]", p.ItemArray[1].ToString(), p.ItemArray[2].ToString()); }))
};
foreach (var outputvar in vardt)
{
MessageBox.Show(outputvar.GroupName + " " + outputvar.TempDataStr);
}