Visual Basic

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim x As String


        Try
            If Trim(TextBox2.Text) <> "" Then
                x = TextBox2.Text.ToUpper

                SQL = "SELECT * FROM company_detail WHERE Comp_Name LIKE '" & x & "%'"
                ObjComm = New MySqlCommand(SQL, ObjMyConn)
                ObjMyConn.Open()
                ObjRead = ObjComm.ExecuteReader
                If ObjRead.Read Then
                    MessageBox.Show("I'm here")
                    ObjAdapter = New MySqlDataAdapter(SQL, ObjMyConn)
                    ObjAdapter.Fill(ds, "Client_Comp")
                    dt = ds.Tables("Client_Comp")
                    DataGridView1.DataSource = dt

                End If

            End If
            ObjMyConn.Close()
        Catch ex As Exception
            MsgBox("Error: " & ex.Source & ": " & ex.Message, MsgBoxStyle.OkOnly)
        End Try

    End Sub