title: select from Mysql and put into variable VB.NET
body: <p>I have a problem with the following piece of code:</p>
  
  <pre><code>dim nama as string    
  cnn.ConnectionString = "Server=localhost; user id=root; password=; database=aplikasi_store_testing;"
          cmd.Connection = cnn
          cnn.Open()
          cmd.CommandText = "SELECT ID_Barang, Nama_Barang from data_barang WHERE ID_Barang= '" &amp; txtIDBarangInput.Text &amp; "';"
  </code></pre>
  
  <p>Afterwards, I would need to change the data from "Nama_Barang" to nama.
  Could anyone help me with this? In advance, thank you very much for your precious help!</p>