标题：加载关联表的数据遇到的问题

表A和表C关联，关联列是"编号"：


dim barows as list(of datarow) = datatables("表A").select("[编号] <> ''")
for each barow as datarow in barows
   DataTables("表C").LoadFilter = "[编号] = '"& barow("编号") &"' "
   DataTables("表C").Load()
next

只能加载到1条记录,不知这个问题应怎样解决？

dim barows as list (of datarow) =datatables("表A").select("[编号] <>''")
dim a as string
for each b as datarow in barows
 a = " [编号] = '"& b("编号") & " ' " & " or "  & a
next
a =a.remove(a.length-4)
datatables("表C").loadfilter = a
datatables("表c").load()