RowFilter + ASP.NET, VB?

F

Foxx

New member
I need to program this rowfilter to filter out two criteria. Number one, CustomerID - I got that working. But how would I filter out the second criteria, DateClosed?

Private Function GetIncidents() As Incidents
Dim dv As DataView
dv = CType(AccessDataSource1.Select(DataSourceSelectArguments.Empty), DataView)
dv.RowFilter = "CustomerID = " & txtCustomerID.Text & " "
Dim dvRow As DataRowView = dv(0)

I tried dv.RowFilter = "CustomerID= " & txtCustomerID.Text & " " AND "DateClosed != null"...

Yeah that didn't work.
 
Back
Top