Populating a dropdownlist with a specific value plus an array of values from an sql query
<p>I am new to the wonderful world of dropdownlists and I know this is going to be difficult for me to explain but I will try the best I can. </p>

<p>Here is my data:</p>

<pre class="lang-none prettyprint-override"><code> **Type**   **ID**  **Status**
  Letter      1         A
  Letter      2         B
  Letter      3         C
  Letter      4         D
  Letter      5         E
</code></pre>

<p>From my query result I return the ID of "3" and my Drop Down List displays a "C". I have accomplished this piece already :). My question is, how can I populate the dropdownlist with the Statuses? My DDL will display a "C" and when it the arrow is clicked, the rest of the Status values will be displayed.</p>

<p>Is this something that can be done with the sql query? Do I have to create a separate method?  If someone could point me in the right direction or provide some helpful code that would be awesome! Here is my code:</p>

<pre><code>SqlDataAdapter adapter = new SqlDataAdapter("SELECT Status FROM dbo.database WHERE ID = @ID AND Type = 'Letter'", mySqlConnection1);
adapter.SelectCommand.Parameters.Add("@ID", SqlDbType.Char).Value = lblID.Text;
adapter.Fill(test);

ddlStatus.DataSource = test;
ddlStatus.DataTextField = "Status";
ddlStatus.DataValueField = Status";
ddlStatus.DataBind();
</code></pre>
