刷新的代码:

Dim sd As WinForm.DateTimePicker
Dim ed As WinForm.DateTimePicker
sd = e.Form.Controls("DateTimePicker1")
ed = e.Form.Controls("DateTimePicker2")
Dim cpbh As String = e.Form.Controls("项目").Value

Dim filter As String = "1=1"
If sd.Value <> Nothing Then
    filter &= " and 出车日期 >= #" & sd.value & "#"
End If
If ed.Value <> Nothing Then
    filter &= " and 出车日期 <= #" & ed.value & "#"
End If
If cpbh <> "" Then
    filter &= " and [项目] like \'%" & cpbh & "%\' "
End If
If ed.value = Nothing AndAlso sd.value = Nothing Then
    filter &= " and 出车日期 = #" & Date.today & "#"
End If
DataTables("配载订单").LoadFilter=filter
DataTables("配载订单").Load
Dim trv As WinForm.TreeView = e.Form.Controls("TreeView1")
trv.BuildTree("配载订单", "车牌|司机|项目")
trv.Nodes.Insert("所有订单",0)

sql server 作数据源 选定日期之后 报"#"附近有语法错误 ,哪错了?