Rss & SiteMap
Foxtable(狐表) http://www.foxtable.com
支持!~
这是多余的,表本来就是Sort属性,过去之后,你想怎么排序都行。
如果你喜欢的话,可以不用Filler,自己写一段简单的代码:
Dim Name1 As New String{"来源列1","来源列2"}
Dim Name2 As New String{"接收列1","接收列2"}
For Each dr1 As DataRow = DataTables("来源表").Select(条件表达式,排序)
Dim dr2 = DataTables("接收表").AddNew()
For i As integer = 0 To Names.Length - 1
dr2(Names2(i)) = dr1(Names1(i))
Next
Next
这样才对,只是,如果我不想在表B中新增行,又如何做呢?
Dim Name1() As String ={"第一列","第二列"}
Dim Name2() As String ={"第三列","第四列"}
For Each dr1 As DataRow In DataTables("表A").Select("[第一列]> 0","_Identify")
Dim dr2 As DataRow = DataTables("表B").AddNew()
For i As integer = 0 To Name1.Length - 1
dr2(Name2(i)) = dr1(Name1(i))
Next
Next
Next
Dim Name1() As String ={"第一列","第二列"}
Dim Name2() As String ={"第三列","第四列"}
Dim n As integer
For Each dr1 As DataRow In DataTables("表A").Select("[第一列]> 0","_Identify")
Dim dr2 As DataRow = DataTables("表A").DataRows(n)
For i As integer = 0 To Name1.Length - 1
dr2(Name2(i)) = dr1(Name1(i))
Next
n = n +1
Next