Filtering

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
NicQb1
Posts: 1
Joined: Mon 02 Jul 2007 18:47
Location: Charleston, S.C.
Contact:

Filtering

Post by NicQb1 » Mon 02 Jul 2007 19:32

I'm having trouble setting a filter using the datalink control. I set the filter to but all the records are still apearing. I looked in the documentation and the samples but have not found an example using filtering or the datalink control. I have a dataset called PicsDS. The datalink's source is set to PicsDS.Pictures. The binding navigator is set to the datalink. I set the filter to:

Property CID() As Integer
Get
Return currentCust
End Get
Set(ByVal value As Integer)
loading = True
currentCust = value
Me.DataLink1.Filter = " CustID = " & CID()
End Set
End Property

where CID is the customer ID I'm trying to filter by. But even when I set the filter, all the records are still visible. Please help. I'm going insane.

Alexey
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Tue 03 Jul 2007 07:47

Please send me a small test project to reproduce the problem.
It is desirable to use 'test' schema objects, otherwise include definition of your own database objects.
Use e-mail address provided in the Readme file.
Do not use third party components.

Post Reply