Comparing data reader value to text control string

[jwilso]

I am positive this piece of code was working the other day and can't figure out why it isn't finding values to be equal.

cmd.CommandText = "SELECT * FROM Collection WHERE CollectionType = '" & Me.Cmb_CollectionType.Text & "'"
cmd.Connection = SqlConnection1
SqlConnection1.Open()
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection)

While dr.Read
For x As Integer = 1 To 15
If dr.Item(x).ToString = Me.Txt_Attribute.Text.TrimEnd(" ") Then

Thanks in advance,

-JW

 

[tperri]

Looks right. Try converting your comparision strings ToLower() as well so that different capitalizations don't return false.

because "Cat" and "cat" are not equal, etc.

Just a thought

 

[jwilso]

I tried ToLower and trimed the end of both strings and they still evaluate false. Any other ideas?

-JW

 

[tperri]

Did you use the Immediate Window and look at the values of dr.Item(x).ToString() and Me.Txt_Attrive.Text.TrimEnd(" ")

put a breakpoint on you if statement then look and see what they are.