how can I show concatenated string into autocomplete textbox

See more:

VB

auto-complete

Dear Experts

I am trying to show concatenated string into autocomplete textbox
when user start typing it will search by last name. query will look into database for full name contains ... and in autosuggestion it will show full name, company

.
if I just search by last_name
and put last_name MyCollection.Add(reader("last_name").ToString())

It shows result
however following code shows nothing

here is my code

can anyone please suggest me how to resolve this ?

Dim strauto As String

       Dim name As String
       name = Trim(txtCompanyKeyContacts.Text)
       If name = "" Then Exit Sub
       Dim cnString As String = ConfigurationManager.ConnectionStrings("dbcon").ConnectionString
       Dim con As New SqlConnection(cnString)

       Using con
           strauto = "SELECT (FULL_NAME + ',' + Company + ',' + Status) as contact  FROM name where FULL_NAME like '%" & Replace(name, "'", "''") & "%' "
           'SELECT last_name,FULL_NAME + ',' + Company + ',' + Status as contact FROM name"
           con.Open()
           Dim cmd As New SqlCommand(strauto, con)

           Dim reader As SqlDataReader = cmd.ExecuteReader()
           Dim MyCollection As New AutoCompleteStringCollection()

           If reader.HasRows = True Then
               While reader.Read()


                   ' MyCollection.Add(reader("FULL_NAME + ',' + Company + ',' + Status").ToString())
                   MyCollection.Add(reader("contact").ToString())
               End While
           End If

          

           txtCompanyKeyContacts.AutoCompleteCustomSource = MyCollection
           con.Close()
       End Using