title: how to check if there is a value in mysql row?
body: <p>sorry for my english</p>
  
  <p>i want to ask how to check if there is a value in the row or not ?</p>
  
  <p>thanks in advance :)</p>
  
  <pre><code>Private Sub uploadpic()
  
      Dim SQLCmd As New MySqlCommand("SELECT Picture FROM Student_information WHERE S_I_D = ('" &amp; ListView1.Items(ListView1.FocusedItem.Index).SubItems(0).Text &amp; "') ", dbcon)
  
      dbcon.Open()
  
      *Dim pictureData As Byte() = DirectCast(SQLCmd.ExecuteScalar(), Byte())*
  
      dbcon.Close()
  
      Dim picture As Image = Nothing
  
      'Create a stream in memory containing the bytes that comprise the image.
  
      Using stream As New IO.MemoryStream(pictureData)
          'Read the stream and create an Image object from the data.
          PictureBox4.Image = Image.FromStream(stream)
      End Using
  
  
  End Sub
  </code></pre>