title: Drop down list display 0
body: <p><a href="https://i.stack.imgur.com/qb0gI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qb0gI.png" alt=""></a></p>
  
  <pre><code> strsql = "Select Sup_Name + '-----'  + Sup_Code As Supdisplay , Sup_Code From kjm_supplier_profile Order By Sup_Name  "
   cmd = New MySqlCommand(strsql, Conn)
   rdr = cmd.ExecuteReader
   strddl.DataSource = rdr
   strddl.DataTextField = "Supdisplay"
   strddl.DataValueField = "Sup_Code"
   strddl.DataBind()
  
   strddl.Items.Insert(0, New ListItem("Please Select Supplier", ""))
  
   rdr.Close()
  </code></pre>
  
  <p>This is to bind the data to the drop-down list with two data. But the drop-down list display 0</p>