[求助]将成绩表中的数据条件筛选（考试年月、班级等）到成绩加载表 - 专家坐堂 - Foxtable(狐表) - 新一代数据库软件，完美融合Access、Foxpro、Excel、vb.net之优势，人人都能掌握的快速软件开发工具!

Dim lms As String = "考试性质|考试年月|班级|科类|姓名"

Dim Filter As String

Dim lst As new List(of String)

For i As Integer = 0 To lms.Split("|").Length - 1

Dim s As String = Forms("筛选").Controls("combobox" & i+1).Value

If s > ""

lst.Add(lms.Split("|")(i) & "='" & s & "'")

End If

Filter = String.join(" and ",lst.ToArray)

Dim jb As New SQLJoinTableBuilder("查询表1","成绩表")

jb.AddCols("*")

jb.Filter = Filter

DataTables("成绩加载表").DataRows.Clear

Dim f As New Filler

f.SourceTable = jb.Build(True)

f.DataTable = DataTables("成绩加载表")

f.Fill()

MainTable = Tables("成绩加载表")

主题：[求助]将成绩表中的数据条件筛选（考试年月、班级等）到成绩加载表