For Each dr As DataRow In DataTables("ZFXX").DataRows Dim pr As DataRow If dr.IsNull("ZFID") Then dr("XXQ_QR") = Nothing dr("XXQ_ZR") = Nothing Else pr = DataTables("XQBD").Find("ZFID = '" & dr("ZFID") & "'", "PCRQ Desc") If pr IsNot Nothing Then dr("XXQ_QR") = pr("XXQ_QR") dr("XXQ_ZR") = pr("XXQ_ZR") Else dr("XXQ_ZR") = Nothing dr("XXQ_ZR") = Nothing End If End If Next