title: Populate DropDownList from database column, use DropDownList values to populate a table?
body: <p>I just started working with ASP.NET and Visual Studio 2008.  I want to create something fairly straightforward, yet I don't know how to approach it yet.</p>
  
  <p>I have access to an Oracle table that I'd like to leverage to create a report interface.  For simplicity's sake, let's assume that this table only has three columns:</p>
  
  <ol>
  <li>REPORT_DATE</li>
  <li>SUCCESSES</li>
  <li>FAILURES</li>
  </ol>
  
  <p>Now, the proposed ASP.NET interface will only have two components:</p>
  
  <ol>
  <li>DropDownList</li>
  <li>GridView (or table, whichever is simpler)</li>
  </ol>
  
  <p>The DropDownList will allow the user to select a date (e.g. 11/8/2012).  The GridView will then populate based on the user selection.  It will display all columns except "REPORT_DATE".  In this hypothetical scenario, the GridView will display "SUCCESSES" and "FAILURES". Essentially, it would follow this SQL statement:</p>
  
  <pre><code>SELECT * FROM MyTable WHERE REPORT_DATE=insertSelectedReportDateHere;
  </code></pre>
  
  <p>So far, I have successfully populated the DropDownList with REPORT_DATE using Visual Studio's GUI to connect to my database and table.  However, I'm unsure how to implement the population of the GridView based on my selection.  I assume this will require hard-coding AJAX, but I wasn't sure how powerful Visual Studio's GUI was.  </p>
  
  <p>Is there a way to do this using the GUI?  Or do I have to do it programmatically?  Any suggestions or resources that I should reference?</p>
  
  <p>Thank you!</p>