Foxtable(狐表)用户栏目专家坐堂 → 怎么锁定知道行


  共有9608人关注过本帖树形打印复制链接

主题:怎么锁定知道行

帅哥哟,离线,有人找我吗?
狐狸爸爸
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:管理员 帖子:47449 积分:251065 威望:0 精华:91 注册:2008/6/17 17:14:00
  发帖心情 Post By:2014/1/4 10:35:00 [显示全部帖子]

你可以指定列:

 

Dim tbnames() As String = {"第一科", "第二科", "第三科", "第四科", "第五科"}
Dim stbname As String = tbnames(0)
For i As Integer = 1 To tbnames.Length - 1
    Dim f As New Filler
    f.SourceTable = DataTables(stbname) '指定数据来源
    f.SourceCols = "组号,学号,班级,姓名"
    f.DataTable = DataTables(tbnames(i)) '指定数据接收表
    f.DataCols = "组号,学号,班级,姓名"
    'f.ExcludeExistValue = True
    f.Fill() '填充数据
   
    Dim nms() As String = {"要更新的列1","要更新的列2","要更新的列3","要更新的列4"}
    For Each dr As DataRow In DataTables(tbnames(i)).DataRows
        Dim fdr As DataRow = DataTables(stbname).Find("姓名 = '" & dr("姓名") & "'")
        If fdr IsNot Nothing Then
            For each nm As String in nms
                dr(nm) = fdr(nm)
            Next
        End If
    Next
Next

 

甚至直接:

 

Dim tbnames() As String = {"第一科", "第二科", "第三科", "第四科", "第五科"}
Dim stbname As String = tbnames(0)
For i As Integer = 1 To tbnames.Length - 1
    Dim f As New Filler
    f.SourceTable = DataTables(stbname) '指定数据来源
    f.SourceCols = "组号,学号,班级,姓名"
    f.DataTable = DataTables(tbnames(i)) '指定数据接收表
    f.DataCols = "组号,学号,班级,姓名"
    'f.ExcludeExistValue = True
    f.Fill() '填充数据
   
    For Each dr As DataRow In DataTables(tbnames(i)).DataRows
        Dim fdr As DataRow = DataTables(stbname).Find("姓名 = '" & dr("姓名") & "'")
        If fdr IsNot Nothing Then
            dr("某列1") = fdr("某列1")
            dr("某列2") = fdr("某列2")
            dr("某列3") = fdr("某列3")
            dr("某列4") = fdr("某列4")

        End If
    Next
Next


 回到顶部