- A+
所属分类:ASP.NET
dropdownlist 绑定数据
- <asp:DropDownList runat="server"ID="ddlArea" Width="120px" >
- <asp:Listitem value="0">选择性别</asp:Listitem>
- <asp:Listitem value="1">男</asp:Listitem>
- <asp:Listitem value="2">女</asp:Listitem>
- </asp:DropDownList>
动态绑定:(每次绑定都要清除一下原来的记录,例:ddlArea.Items.Clear();)
- SqlConnectionconn = new SqlConnection("server=.;uid=sa;database=pubs");
- SqlDataAdapter dap = new SqlDataAdapter("select * from job", conn);
- DataTable dt = new DataTable();
- dap.Fill(dt);
- DropDownList1.Items.Clear();
- DropDownList1.DataSource = dt;
- DropDownList1.DataTextField = "job_desc";
- DropDownList1.DataValueField = "job_id";
- DropDownList1.DataBind();
- DropDownList1.Items.Insert(0, new ListItem("选择", "绑定数据"));
- SqlConnection conn = newSqlConnection("server=.;uid=sa;database=pubs");
- SqlDataAdapter dap = new SqlDataAdapter("select * from job", conn);
- DataTable dt = new DataTable();
- dap.Fill(dt);
- if (dt.Rows.Count != 0)
- {
- DropDownList1.Items.Clear();
- for (int i = 0; i < dt.Rows.Count; i++)
- {
- DropDownList1.Items.Add(new ListItem(
- dt.Rows[i]["显示值"].ToString(),
- dt.Rows[i]["usbkey"].ToString()));
- }
- DropDownList1.Items.Insert(0, "选择");
- DropDownList1.Items[0].Value = "0"; 或
- // DropDownList1.Items.Insert(0, new ListItem("选择数据","绑定数据"));
- }
- else
- {
- DropDownList1.Items.Insert(0, "无记录");
- DropDownList1.Items[0].Value = "0";
- }
好久没用了记录下,借鉴链接:https://blog.csdn.net/admindong/article/details/52529105