Author: webguy2000 | Posted on: 8/13/2009 9:09:27 AM | Views : 434

 I am trying to populate a series of dropdown menus from a single stored procedure.  My procedure looks like this:
Select * from ethnicity order by ID; Select * from audience order by ID; Select * from ageRange order by ID; Select * from gender order by ID;
The first dropdown is read correctly but the second and subsequent selects begin on the second row!  How do I position my reader back to the first row? 

Here is my VB code:

            '*** Salutation field ***
            DBReader = dbCommand.ExecuteReader()

            sal.DataSource = DBReader
            sal.DataTextField = "text"
       &nb ...

Go to the complete details ...