Insert based on dropdownlist value
<p>Well, based on dropdown value I need the values in my form to be inserted into the Database table.. But it is not working now..</p>

<p>This is my aspx page-</p>

<pre><code>&lt;asp:DropDownList ID="DropDownList1" class="box" runat="server" AutoPostBack="True"&gt;
        &lt;asp:ListItem&gt;Confirm Order&lt;/asp:ListItem&gt;
        &lt;asp:ListItem&gt;Tentative Order&lt;/asp:ListItem&gt;
    &lt;/asp:DropDownList&gt;
</code></pre>

<p>And then I used switch..</p>

<pre><code>switch (DropDownList1.SelectedValue) 
{ 
    case "Confirm Order": 
        ... INSERT 
    break; 
    case "Tentative Order": 
        ...Insert 
    break;
}
</code></pre>

<p>But its giving an error- </p>

<p><code>No mapping exists from object type System.Web.UI.WebControls.ListItem to a known managed provider native type.</code></p>

<p>What is the right way of doing it? </p>
