大家好,我在做SQL table 筛选的时候,已经做好了SQL 的目录树,但是点击节点的时候,右面SQL TABLE 里面没有反应,我用的代码如下:Dim dr As DataRow = e.Node.DataRow '获取生成此节点的行
Dim Filter As String
Dim Year As Integer = dr("年")
Dim Month As Integer = dr("月")
Dim Name As String = dr("姓名")
Select Case e.Node.Level
Case 0
Filter ="Year(开班时间) = " & Year
Case 1
Filter ="Year(开班时间) = " & Year & " And Month(开班时间) = " & Month
Case 2
Filter ="Year(开班时间) = " & Year & " And Month(开班时间) = " & Month & " And 姓名 = '" & Name & "'"
End Select
DataTables("查询表_table1").LoadFilter = Filter
DataTables("查询表_table1").Load()
请问下是什么问题了?