asked on
Help with partial string search
I am using the code below to select rows in a Grid where values of SDeactivation is found agains SDéactivation_ID which is in Coumn(2). SDeactivation_ID contains single values.
When SDeactivation is a single value all is working of but when SDeactivation includes multiple values (i.e. 1,2,3) it does not work. How do i modify the code to select rows when using multiple values for SDeactivation?
MsgBox("keySDeactivation)"
' keySDeactivation = "1,2" does not works
' keySDeactivation = "1" works
If keySDeactivation <> "" Then
Dim _tableA As DataView = dtMasterA.DefaultView
C1SDeactivation.DataSource
For i As Integer = 0 To C1SDeactivation.RowCount - 1
If C1SDeactivation.Columns(2)
C1SDeactivation.SelectedRo
End If
Next
End If
Thanks,
Victor
When SDeactivation is a single value all is working of but when SDeactivation includes multiple values (i.e. 1,2,3) it does not work. How do i modify the code to select rows when using multiple values for SDeactivation?
MsgBox("keySDeactivation)"
' keySDeactivation = "1,2" does not works
' keySDeactivation = "1" works
If keySDeactivation <> "" Then
Dim _tableA As DataView = dtMasterA.DefaultView
C1SDeactivation.DataSource
For i As Integer = 0 To C1SDeactivation.RowCount - 1
If C1SDeactivation.Columns(2)
C1SDeactivation.SelectedRo
End If
Next
End If
Thanks,
Victor
Microsoft Access.NET ProgrammingVisual Basic.NETSQL
Last Comment
Nasir Razzaq
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
You could use regular expressions:
Imports System.Text.RegularExpressions
...
If Regex.IsMatch(C1SDeactivation.Columns(2).CellValue(i).ToString(), "\b" + keySDeactivation + "\b") Then
C1SDeactivation.SelectedRows.Add(i)
End If
...
ASKER
Thank You for all the comments. This thread was the solution.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
You are sure you wont have numbers greater than 9 in there?
ASKER
Yes, that is ok, those are just values of the ID fields I will use to select the rows.
Thanks.
Victor
Thanks.
Victor
And you will never have an ID greater than 9(such as 10, 11 etc). The reason I ask is that using the contains method as you are, 1 will match if there is 11 but no 1. So if you are trying to select just 11, both 1 and 11 will get selected.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Outside loop:
keySDeactivation = "," & keySDeactivation & ","
Inside Loop:
If keySDeactivation.Contains(