Dim cmd As New SQLCommand
cmd.C
Dim dt As DataTable
cmd.CommandText = "SQL查询结果 "
dt = cmd.ExecuteReader()
Dim Cols1() As String = {"goodsid","elemgid","quantity","quantity","usetime","userdef1","userdef2","userdef3","userdef4","xdqkc","zysl"}
Dim Cols2() As String = {"goodsid","elemgid","quantity","masterqty","usetime","userdef1","userdef2","userdef3","userdef4","memo","zysl"}
For Each dr1 As DataRow In DataTables("l_goodsbomnew").SQLSelect("[bomid] = " & bomid.text)
Dim dr2 As DataRow = DataTables("scdcbom").AddNew()
For i As Integer = 0 To Cols1.Length -1
dr2(Cols2(i)) = dr1(Cols1(i))
Next
Next
请问老师此种情况下，我的DR1是否能引用的是我前面的查询表？ For Each dr1 As DataRow In DataTables("查询表") ，查询出来的结果集没有名字叫什么表，请问怎么处理？
加好友 
发短信
Post By：2020/7/17 4:28:00 [只看该作者]
