how to update a selected item in a dropdownlist asp.net c#
<p>Hi I have a dropdown list and I want to update one item when I selecting it in dropdown list,I wrote this code but it only update the first item:</p>

<pre><code>        DBMethod db = new DBMethod();
        DataTable dt = new DataTable();
        string sqlcmd = "select * from dbo.Web_Personnel ";
        dt = db.ReturnTableWithData(sqlcmd);

        dt.Rows[0]["Job"] = txtjobE.Text;
        dt.Rows[0]["ChildNo"] = txtchildnoe.Text;
        dt.Rows[0]["Salary"] = txtsalary.Text;
        db.UpdateDatatable(dt, "dbo.Web_Personnel");
</code></pre>
