display problem

[Zouve]

i was trying to display the data into an label but i fail, the label only display "FALSE", i dun know why. can somebody told me what wrong with my code? thanks

this is my code:

Dim myConnection As SqlConnection = New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\DayMenu.mdf;Integrated Security=True;User Instance=True")
Dim myCommand As SqlCommand = New SqlCommand("select resname, tmenu, price, date FROM menu where resname = 'sakura'", myConnection)

myConnection.Open()


Dim dr As SqlDataReader = myCommand.ExecuteReader()
If reslist.SelectedValue = ListItem.FromString("sakura").ToString Then
menulabel.Text = dr.Read
End If
myConnection.Close()

[Phil Weber]

If you look at the documentation of the DataReader's Read method (http://msdn2.microsoft.com/en-us/lib...ader.read.aspx ; also available by highlighting the word "Read" in your code and pressing F1), you'll see that it returns a Boolean. That's why you're getting the word "False" in your label.

For information on how to use a SqlDataReader, please see this tutorial: http://samples.gotdotnet.com/quickst...ldtreader.aspx