主题：怎么没反应

Dim Filter As String

Dim dr As DataRow = e.Node.DataRow '获取生成此节点的行

If e.Node.Text <> "显示所有行" Then

    Select Case e.Node.Level

        Case 0

            Filter = "[chanpinfenlei1] = '" & dr("chanpinfenlei1") & "'"

        Case 1

            Filter = "[chanpinfenlei1] = '" & dr("chanpinfenlei1") & "' And [chanpinfelei2] = '" & dr("chanpinfelei2") & "'"

        Case 2

            Filter = "[chanpinfenlei1] = '" & dr("chanpinfenlei1") & "' And [chanpinfelei2] = '" & dr("chanpinfelei2") & "' And [chanpinfenlei3] = '" & dr("chanpinfenlei3") & "'"

      End Select

End If

Tables("chanpinku").Filter = Filter