Dropdown不会'；t采用SelectedValue

本文关键字：采用 SelectedValue 不会 Dropdown | 更新日期: 2023-09-27 18:22:25

我有一个奇怪的问题。我用这个代码填充下拉列表

   MySqlCommand cmdAreaPassive = new MySqlCommand();
    cmdAreaPassive.CommandText = "Select BolgeID, BolgeAdi, AktiPasif ";
    cmdAreaPassive.CommandText += "From tbl_bolgeler ";
    cmdAreaPassive.CommandText += "Where AktiPasif = 1 ";
    cmdAreaPassive.CommandText += "Order By BolgeAdi ASC ";
    cmdAreaPassive.Connection = con;
    MySqlDataAdapter drAreaPassive = new MySqlDataAdapter(cmdAreaPassive);
    DataSet dsAreaPassive = new DataSet();
    drAreaPassive.Fill(dsAreaPassive);
    ddlAreaDelete.DataSource = dsAreaPassive;
    ddlAreaDelete.DataTextField = "BolgeAdi";
    ddlAreaDelete.DataValueField = "BolgeID";
    ddlAreaDelete.DataBind();
    Response.Redirect(Request.RawUrl);

我试着用这个代码删除项目

        MySqlCommand cmdDelete = new MySqlCommand();
        cmdDelete.CommandText = "Update tbl_bolgeler ";
        cmdDelete.CommandText += "Set AktiPasif = @AktiPasif ";
        cmdDelete.CommandText += "Where BolgeID = @BolgeID ";
        cmdDelete.Connection = con;
        cmdDelete.Parameters.AddWithValue("@BolgeID", ddlAreaDelete.SelectedItem.Value);
        cmdDelete.Parameters.AddWithValue("@AktiPasif", "0");
        cmdDelete.ExecuteNonQuery();

在选择对象之前一切正常。它必须采用选定的值，但它采用选定的索引。我尝试了SelectedItem.Value和SelectedValue，但它们都不起作用。抱歉我英语不好，谢谢。

Dropdown不会'；t采用SelectedValue

我想，我解决了的问题

我的代码就像

  cmdDelete.Parameters.AddWithValue("@BolgeID", ddlAreaDelete.SelectedItem.Value);

我碰巧喜欢

        int selectedIndex = ddlAreaDelete.SelectedIndex;
        if (selectedIndex >= 0)
        {
         cmdDelete.Parameters.AddWithValue("@BolgeID",ddlAreaDelete.Items[selectedIndex].Value);
        }

但我仍然不知道

的原因是什么
相关文章：