title: MVC 3 traditional database or dataset to dropdownlist
body: <p>I have legacy code that I am slowly moving to C# MVC. How would I create a dropdownlist from a data table or dataset?  I do not want to create properties and loop through a list because I have too many ancient MS Access queries to deal with.</p>
  
  <p>CONTROLLER:</p>
  
  <pre><code> using (SqlConnection Connection = new SqlConnection(ConnectionString))
          {
              string commandstring = "select column1 from table1";
              SqlCommand command = new SqlCommand(commandstring, Connection);
              Connection.Open();
              SqlDataAdapter da = new SqlDataAdapter();
              DataSet ds = new DataSet();
              da.SelectCommand = command;
              da.Fill(ds, "data1");
              Connection.Close();
          }
  </code></pre>