Foxtable(狐表)用户栏目专家坐堂 → 代码咨询!


  共有2944人关注过本帖平板打印复制链接

主题:代码咨询!

帅哥哟,离线,有人找我吗?
wh420
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:五尾狐 帖子:1107 积分:10568 威望:0 精华:0 注册:2014/2/19 16:32:00
代码咨询!  发帖心情 Post By:2015/2/11 15:54:00 [只看该作者]

如何判断当FILTER定义的SQL语句找不到符合条件的记录时用MESSAGEBOX提示一遍?

 

If startdate.Value=Nothing OrElse enddate.value=Nothing Then
    Messagebox.Show("请选则起始日期或终止日期")
    Return
Else
    For Each dr As DataRow In dt2.SQLSelect("commitTime >='" & startdate.value & "' and PromiseTimeString <='" & EndDate.value & "'","","PNumber")
        Dim filter As String = "PreID like '%" & dr("PNumber") & "'"
        Dim fdr As DataRow = dt1.SQLFind(filter)
        If fdr Is Nothing Then
            Dim ndr As DataRow = dt3.AddNew
            ndr("项目编号") = dr("pNumber")
            ndr("客户名称") = dr("companyName")
        End If
    Next

End If

 

 


 回到顶部