DropDownList content overwrite
<pre><code> strSQL = "SELECT * FROM User_Reg WHERE User_ID='" + UserId + "'";
           DataTable dataTablerepeaterUserList = null;
           dataTablerepeaterUserList =objSqlDbComm.ExecuteDatasetQuery(strSQL).Tables[0];


foreach (DataRow dr in dataTablerepeaterUserList.Rows)
{   
   ddlTitle.SelectedItem.Text = dr["Title"].ToString();
}


 &lt;asp:DropDownList ID="ddlTitle" runat="server" CssClass="csstextbox" &gt;
      &lt;asp:ListItem&gt;Mr.&lt;/asp:ListItem&gt;
      &lt;asp:ListItem&gt;Mrs.&lt;/asp:ListItem&gt;
      &lt;asp:ListItem&gt;Miss.&lt;/asp:ListItem&gt;
     &lt;asp:ListItem&gt;Dr.&lt;/asp:ListItem&gt;
 &lt;/asp:DropDownList&gt;
</code></pre>

<p>If, suppose,  dr["Title"]=Dr.  Then it is overwrite Mr. with Dr. and got result like:  </p>

<pre><code>| Dr.  |
| Mrs. |
| Miss.|
| Dr.  |
</code></pre>

<p>I am passing User_ID from <code>View_User.aspx</code> to <code>Create_User.aspx</code> for edit user purpose using querystring.  Id getting proper, showing all correct fields in <code>Create_User.aspx</code>.  All controls get correct data properly. But when I populate title of current user then it overwrite with first item of <code>DropDownList</code>.  (I have only problem with <code>DropDownList</code> it is overwritten).</p>
