从效率来说,就先加载,再比较吧。
dim str_bianhao as string = ""
dim ary_bianhao(datatables("A").datarows - 1) as string
dim i as integer = 0
for each dr as datarow in datatables("A").datarows
str_bianhao = str_bianhao & "'" & dr("编号") & "',"
ary_bianhao(i) = dr("编号")
next
datatables("B").loadfilter = "编号 in (" & str_bianhao.trim(",") & ")"
datatables("B").load
for each bianhao as string in ary_bianhao
if datatables("B").find("编号 = '" & bianhao & "'" ) is nothing then
msgbox(bianhao & "不存在")
end if
next
[此贴子已经被作者于2012-11-8 23:18:12编辑过]