Advanceddatagridview filtering problem

Question

1.00/5 (1 vote)

See more:

I have AdvancedDatagridview and it has filter Icon at the header like this
the next Code Work With me fine when i Open Filter and choose some of data
But when I Use Select ALL Chosen i get this error

Here is Code

VB

<pre>    Private Sub AdvancedDataGridView1_FilterStringChanged(sender As Object, e As EventArgs) Handles AdvancedDataGridView1.FilterStringChanged

        Dim A, B As String
        A = AdvancedDataGridView1.FilterString
        B = A & " Or ItemName = 'total'"
        BindingSource1.Filter = B

and this is ERROR I GOT

Additional information: Syntax error: Missing operand before 'Or' operator.

What I have tried:

Please tell me what I have to DO

Posted 18-Jul-23 12:31pm

Ahmed Saif 2022

Updated 18-Jul-23 22:45pm

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Graeme_Grant · Answer 1 · 2023-07-18T13:11:00

Solution 1

This sis a 3rd-party control. You need to communicate with the author of the control. I did a quick search and here is where you can ask questions: Issues · davidegironi/advanceddatagridview · GitHub[^]

Posted 18-Jul-23 13:11pm

Graeme_Grant

Richard Deeming · Answer 2 · 2023-07-18T21:48:00

Solution 2

At a guess, the FilterString is empty. Try checking for that first:

VB.NET

Dim A As String = AdvancedDataGridView1.FilterString
Dim B As String = If(String.IsNullOrEmpty(A), "ItemName = 'total'", A & " Or ItemName = 'total'")
BindingSource1.Filter = B

Posted 18-Jul-23 21:48pm

Richard Deeming

Comments

Ahmed Saif 2022 20-Jul-23 15:05pm

WOOOW BRO it's work But i Changed it look
Dim A As String = AdvancedDataGridView1.FilterString
Dim B As String = If(String.IsNullOrEmpty(A), A, A & " Or ItemName = 'total'")
BindingSource1.Filter = B
THaaaank You Very Much

Andre Oosthuizen · Answer 3 · 2023-07-18T22:45:00

Solution 3

You are missing an apostrophe, your syntax requires apostrophes around the string values. If I am correct it should read -

Dim A, B As String
'Enclose the string from datagrid in apostrophe's - exploded view - " ' "...
        A = "'" & AdvancedDataGridView1.FilterString & "'"
        B = A & " Or ItemName = 'total'"
        BindingSource1.Filter = B

Posted 18-Jul-23 22:45pm

Andre Oosthuizen

Comments

Ahmed Saif 2022 20-Jul-23 15:08pm

Thank you bro