title: vb.net - select distinct not get the result wanted
body: <p>I used the following code to select unique values from the database</p>
  
  <pre><code>myCommand = New SqlCommand("SELECT DISCTINCT Visitor, BookCode FROM tblBook", myConnection)
   myAdapter = New SqlDataAdapter(myCommand)
   myAdapter.Fill(myDataSet, "tblBook")
   cboAuthor.DataSource = myDataSet.Tables(0)
   cboAuthor.DisplayMember = "Author"
   cboAuthor.ValueMember = "BookCode"
  </code></pre>
  
  <p>And it does not retrieve the unique values, it remains the same. But if I use only <code>SELECT DISTINCT Author FROM</code> tblBook it works fine.</p>
  
  <p>Please help.</p>