c# DataTable Adding Data from Table
<p>I have a datatable being populated however one of the fields is a drop down list which is derived from a database connection. When I click add it always add the same data despite my selection and then removes the first item in the list.</p>

<p>ASPX Code</p>

<pre><code>&lt;asp:TableCell&gt;&lt;asp:DropDownList runat="server" ID="txtProduct"&gt;&lt;/asp:DropDownList&gt;&lt;/asp:TableCell&gt;
</code></pre>

<p>CS Code for Dropdown List</p>

<pre><code>public void Fill1()
{
    string connectionString = WebConfigurationManager.ConnectionStrings["CRM2Sage"].ConnectionString;
    using (SqlConnection _con = new SqlConnection(connectionString))
    using (SqlCommand cmd = new SqlCommand("SELECT * FROM Products", _con))
    {
        cmd.Connection.Open();

        SqlDataReader ddlValues;
        ddlValues = cmd.ExecuteReader();

        txtProduct.DataSource = ddlValues;
        txtProduct.DataValueField = "Description";
        txtProduct.DataTextField = "Description";
        txtProduct.DataBind();

        cmd.Connection.Close();
        cmd.Connection.Dispose();
    }
}
</code></pre>

<p>Any thoughts as to how to fix this?</p>
