populate data to dropdowlist

[susie]

I have following code to populate a downdownlist
dynamically:
Dim myCmd As SqlCommand = New SqlCommand("SELECT LName,
FName FROM Manager", con)

Dim myReader As SqlDataReader = myCmd.ExecuteReader()


dropdown1.DataSource = myReader
dropdown1.DataValueField = "LName"
dropdown1.DataBind()


How can I populate dropdown1 with both FName and LName?
I tried
dropdown1.DataValueField = "LName"&" "&"FName"

It does not work.

Please help.

Thank you!

 

[seamad]

I have the same problem, pls let me know the solution

 

[Guest]

change your SQL statement to "SELECT LName+FName Name FROM
Manager" and change the code to
dropdown1.DataValueField = "Name"
Good luck!