以文本方式查看主题 - Foxtable(狐表) (http://foxtable.com/bbs/index.asp) -- 专家坐堂 (http://foxtable.com/bbs/list.asp?boardid=2) ---- 关于数据复制引用 (http://foxtable.com/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) |