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 ...