Perhaps the code would shed some light on what i am trying to do:
// Bind Marketing Results to Drop down list
// Create Instance of Connection and Command Object
SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
SqlCommand cmdListMarketing_results = new SqlCommand("proc_list_marketing_results",myConnection);
// Mark the Command as a SPROC
cmdListMarketing_results.CommandType = CommandType.StoredProcedure;
// Open connections and perform exec
myConnection.Open();
SqlDataReader myMarketing_results_reader = cmdListMarketing_results.ExecuteReader();
// Configure drop down list
listMarketing_results.DataSource = myMarketing_results_reader;
listMarketing_results.DataValueField = "sport_id";
listMarketing_results.DataTextField = "sport_name";
listMarketing_results.DataBind();
listMarketing_results.Items.Insert(0, "-----------------------"

;
listMarketing_results.Items.Insert(0, "Select Option"

;
// Bind Sports to drop down box
SqlCommand cmdListSports = new SqlCommand("proc_list_sports", myConnection);
// Mark the Command as a SPROC
cmdListSports.CommandType = CommandType.StoredProcedure;
// Open connections and perform exec
SqlDataReader mySports_reader = cmdListSports.ExecuteReader();
// Configure drop down list
listSports.DataSource = mySports_reader;
listSports.DataValueField = "sport_id";
listSports.DataTextField = "sport_name";
listSports.DataBind();
listSports.Items.Insert(0, "-----------------------"

;
listSports.Items.Insert(0, "Select Sport"

;
---------------------------end of code
so what i am trying to achieve is get the 2 datareaders (myMarketing_report_reader and mySports_reader) to share the same connection. When i try and do this i get an error saying that there is already a datareader (myMarketing_report_reader) that is using the connection and this must be closed first. However, when i close the marketing reader the data is lost in the dropdownlist....
Do i need to use two seperate connections, or is there away of keeping the data in the dropdownlist and closing the datareader.
James