How To Add Datareader Results To A Label

hi,

i have this code it gets the records from db

i need to add the results of the datareader to a label but label control does not have a datasource property

second problem is how to comma separate the results.with array? or what please help

i need to show the results like this: record1,record2,record3Dim Conn As New SqlConnection(ConfigurationManager.ConnectionStrings("Conn").ConnectionString)

Dim strSQL As StringDim dr As SqlDataReader

Dim userID As Integer = Session("cmmLogonUserID")

strSQL = "select id,extension from musicExt"Dim cmd As New SqlCommand()cmd = New SqlCommand(strSQL, Conn)

Conn.Open()

dr = cmd.ExecuteReader()

 

'txtMediaFormats.Text = dr ???????

' ddlGenres.DataBind() ????????

Conn.Close()