title: Refresh drop down list
body: <p>I have a drop down list that is populated based on the selected value of another drop down list.  The main drop down list is dlJobName.  It contains the list of all active jobs.  The second drop down list is dlStage.  This contains the distinct stage values related to the JobName.  Here is the query that populates the dlStage drop down list.</p>
  
  <pre><code>SELECT DISTINCT [AnnotationDate] as Annotation_Date FROM [vw_GridviewSource] WHERE ([Name] = @Name)
  </code></pre>
  
  <p>In this code the AnnotationDate is not a date field but a text field.  @Name is a variable equal to the selected value from the dlJobName list.</p>
  
  <p>Here is my dilemma.  When I make a selected_index_change event for the dlJobName, before I update the gridview that uses both of these drop down lists, I need to update the dlStage to only available values.  What is happening is the dlStage list is not updated and the values in the drop down list is not available for the new JobName.  Is there a way to force the query to run on the dlStage drop down list in conjunction with the selected index change event?  This would cause the gridview to at least populate and not error out.</p>
  
  <p>I can provide whatever additional code is necessary.</p>