Insert values into the table depending on the selected dropdown value
<p>I have a form in which I have a ComboBox control with two values.</p>

<p>Once the user selects one item in the list, I need to display a table of data corresponding to the option selected.</p>

<pre><code>if (DropDownList1.SelectedValue == 1) 
{ 
    // open a SqlCommand
    // read values 
    // fill table
}
else if (DropDownList1.SelectedValue == 2)     
{ 
     // etc
</code></pre>

<p>The problem is that I only want to fill the table <em>after</em> the user makes a selection.  But when the form is loaded the ComboBox automatically chooses the first option and my code runs, filling the table.</p>

<p>How do I prevent this from happening?</p>
