title: ASP.NET Razor C# SQL Database Dropdown List
body: <p>I am hoping someone can help me.  I am sure this is quite simple, but I have spent many hours searching for the answer and nothing seems to be working.  I have a CSHTML file in Microsoft WebMatrix with Razor/C# code and HTML markup as well as a basic SQL table.  I would like to put a dropdown list which displays the results of a SQL query.  Below is my code.</p>
  
  <pre><code>@{
  
  var db = Database.Open("QualityMonitoring") ;
  var listAgent = "SELECT Agent FROM Data";
  
  }
  </code></pre>
  
  <p>How do I create a dropdown list to display the results in my markup?</p>
  
  <p>Any help would be greatly appreciated.</p>