日期:2014-05-17 浏览次数:20718 次
private DataTable MergeDataTable(DataTable dt1, DataTable dt2)
{
DataTable returnDt = new DataTable();
var merge = from main in dt1.AsEnumerable()
join station in dt2.AsEnumerable() on main.Field<string>("区站号") equals station.Field<string>("区站号")
select new
{
区站号 = main.Field<string>("区站号"),
日期时间 = main.Field<string>("日期时间"),
站名 = station.Field<string>("站名"),
市 = station.Field<string>("市"),
县 = station.Field<string>("县"),
经度 = station.Field<object>("经度"),
纬度 = station.Field<object>("纬度"),
三小时雨量 = main.Field<object>("三小时累积雨量"),