参考:
http://www.foxtable.com/webhelp/topics/1533.htm
比如:
for each s as string in DataTables("表A").getvalues("产品")
For Each dr1 As DataRow In DataTables("表A").Select("产品='" & s & "'")
Dim dr2 As DataRow = DataTables("表B").AddNew()
For Each dc As DataCol in DataTables("表A").DataCols
dr2(dc.Name) = dr1(dc.name)
Next
Next
next