populate dropdownlist with datareader
Posted on 2006-06-29
I am having a problem with populating a dropdownlist. The code is as follows :
myConnection = New SqlConnection ("server=slserver;uid=;pwd=;database=meta_dev")
SQL$ = ""
SQL$ = SQL$ & " select glpd_key "
SQL$ = SQL$ & " from gl_period "
myCommand = New SqlCommand(SQL$, myConnection)
myDataReader = myCommand.ExecuteReader()
Me.ddl_glperiod.DataSource = myDataReader
'close connection to item_map_gl
ddl_glperiod.SelectedIndex = 15
When the page load - it populates the dropdownlist with System.Data.Com.... If i debug the code, there is no errors.
Can someone help please ....