Issue getting information from database into variable
<p>ok, so i have got a dropdownlist, which contains a number from a database(the amount of seats taken). If the rest of the dropdownboxes change(the flight arrival/departure), the dropdown box with the seats taken box changes to the correct piece of data associated with that flight
I am trying to store the seats taken into a variable, however, the number which is stored is the number from the previous value that was in the dropdown box and not the updated value</p>

<p>Is there a way i can get the new updated number into the variable?</p>

<p>Sorry for not being clear  :/</p>

<pre><code>    int flightsTaken;
    string departure, arrival;

    departure = Convert.ToString(DropDownListDepartures.Text);
    arrival = Convert.ToString(DropDownListArrivals.Text);

    //Sets up how many flights are availabe for each departure place
    if (departure == "London (Ltn)")
        flightsAvailable = 12;
    else if (departure == "Edinburgh")
        flightsAvailable = 3;
    else if (departure == "Manchester")
        flightsAvailable = 6;


    flightsTaken = Convert.ToInt32(DropDownList2.Text);  //THIS GETS THE PREVIOUS NUMBER NOT THE CURRENT NUMBER
    flightsAvailable -= flightsTaken;
</code></pre>
