Я использую vb.net, вот мой код для фильтрации источника привязки. Я получаю эту ошибку. Синтаксическая ошибка: отсутствует операнд перед оператором «И».
Private Function SetFilter() As String
Dim datee As String = String.Format("datee >= #{0:M/dd/yyyy}# AND datee <= #{1:M/dd/yyyy}#", _
DateTimePicker1.Value, _
DateTimePicker2.Value)
Dim client As String = If((TextBox1.Text.Length > 0), String.Format("[client] LIKE '%{0}%'", TextBox1.Text), "")
Dim ref As String = If((TextBox2.Text.Length > 0), String.Format("[REF] LIKE '%{0}%'", TextBox2.Text), "")
Return String.Format("{0} AND {1} AND {2}", datee, client, ref)
End Function
Private Sub DateTimePicker1_ValueChanged(sender As System.Object, e As System.EventArgs) Handles DateTimePicker1.ValueChanged
SalesBindingSource.Filter = SetFilter()
End Sub
Private Sub DateTimePicker2_ValueChanged(sender As System.Object, e As System.EventArgs) Handles DateTimePicker2.ValueChanged
'error here
SalesBindingSource.Filter = SetFilter()
End Sub
Private Sub TextBox1_TextChanged(sender As System.Object, e As System.EventArgs) Handles TextBox1.TextChanged
SalesBindingSource.Filter = SetFilter()
End Sub
Private Sub TextBox2_TextChanged(sender As System.Object, e As System.EventArgs) Handles TextBox2.TextChanged
SalesBindingSource.Filter = SetFilter()
End Sub