how to update my dropdownlist by value?

Question

<asp:DropDownList ID="ddlWeekOffType" class="form-control" runat="server" AutoPostBack="true" OnSelectedIndexChanged="ddlWeekOffType_SelectedIndexChanged">
<asp:ListItem Text="-Select-" Value="0"></asp:ListItem>
<asp:ListItem Text="Constant" Value="C"></asp:ListItem>
<asp:ListItem Text="Variable" Value="V"></asp:ListItem>
<asp:ListItem Text="Constant Variable" Value="CV"></asp:ListItem>
</asp:DropDownList>

This is my dropdownlist ..Fact is i am store data value by help of Text property .Here i am selecting a text property is
Constant
like this .
obj.WeekOffType = Convert.ToString(ddlWeekOffType.SelectedItem.Value);

if (ddlWeekOffType.SelectedItem.Value == "C")
then insert data in sql is C .In storing data situation working good..

updating dropdownlist is fetch data from sql is perfectly. is retrieve is C is working fine.
obj.WeekOffType = Convert.ToString(dt.Rows[0]["WeekOffType"]);

but problem is that i can't retrieve Constant in dropdownlist.

ddlWeekOffType.Items.FindByValue(obj.WeekOffType.Trim().ToString()).Selected = true;

Any slove this issue so please ....

Answer 1

Hi @ibne ali ,
According to your description, I think you are getting Text instead of Value from database.
You can try FindByText instead of FindByValue.
You have provided less information, maybe you can provide full code that reproduces the problem.

obj.WeekOffType = Convert.ToString(dt.Rows[0]["WeekOffType"]);  
ddlWeekOffType.Items.FindByText(obj.WeekOffType.Trim().ToString()).Selected = true;  

Best regards,
Lan Huang

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.