title: Populate text box with value from MySql in VB.net
body: <p>I am trying to display the values of a field in the MySql database, but everything I've tried ends up not populating the text box. Below is code I wrote off of some examples I found. Could someone please point me in the right direction?</p>
  
  <pre><code>    Dim sqlStripCmd As New MySqlCommand("ore_price_population", Mysqlconn)
  
      sqlStripCmd.CommandType = CommandType.StoredProcedure
      Dim sdrstripcmd As MySqlDataReader = sqlStripCmd.ExecuteReader()
  
  
      Dim getDetailsDA = New MySqlDataAdapter
      Dim getDetailsDS As New DataSet
      getDetailsDA.SelectCommand = sqlStripCmd
      getDetailsDA.Fill(getDetailsDS, "getDetails")
      Veldspar_Isk.Text = getDetailsDS.Tables("Ore_Ice_Prices").Rows(0).Item("Veldspar").ToString()
  </code></pre>
  
  <p>SQL Query</p>
  
  <pre><code>    DELIMITER $$
  
      USE `YHI`$$
  
      DROP PROCEDURE IF EXISTS `ore_price_population`$$
  
      CREATE DEFINER=`YHI`@`%` PROCEDURE `ore_price_population`()
      BEGIN
  
      SELECT `Veldspar`
      FROM
      `YHI`.`Ore_Ice_Prices`;
      END$$
  
      DELIMITER ;
  </code></pre>