Error in like operator: the string pattern '%[%' is invalid

Question

0.00/5 (No votes)

See more:

i am trying to filter [ this character in Textbox but it says

error in like operator: the string pattern '%[%' is invalid.

i am unble to use [] this character

What I have tried:

Try

            bs.Filter = "TTITLE like '%" + txtTsearch.Text + "%'"
            DataGridView1.DataSource = bs

        Catch ex As Exception
            MessageBox.Show(ex.Message)
        End Try

Posted 6-Nov-21 10:53am

Member 14621280

Updated 14-Mar-23 4:19am

Add a Solution

Comments

RedDk 6-Nov-21 17:05pm

Formatting issues with this post have I. It's customary to capitalize leading characters in sentences. Let me start with that as a reason that noone is going to be able to judge whether the other appended code is grounded anywhere in reality as-is.

2 solutions

Add a Solution

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

OriginalGriff · Answer 1 · 2021-11-06T12:11:00

Solution 1

Look at your code.
How many 'T's does "Title" normally start with?

If your column is called "TTitle" then it's just odd. If it isn't ... that code won't work.

And '[' is a special character in filters: DataColumn.Expression Property (System.Data) | Microsoft Docs[^] - to enter one as a sting part, it needs to be doubled.

Posted 6-Nov-21 12:11pm

OriginalGriff

Comments

Member 14621280 6-Nov-21 21:40pm

TTITLE is the column only,

bs.Filter = "TTITLE like '%[ ]" + txtTsearch.Text + "%'"
DataGridView1.DataSource = bs

Shall I use above code?

Member 14621280 7-Nov-21 1:23am

but above code not working

OriginalGriff 7-Nov-21 2:18am

Did you read the whole of what I said, or just the first bit?

Member 14621280 7-Nov-21 7:06am

i am the beginner so couldn't understand what you are shared

OriginalGriff 7-Nov-21 7:35am

"And '[' is a special character in filters: DataColumn.Expression Property (System.Data) | Microsoft Docs[^] - to enter one as a sting part, it needs to be doubled."
What part of this is difficult for you to understand?

Member 15793732 13-Mar-23 7:02am

Hello, I had the same problem. Your code did not work as Member 14621280 mentioned.

Problem is its not enough to double [[. You need to close it from both sides. My working code:

Dim FoundR() As DataRow = Dts.Select("NodeFullPath Like '%[[]" & BsNr & "[]]%'")

Did you even tested your code? Its hard to understand when information is fault.

CHill60 14-Mar-23 12:53pm

"Did you even tested your code?" - the poster did not supply any code, they supplied a link to the Microsoft Documentation for the property.
Did you even read that documentation? It explictly states "If a bracket is in the clause, each bracket character should be enclosed in brackets (for example [[] or []]). "

Member 15793732 14-Mar-23 15:21pm

Yes I read documentation, otherwise I would not know the answer, because previous answer mentioned only: "it needs to be doubled" I would use [[ which is also wrong. If codeproject should be more than links to VS documentation, just let it here and somebody like me will appriciate it in future...

Member 15793732 · Answer 2 · 2023-03-14T04:19:00

Solution 3

If you want only single [, and use it as filter, you need to check if this character is present in string and add [ around every single bracket is used ], so final query will look like this:

bs.Filter = "TTITLE like '%[[]some text[]]%'"

This will filter text by:

[some text]

Posted 14-Mar-23 4:19am

Member 15793732

Comments

CHill60 14-Mar-23 12:48pm

Which was pointed out in Solution 1 back in 2021

Member 15793732 14-Mar-23 15:20pm

There is oly link to VS docu and nobody mentioned correct syntaxe for original question.
I did, but its way too deep in converstaion, this way - the forgetful self from the future - will find this much faster. Thank you top expert.

Error in like operator: the string pattern '%[%' is invalid

2 solutions

Solution 1

Solution 3

Add your solution here

Preview 0

Error in like operator: the string pattern '%[%' is invalid

2 solutions

Solution 1

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us