多个DataTable按某一列合并

来源：互联网发布：淘宝网雪纺上衣编辑：程序博客网时间：2024/06/14 11:57

//用原表

DataTable dt1 = BigCity.TableData(bTime, eTime, span, hour, source, "晴雨（雪）");

DataTable dt2 = BigCity.TableData(bTime, eTime, span, hour, source, "降水量");
DataTable dt3 = BigCity.TableData(bTime, eTime, span, hour, source, "温度");
dt3.Columns.Add("晴雨雪准确率", typeof(string));
dt3.Columns.Add("晴雨雪技巧评分", typeof(string));
dt3.Columns.Add("降水量评分", typeof(string));
dt3.Columns.Add("降水量技巧评分", typeof(string));
try
{
foreach (DataRow dr in dt3.Rows)
{
DataRow[] arrRows1 = dt1.Select(string.Format("站号='{0}'", dr["站号"].ToString()));
string qyxzql = Convert.ToDouble(arrRows1[0]["晴雨雪准确率"]).ToString("0.00");
string qyxjq = Convert.ToDouble(arrRows1[0]["晴雨雪技巧评分"]).ToString("0.00");
DataRow[] arrRows2 = dt2.Select(string.Format("站号='{0}'", dr["站号"].ToString()));
string jylpf = Convert.ToDouble(arrRows2[0]["降水量评分"]).ToString("0.00");
string jyljq = Convert.ToDouble(arrRows2[0]["降水量技巧评分"]).ToString("0.00");
dr["晴雨雪准确率"] = qyxzql;
dr["晴雨雪技巧评分"] = qyxjq;
dr["降水量评分"] = jylpf;
dr["降水量技巧评分"] = jyljq;
}
dt = dt3.Copy();
}
catch (Exception ex)
{

}

//用新表

//dt = dt3.Clone();
//dt.Columns.Add("晴雨雪准确率", typeof(string));
//dt.Columns.Add("晴雨雪技巧评分", typeof(string));
//dt.Columns.Add("降水量评分", typeof(string));
//dt.Columns.Add("降水量技巧评分", typeof(string));

//try
//{
// foreach (DataRow dr in dt3.Rows)
// {
// DataRow[] arrRows1 = dt1.Select(string.Format("站号='{0}'", dr["站号"].ToString()));
// string qyxzql = Convert.ToDouble(arrRows1[0]["晴雨雪准确率"]).ToString("0.00");
// string qyxjq = Convert.ToDouble(arrRows1[0]["晴雨雪技巧评分"]).ToString("0.00");
// DataRow[] arrRows2 = dt2.Select(string.Format("站号='{0}'", dr["站号"].ToString()));
// string jylpf = Convert.ToDouble(arrRows2[0]["降水量评分"]).ToString("0.00");
// string jyljq = Convert.ToDouble(arrRows2[0]["降水量技巧评分"]).ToString("0.00");
// DataRow dr1 = dt.NewRow();
// foreach (DataColumn dc in dt3.Columns)
// {
// string col = dc.ColumnName;
// dr1[col] = dr[col].ToString();
// }
// dr1["晴雨雪准确率"] = qyxzql;
// dr1["晴雨雪技巧评分"] = qyxjq;
// dr1["降水量评分"] = jylpf;
// dr1["降水量技巧评分"] = jyljq;
// dt.Rows.Add(dr1);
// }
//}

阅读全文

0 0