title: Get rid of duplicate items in ComboBox from a BLOB database
body: <p>I am getting duplicate items in a combobox that displays saved BLOBs in my database.</p>
  
  <pre><code>Private Sub refreshBLOBList()
      Dim getBLOBListCommand As New SqlCommand( _
          "SELECT DISTINCT FileName FROM DocumentStorage", dbConnection)
      Dim reader As SqlDataReader
  
      getBLOBListCommand.Connection.Open()
      reader = getBLOBListCommand.ExecuteReader
      While reader.Read
          BLOBList.Items.Add(reader(0))
      End While
  
      reader.Close()
      getBLOBListCommand.Connection.Close()
  
      BLOBList.SelectedIndex = 0
  End Sub
  </code></pre>
  
  <p>In this block I refresh the combobox, but DISTINCT doesn't get rid of the dupes in the combobox. The weird thing is, when I query it and put it in a datagridview I get the dataset I want.</p>
  
  <p>Any suggestions?</p>