加好友 发短信
等级:版主
帖子:85326
积分:427815
威望:0
精华:5
注册:2012/10/18 22:13:00
|
Post By:2017/12/15 11:05:00 [只看该作者]
填充之前,先查找
Dim Cols1() As String = {"项目名称","县区","第几期结算","征地数量"}'指定数据来源列 Dim Cols2() As String = {"项目名称","县区","第几期结算","本期结算征地数量"}'指定数据接收表 For Each dr1 As DataRow In DataTables("征地统计表").Select("[第几期结算] > 0") Dim dr2 As DataRow = DataTables("S征地计量统计表").Find("项目名称 = '" & dr1("项目名称") & "' and 县区 = '" & dr1("县区") & "' and 第几期结算 = '" & dr1("第几期结算") & "' and 本期结算征地数量 = '" & dr1("征地数量") & "'") If dr2 Is Nothing Then dr2 = DataTables("S征地计量统计表").AddNew() End If For i As Integer = 0 To Cols1.Length -1 dr2(Cols2(i)) = dr1(Cols1(i)) Next Next
|
|