title: Select from mysql put into variable VB.NET
body: <p>I am trying to Select data from MySQL database using VB.NET</p>
  
  <pre><code>Dim conn As New MySqlConnection
      Dim cmd As New MySqlCommand
      conn.ConnectionString = "Server=localhost; user id=root; password=; database=aplikasi_store_testing;"
      cmd.Connection = conn
      conn.Open()
  
      Dim Number As Integer
      cmd.CommandText = "SELCECT nama_student  FROM student where Id_student ='" &amp; id &amp; "'" 
  </code></pre>
  
  <p>but i dont know how to put selected query into variable, 
  anybody can help me ? </p>