Compare string values in VB.NET

Question

How can I compare two string values in VB.NET?

I've tried compare and equals functions, but it's not giving me the correct result. What I'm trying to compare is as follows. Also, is the code is correct?

Public Class Form1

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim con As New OleDb.OleDbConnection
        Dim ds As New DataSet
        Try
            con.ConnectionString = "Provider=SQLOLEDB;Data Source=HP-PC\SQLEXPRESS;Integrated Security=SSPI;Initial Catalog=dbname"
            con.Open()
        Catch
            MsgBox("Error in connection")
        End Try

        Dim da As OleDb.OleDbDataAdapter
        Dim sql As String

        sql = "select * from patientprofile"
        da = New OleDb.OleDbDataAdapter(sql, con)
        da.Fill(ds, "patientprofile")
        Dim dr As DataRow
        Dim i As Integer
        i = 0
        With ds.Tables("patientprofile")
            For Each dr In .Rows
                If String.Equals(.rows(i).Item("name"), TextBox1.Text) Then
                    textbox1.text = .rows(i).item("age")
                End If
                i = i + 1
            Next
        End With
    End Sub

End Class

Scott Arrington · Accepted Answer · 2013-03-14 15:10:20Z

5

why not

If .rows(i).Item("name").ToString() = TextBox1.Text Then
  'Other Stuff
End If

edited Mar 14, 2013 at 15:10

answered Nov 13, 2009 at 18:55

Scott Arrington

12.6k3 gold badges45 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Matthew Jones · Accepted Answer · 2009-11-13 18:53:26Z

2

Just to be absolutely sure, try this:

with ds.Tables("patientprofile")
         For Each dr In .Rows
             if String.Equals(.rows(i).Item("name").ToString(), TextBox1.Text) then
                   textbox1.text=.rows(i).item("age").ToString()
             End If
             i = i + 1
         Next
      end with

answered Nov 13, 2009 at 18:53

Matthew Jones

26.3k17 gold badges105 silver badges156 bronze badges

1 Comment

David Over a year ago

Yes. Without the ".ToString()" it's comparing the a db field to the Textbox1.Text,. A DB Field != a string.

DevByDefault · Accepted Answer · 2014-01-21 18:53:37Z

-2

Use this code:

If (String.Compare(.rows(i).Item("name").ToString(), TextBox1.Text) = 0) Then
   ' Do something
Else
  ' Do something else
End If

I have fixed the code now. Thanks @Moayad Mardini.

edited Jan 21, 2014 at 18:53

answered Nov 13, 2009 at 19:03

DevByDefault

66410 silver badges25 bronze badges

1 Comment

Moayad Mardini Over a year ago

This will do the "do Something Else" all the time.

Collectives™ on Stack Overflow

Compare string values in VB.NET

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related