How to: Filter Data by Multiple Columns

ASPxGridView1.FilterExpression = "[Budget] > 100000  AND [Location] = 'Monterey'";
ASPxGridView1.SettingsText.Title = ASPxGridView1.FilterExpression;
// ...
// An example on how to filter by dates
DateTime date1 = new DateTime(1995, 1, 1);
DateTime date2 = new DateTime(1995, 7, 1);
string filter = String.Format("[OrderDate] > #{0}# And [OrderDate] < #{1}#",
                    date1.ToShortDateString(), date2.ToShortDateString());
ASPxGridView1.FilterExpression = filter;

Private Sub SurroundingSub()
    ASPxGridView1.FilterExpression = "[Budget] > 100000  AND [Location] = 'Monterey'"
    ASPxGridView1.SettingsText.Title = ASPxGridView1.FilterExpression
    Dim date1 As DateTime = New DateTime(1995, 1, 1)
    Dim date2 As DateTime = New DateTime(1995, 7, 1)
    Dim filter As String = String.Format("[OrderDate] > #{0}# And [OrderDate] < #{1}#", date1.ToShortDateString(), date2.ToShortDateString())
    ASPxGridView1.FilterExpression = filter
End Sub