title: How I handle duplicated record in textbox.AutoCompleteCustomSource in VB.net
body: <p>I wrote a code for auto complete textbox in vb.net.</p>
  
  <p>I have textbox search for the company name in 'company_list' table.
  But some company have exactly same name, so when I input the name, it shows just 1 text.</p>
  
  <p>I'd like to make these two names when I input the textbox.
  Below is my code.</p>
  
  <pre><code>Dim sql as String = "SELECT * FROM company_info"
  cmd = New MySqlCommand(sql, con)
  
  con.Open()
  adapter = New MySqlDataAdapter(cmd)
  Dim dt As New DataTable
  adapter.Fill(dt)
  
  cName.AutoCompleteCustomSource.Clear()
  
  For Each r In dt.Rows
      cName.AutoCompleteCustomSource.Add(r.item(1).ToString)
  Next
  con.Close()
  </code></pre>
  
  <p>I have two same company name as below.</p>
  
  <p>[TKTech]
  [TKTech]</p>
  
  <p>These two are totally different company with same name, so I need to choice between them.</p>
  
  <p>When I input to textbox(cName), it just show 1 name for these company.</p>
  
  <p>Please let me know how I handle it.</p>
  
  <p>Thank you in advance.</p>
  
  <p>Frank</p>