title: The multi-part identifier “System.Data.DataRowView” could not be bound." SQL SERVER + VB.NET
body: <p>Hi I am making a small database using sql server as the back and vb as the front end, I have nearly made it work however I have stumbled across this error.</p>
  
  <p>My code is provided below would really appreciate some help.</p>
  
  <pre><code>Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged
          Dim cmd As New SqlCommand
          conn = New SqlConnection(connectionstring)
          conn.Open()
          cmd = New SqlCommand("select tarif from tarif_sewa where kode_tarif = " &amp; ComboBox1.Text &amp; "", conn)
          TextBox2.Text = cmd.ExecuteScalar
          conn.Close()
  
      End Sub
  End Class
  </code></pre>