filling multiple lists from single datareader

[keith55]

Im trying filling multiple dropdown lists from a single datareader, i tried using the following code but when it starts to fill category2 it says datareader closed.<BR><BR>'This bit populates the category selection list'<BR>dr = SQL.Reader("Get_All_Categories")<BR>Category1.DataSource = dr<BR>Category1.DataTextField = "Category"<BR>Category2.DataSource = dr<BR>Category2.DataTextField = "Category"<BR>Category3.DataSource = dr<BR>Category3.DataTextField = "Category" <BR>dr.Close()<BR>Page.DataBind() <BR><BR>Is there a way of using a single datareader to fill multiple dropdown lists?<BR><BR>Thanks<BR><BR>Kristian