For Each dr3 As DataRow In DataTables("销售订单未交_销售未交统计").DataRows Dim pr3 As DataRow = DataTables("产品信息表").sqlfind("产品编号='" & dr3("产品编号") & "'") If pr3 IsNot Nothing Then dr3("材料编号") =pr3 ("材料编号") dr3("材料名称") =pr3 ("材料名称") dr3("规格型号") =pr3 ("规格型号") dr3("部件用料长度mm") =pr3 ("部件用料长度mm") End If Next