以文本方式查看主题

-  Foxtable(狐表)  (http://foxtable.net/bbs/index.asp)
--  专家坐堂  (http://foxtable.net/bbs/list.asp?boardid=2)
----  填充代码问题  (http://foxtable.net/bbs/dispbbs.asp?boardid=2&id=77594)

--  作者:Carl
--  发布时间:2015/11/21 10:24:00
--  填充代码问题
For Each dr1 As DataRow In DataTables("调货明细_张笑南").Select([调货系列号],[订单号],[调货日期],[补货渠道],[供应商],[品牌],[设计师],[购买类型],[设计师款号],[D2C款号],[D2C条码],[品名],[颜色],[尺码],[数量],[预计交货日期],[实际发货日期],[物流公司],[货运单号]) 
 Dim dr2 As DataRow = DataTables("调货进度总表").AddNew() For Each dc As DataCol In DataTables("调货明细_张笑南").DataCols dr2(dc.Name) = dr1(dc.name) 
 Next 
Next 
 
图片点击可在新窗口打开查看此主题相关图片如下:qq截图20151121102142.jpg
图片点击可在新窗口打开查看
要动态更新填充,这个错误是咋回事呢?
[此贴子已经被作者于2015/11/21 10:25:12编辑过]

--  作者:Hyphen
--  发布时间:2015/11/21 10:40:00
--  

Dim cls() As String = { "调货系列号","订单号","调货日期","补货渠道","供应商","品牌","设计师","购买类型","设计师款号","D2C款号","D2C条码","品名","颜色","尺码","数量","预计交货日期","实际发货日期","物流公司","货运单号" }

For Each dr1 As DataRow In DataTables("调货明细_张笑南").DataRows
    Dim dr2 As DataRow = DataTables("调货进度总表").AddNew()
    For Each dc As String In cls
        dr2(dc) = dr1(dc)
    Next
Next