<div>
<div class="content wysiwyg-content">
Hi there, 
 
I am having a problem with populating a dropdownlist. The code is as follows : 
 
 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; myConnection = New SqlConnection (&quot;server=slserver;uid=;pwd=;database=meta_dev&quot;) 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SQL$ = &quot;&quot; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SQL$ = SQL$ &amp;&nbsp;&quot; select &nbsp; &nbsp; &nbsp;glpd_key &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SQL$ = SQL$ &amp;&nbsp;&quot; from &nbsp; &nbsp; &nbsp; &nbsp;gl_period &nbsp; &quot; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; myConnection.Open() 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; myCommand = New SqlCommand(SQL$, myConnection) 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; myDataReader = myCommand.ExecuteReader() 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Me.ddl_glperiod.DataSource = myDataReader 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Me.ddl_glperiod.DataBind() 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'close connection to item_map_gl 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; myConnection.Close() 
 
&nbsp; &nbsp; &nbsp; &nbsp; ddl_glperiod.SelectedIndex = 15 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
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 .... 
 
Thanks
</div>
</div>

Hi there, 

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   "
            myConnection.Open()
            myCommand = New SqlCommand(SQL$, myConnection)
            myDataReader = myCommand.ExecuteReader()
            Me.ddl_glperiod.DataSource = myDataReader
            Me.ddl_glperiod.DataBind()
            'close connection to item_map_gl
            myConnection.Close()

        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 ....

Thanks

populate dropdownlist with datareader

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.