最后是给订单加个状态列,表示订单的不同状态。 用两个按钮,分别用于筛选显示出成交和未成交的订单。 如果要将表A的某行数据复制到表B,也很简单: Dim Cols1() As String = {"来源列一","来源列二","来源列三"} Dim Cols2() As String = {"接收列一","接收列二","接收列三"} Dim dr1 As Row = Tables("表A").Current Dim dr2 As DataRow = DataTables("表B").AddNew() For i As Integer = 0 To Cols1.Length -1 dr2(Cols2(i)) = dr1(Cols1(i)) Next
|