以文本方式查看主题

-  Foxtable(狐表)  (http://foxtable.net/bbs/index.asp)
--  专家坐堂  (http://foxtable.net/bbs/list.asp?boardid=2)
----  连续下载后台数据问题  (http://foxtable.net/bbs/dispbbs.asp?boardid=2&id=189494)

--  作者:jiawei507
--  发布时间:2023/12/5 16:41:00
--  连续下载后台数据问题
Dim nms() As String = {"TextBox1", "TextBox2", "ComboBox1", "ComboBox2", "DateTimePicker1", "DateTimePicker2"}
Dim spa() As String = {"\'", "\'", "\'", "\'", "\'"}
Dim bjf() As String = {"=", "=", "=", ">=", "<="}
Dim fds() As String = {"项目编号", "项目归属", "登记分类", "登记分类","开始日期", "截止日期"}
Dim filter As String
For i As Integer = 0 To nms.Length - 1
    If e.Form.Controls(nms(i)).value IsNot Nothing Then 
        If filter > "" Then
            filter = filter & "and "
        End If 
        filter = filter & fds(i) & bjf(i) & spa(i) & e.Form.Controls(nms(i)).value & spa(i)
    End If 
Next
DataTables("项目财务表").LoadFilter = filter
DataTables("项目财务表").Load()

如何可以连续使用上面的代码的【下载工具】,之前下载的行还不被清除掉? 
老师 代码如何写呢?
辛苦了

--  作者:有点蓝
--  发布时间:2023/12/5 16:46:00
--  
要保留上次加载的行?

DataTables("项目财务表").LoadFilter = filter
DataTables("项目财务表").Load()
改为
DataTables("项目财务表").RemoveFor(filter)
DataTables("项目财务表").AppendLoad(filter)

--  作者:jiawei507
--  发布时间:2023/12/5 17:07:00
--  
解决了,谢谢版主了!辛苦了!