狐爸,你好!
dr("纸材编号及名称")=e.DataRow(r)("E21")
此代码错误,请教哪里不对!谢~~
以下是要把所选行每一行中的三组数据分别复制到新表中,
Dim dtb As New DataTableBuilder("统计")
dtb.AddDef("纸材编号及名称", Gettype(String), 32)
dtb.AddDef("订单数量", Gettype(Integer))
dtb.AddDef("制程", Gettype(String), 7)
dtb.AddDef("订单号码", Gettype(String), 15)
dtb.Build()
With Tables("JF")
For r As Integer = .TopPosition To .BottomPosition
Dim dr As DataRow = DataTables("统计").AddNew
dr("纸材编号及名称")=e.DataRow(r)("E21")
dr("订单数量")=e.DataRow(r)("E9")
dr("制程")=e.DataRow(r)("E11")
dr("订单号码")=e.DataRow(r)("E1")
Dim dr1 As DataRow = DataTables("统计").AddNew
dr1("纸材编号及名称")=e.DataRow(r)("E22")
dr1("订单数量")=e.DataRow(r)("E7")
dr1("制程")=e.DataRow(r)("E11")
dr1("订单号码")=e.DataRow(r)("E1")
Dim dr2 As DataRow = DataTables("统计").AddNew
dr2("纸材编号及名称")=e.DataRow(r)("E23")
dr2("订单数量")=e.DataRow(r)("E20")
dr2("制程")=e.DataRow(r)("E11")
dr2("订单号码")=e.DataRow(r)("E1")
Next
End With
MainTable= Tables("统计")