Dropdownlist populates w/ System.Data.Common.DbDataRecord 1

[bubberz]

I've got a dropdownlist populated via the following:

Con1.Open()
Dim sqlGrp As String
sqlGrp = "SELECT GC+' - '+GD as Expr2, GC, GD, DivC FROM [RLDivG] WHERE DivC= " & "'" & ddlDivision.SelectedValue.ToString() & "'"

Dim myRDR As OleDbDataReader
Dim cmdGrp As New OleDbCommand(sqlGrp, Con1)
ddlGroup2.DataSource = cmdGrp.ExecuteReader(CommandBehavior.CloseConnection)
ddlGroup2.DataBind()
Con1.Close()

I know it's reading the correct records, but the dropdownlist shows "System.Data.Common.DbDataRecord" for each record

 

[checkai]

you need to set the Text and value of the drop down list...

ddlGroup2.DataValueField = "GC"
ddlGroup2.DataTextField = "GD"

"...we both know I'm training to become a cagefighter...see what happens if you try 'n hit me..."

 

[bubberz]

Thanks checkai!