首页 > 数据库技术 > 详细

<asp:DropDownList数据库读取

时间:2016-04-22 12:01:20      阅读:340      评论:0      收藏:0      [点我收藏+]

.aspx

<asp:DropDownList ID="DropDownList1" runat="server"  DataValueField="infoID" DataTextField="Dtitle">
        <asp:ListItem>       </asp:ListItem>
     </asp:DropDownList>

 

.cs

 

读值

 if (!IsPostBack)
        {

 int id = Convert.ToInt32(Request.QueryString["infoID"]);
          
            DataAccess.Da dac = new DataAccess.Da();
            dac.con.Open();
            SqlCommand cmd = new SqlCommand("select * from table where Id = " + id + "");
            cmd.Connection = dac.con;
            SqlDataReader sdr = cmd.ExecuteReader();
            sdr.Read();
            txttitle.Text = sdr["Xtitle"].ToString();
            txtzhaiyao.Text = sdr["Abstract"].ToString();
            content1.Value = sdr["BContent"].ToString();

            DropDownList1.SelectedValue = sdr["Did"].ToString();

            getDataLei();

}

 

 

 

 

 public void getDataLei()
    {

        DataAccess.Da dac = new DataAccess.Da();
        string sql = "select * from Ency_info where Encytype=1";
        SqlCommand cmd = new SqlCommand(sql, dac.con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);
        this.DropDownList1.DataSource = ds.Tables[0].DefaultView;
        this.DropDownList1.DataBind();
    }

 

入库

        string strtype = this.DropDownList1.SelectedItem.ToString();
        string strbid = this.DropDownList1.SelectedItem.Value;

 

//selectedItem——指的是选中的dropdownlist中选项,为ListItem,只读不写

//selectedValue——指的是选中的dropdownlist中选项的值,为string, 只读不写
//selecteditem是选中的项,它包括value和text

 

<asp:DropDownList数据库读取

原文:http://www.cnblogs.com/huichao1314/p/5420643.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!