以文本方式查看主题 -  Foxtable(狐表)  (http://foxtable.net/bbs/index.asp) --  专家坐堂  (http://foxtable.net/bbs/list.asp?boardid=2) ----  关于数据复制引用  (http://foxtable.net/bbs/dispbbs.asp?boardid=2&id=152635)

--  作者：hopestarxia --  发布时间：2020/7/17 4:28:00 --  关于数据复制引用 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("查询表") ，查询出来的结果集没有名字叫什么表，请问怎么处理？

--  作者：hopestarxia --  发布时间：2020/7/17 4:30:00 --   For Each dr1 As DataRow In DataTables("dt")  ?

--  作者：有点蓝 --  发布时间：2020/7/17 9:00:00 --   For Each dr1 As DataRow In dt.Select("[bomid] = " & bomid.text)