[原创]该代码增加条件 - 专家坐堂 - Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

Dim dt1 As DataTable = DataTables("表B")
Dim dt2 As DataTable = DataTables("合并村")
'dt1.StopRedraw
For Each dr As DataRow In dt1.Select("")
    Dim str As String = dr("家庭住址")
    str = str.Replace("1", "一").Replace("2", "二")

    For Each fdr As DataRow In dt2.Select("乡镇 = '" & dr("乡镇") & "'")
        Application.Doevents
        If fdr("合并前村") > "" AndAlso str.Contains(fdr("合并前村")) Then
            dr("合并前村") = fdr("合并前村")
            dr("合并后村") = fdr("合并后村")
        End If
    Next

Next
'dt1.ResumeRedraw

主题：[原创]该代码增加条件