Hi,

Sorry may be my word confused you. What I mean is you can first bind the data queried from database to the DataGridView without filter. Do you see all data there? Then call the BindingSource.Filter to get the filtered rows. It works properly on my side, I hope you can find the problem soon.

Sincerely,
Kira Qian

---

Please mark the replies as answers if they help and unmark if they don't.

Hello Randy,

What error message did you get? You'd better code like this
Dim filterString As String = "(ProjectStatus like '" & filter(0) & ") And (ProjectStatus like '" & filter(1) & ") and (ProjectStatus like '" & filter(2) ")"
Me.ProjectBindingSource.Filter = filterString

Put a break point at first line of code, bedug your application to see if the filterString is what you want.

Please inform me the test result.

Sincerely,
Kira Qian

---

Please mark the replies as answers if they help and unmark if they don't.

Thanks for your help.

I put in the your code "Dim filterString As String = "(ProjectStatus like '" & filter(0) & ") And (ProjectStatus like '" & filter(1) & ") and (ProjectStatus like '" & filter(2) ")" and I got an "end of statement error", so I change it to this

Dim

filterString As String = "(ProjectStatus like '" & filter(0) & ") And (ProjectStatus like '" & filter(1) & ") and (ProjectStatus like '" & filter(2) & ")"

When I ran it I got this for filterstring:

filterString = "(ProjectStatus like 'Bid) And (ProjectStatus like 'Awarded) and (ProjectStatus like 'Not Awarded)"

Now I get this error on the 'Me.ProjectBindingSource.Filter = filterString' line

'Syntax error: Missing operand after 'Awarded' operator.'

any idea what can be causing this error?

Hello Randy,

I guess it should be
filterString = "(ProjectStatus like 'Bid' ) And (ProjectStatus like 'Awarded' ) and (ProjectStatus like 'Not Awarded' )"
So you have missed the last ' for a pair.

Please try to change a little as below.
filterString As String = "(ProjectStatus like '" & filter(0) & "' ) And (ProjectStatus like '" & filter(1) & "' ) and (ProjectStatus like '" & filter(2) & "' )"

Please tell me the result.

Sincerely,
Kira Qian

---

Please mark the replies as answers if they help and unmark if they don't.

I had already tried that and I don't get an error, but there are no content in my DGV. This is what the filterstring is:

filterString = "(ProjectStatus like 'Bid' ) And (ProjectStatus like 'Awarded' ) and (ProjectStatus like 'Not Awarded' )"

Hello,

It seems there is no record match the filter condition "(ProjectStatus like 'Bid' ) And (ProjectStatus like 'Awarded' ) and (ProjectStatus like 'Not Awarded' )", please try another condition, or you can find a special record from the datasource and make the filter condition accordingly. I think the logical is correct, the only problem is the data. Once you have enough data, you can test it.

Sincerely,
Kira Qian

---

Please mark the replies as answers if they help and unmark if they don't.

I do have records that contain each one of the filter criteria. If for example I use this

Me

.ProjectBindingSource.Filter = "ProjectStatus like '" & filter(0) & "%'"

The correct records are placed in the DGV.

Hello,

Sorry I forgot to say that "%" is necessary for the match string since you are using like in this case.

Please try the following string.
filterString As String = "(ProjectStatus like '%" & filter(0) & "%' ) And (ProjectStatus like '%" & filter(1) & "%' ) and (ProjectStatus like '%" & filter(2) & "%' )"

Sincerely,
Kira Qian

---

Please mark the replies as answers if they help and unmark if they don't.

I tried that earlier and I also tried with the '%' at the end of each search criterie and got the same result. No records in my datagridview.;

filterString = "(ProjectStatus like '%Bid%' ) And (ProjectStatus like '%Awarded%' ) and (ProjectStatus like '%Not Awarded%' )"

Any other Ideas?

Hello,

Do you have records in your datasource?

Sincerely,
Kira Qian

---

Please mark the replies as answers if they help and unmark if they don't.

I'm not sure what you me. All the records are contain in a table that is load when the form is called

Me

.ProjectTableAdapter.Fill(Me.BuildersEstimatorDatabaseDataSet.Project)

Hi,

Sorry may be my word confused you. What I mean is you can first bind the data queried from database to the DataGridView without filter. Do you see all data there? Then call the BindingSource.Filter to get the filtered rows. It works properly on my side, I hope you can find the problem soon.

Sincerely,
Kira Qian

---

Please mark the replies as answers if they help and unmark if they don't.

Thanks for your help. I think that might have been the problem, but I changed my options to only filter by one criteria at a time instead of multiple criterias.