下拉列表的一点小知识

最新推荐文章于 2021-11-28 14:13:29 发布

z155096552

最新推荐文章于 2021-11-28 14:13:29 发布

阅读量133

点赞数

分类专栏： .net 文章标签： cmd object 数据库 class

本文链接：https://blog.csdn.net/z155096552/article/details/3599567

版权

.net 专栏收录该内容

31 篇文章 0 订阅

订阅专栏

要想获取下拉列表选择数据数据库表中的ID的话，一定要ddlView.Items.Add(new ListItem("--请选择景点--", ""));

一定要给他设为两个ADD方法加载，才能ddlCity.Items.Add(new ListItem(dr["ViewsName"].ToString(), dr["ViewsId"].ToString()));
也只有这样才能实现SqlCommand cmd = new SqlCommand("select * from views where Parent_id = " + Convert.ToInt32(ddlCity.SelectedValue), conn);保证Convert.ToInt32(ddlCity.SelectedValue它获取的是选取的数据的ID！

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!this.IsPostBack)
        {

            this.BindDropDownList1();
            SqlConnection conn = DataBase.ReturnConn();
            SqlCommand cmd = new SqlCommand("select * from views where Parent_id = 1", conn);
            SqlDataReader dr = cmd.ExecuteReader();
            ddlCity.Items.Add(new ListItem("--请选择城市--", ""));
            ddlView.Items.Add(new ListItem("--请选择景点--", ""));
            while (dr.Read())
            {
                ddlCity.Items.Add(new ListItem(dr["ViewsName"].ToString(), dr["ViewsId"].ToString()));
            }
            dr.Close();
            conn.Close();

        }

    }
    public void BindDropDownList1()
    {
        SqlConnection conn = DataBase.ReturnConn();
        SqlCommand cmd = new SqlCommand("select * from guidInfo where InfoNameKind_id = 0", conn);
        SqlDataReader dr = cmd.ExecuteReader();
        DropDownList1.Items.Add(new ListItem("--请选择所要去的地点--", ""));
        while (dr.Read())
        {
            DropDownList1.Items.Add(new ListItem(Convert.ToString(dr["InfoName"]),dr["Id"].ToString()));

        }
        dr.Close();
        conn.Close();
    }

    protected void ddlCity_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (ddlCity.SelectedValue != "")
        {

            SqlConnection conn = DataBase.ReturnConn();
            SqlCommand cmd = new SqlCommand("select * from views where Parent_id = " + Convert.ToInt32(ddlCity.SelectedValue), conn);
            SqlDataReader dr = cmd.ExecuteReader();
            ddlView.Items.Clear();
            while (dr.Read())
            {
                ddlView.Items.Add(new ListItem(dr["ViewsName"].ToString(), dr["ViewsId"].ToString()));
            }

            dr.Close();
            conn.Close();

}
}

    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        if (this.DropDownList1.SelectedValue != "")
        {
            SqlConnection con = DataBase.ReturnConn();
            SqlCommand cmd = new SqlCommand("select InfoName from guidInfo where InfoNameKind = "+DropDownList1.SelectedValue, con);
            SqlDataReader dr = cmd.ExecuteReader();

            while (dr.Read())
            {
                this.LabelShowGuid.Text = dr["InfoName"].ToString();
            }
            dr.Close();
            con.Close();
        }


    }
}