下拉列表内容覆盖 [英] Dropdownlist Content Overwrite

问题描述

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();
        }

<asp:DropDownList ID="ddlTitle" runat="server" CssClass="csstextbox" >
                       <asp:ListItem>Mr.</asp:ListItem>
                       <asp:ListItem>Mrs.</asp:ListItem>
                       <asp:ListItem>Miss.</asp:ListItem>
                        <asp:ListItem>Dr.</asp:ListItem>
                   </asp:DropDownList>

if suppose  dr["Title"]=Dr.
then it is overwrite Mr. with Dr. and got result like.  | Dr.  |
                                           | Mrs. |
                                           | Miss.|
                                           | Dr.  |

我将View_User.aspx中的User_ID传递给Create_User.aspx，以便使用querystring..Id正确编辑用户目的..在Create_User.aspx中显示所有正确的字段..所有控件都正确获取了正确的数据，但是当我填充当前标题时用户，然后用dropdownlist的第一项覆盖它.(我对Dropdownlist唯一的问题是它被覆盖了)

i am passing User_ID from View_User.aspx to Create_User.aspx For edit user purpose using querystring..Id getting proper.. showing all correct fields in Create_User.aspx ....All control get correct data properly but when i populate title of current user then it overwrite with first item of dropdownlist.(I have only problem with Dropdownlist it is overwritten)

推荐答案

string s = dr["Title"].ToString(); 
ddlTitle.SelectedText = s;

您可以一行完成它，我只是这样做，以使其更易于阅读.如果字符串 s 不在列表中，则会抛出错误.

You can do it in one line, I just did it like that to make it easier to read. This will throw an error if the string s is not in the list.

使用选定的值

Use selected value

ddlTitle.SelectedValue = dr["Title"].ToString();

change this line also
<asp:dropdownlist id="ddlTitle" runat="server" cssclass="csstextbox" xmlns:asp="#unknown">
                  <asp:listitem text="Mr." value="Mr."></asp:listitem>
                  <asp:listitem text="Mrs." value="Mrs."></asp:listitem>
                  <asp:listitem text="Miss." value="Miss.">Miss.</asp:listitem>
                  <asp:listitem text="Dr." value="Dr.">Dr.</asp:listitem>
</asp:dropdownlist>

尝试一下，它应该可以工作....

try this, it should work....

ddlTitle.SelectedItem = dr["Title"].ToString();

这篇关于下拉列表内容覆盖的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！