vb.net compare string values

Question

How can i compare two string values in vb.net? i've tried compare, equals functions but it's not giving me the correct result. what i'm trying to compare is as follows. also let me know if the code is correct. i'm new to vb.net

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

Answer 1

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

Answer 2

why not

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

Answer 3

How about

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