If e.DataCol.Name = "产品编号" Then
    Dim nms() As String = {"品名","型号","规格","合格"}
    If e.NewValue Is Nothing Then
        For Each nm As String In nms
            e.DataRow(nm) = Nothing
        Next
    Else
        Dim dr As DataRow
        dr = DataTables("产品").SQLFind("[产品编号] = \'" & e.NewValue & "\'")
        If dr IsNot Nothing
            For Each nm As String In nms
                e.DataRow(nm) = dr(nm)
            Next
        End If
    End If
End If

或者

Select Case e.DataCol.Name
    Case "品名","型号","规格","合格"
        Dim Filter As String = "[产品编号] = \'" & e.DataRow("产品编号") & "\'"
        DataTables("订单").ReplaceFor(e.DataCol.Name, e.NewValue, Filter)

        DataTables("订单").SQLReplaceFor(e.DataCol.Name, e.NewValue, Filter)
End Select

上述该怎么写呢？