asp.net - 在数据绑定(bind)到 sql 数据源后需要更改下拉列表

Question

好的，我已经将我的下拉列表数据绑定(bind)到一个 sql 数据源，现在我需要在显示之前更改一些字段中的数据。我整个早上都在弄乱这个，我找不到任何有用的东西，这是我到目前为止所得到的，但显然没有用......

Protected Sub ddlBookType_DataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles ddlBookType.DataBound
    'ddlBookType.Items.Insert(0, "Any")
    Dim i As Integer
    For i = 0 To ddlBookType.Items.Count - 1
        If ddlBookType.Items(i).Attributes.Equals("mod_cook") Then
            ddlBookType.Items(i).Text.Replace("mod_cook", "Modern Cooking")
        End If
    Next
    End Sub

Answer 1

嘿，我刚刚用 C# 完成并将其转换为 VB(我希望它是正确的)。

代码如下(

Protected Sub ddlBookType_DataBound(sender As Object, e As EventArgs)
    Dim ddlBookType As DropDownList = DirectCast(sender, DropDownList)
    For Each item As ListItem In ddlBookType.Items
        If item.Text = "mod_cook" Then
            item.Text = "Modern Cooking"
        End If
    Next
End Sub

这是原始的 C# 代码

protected void ddlBookType_DataBound(object sender, EventArgs e)
{
    DropDownList ddlBookType = (DropDownList)sender;
    foreach (ListItem item in ddlBookType.Items)
    {
        if (item.Text == "mod_cook")
        {
            item.Text = "Modern Cooking";
        }
    }
}