前台,aspx页面，只需要一个dropdownlist,textbox,butt代码,Asp.Net代码库,德仔网

代码语言

代码分类

【Asp.Net】前台,aspx页面，只需要一个dropdownlist,textbox,butt

作者:Dezai.CN / 发布于2013/2/28/ 845

前台,aspx页面，只需要一个dropdownlist,textbox,button控件


	前台,aspx页面，只需要一个dropdownlist,textbox,button控件

	<body>
	 <form id="form1" runat="server">
	 <asp:DropDownList ID="DropDownList1" runat="server">
	 </asp:DropDownList>&nbsp;
	 <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
	 <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="添 加" />
	 </form>
	</body>

	后台页面代码aspx.cs

	代码

	using System;
	using System.Data;
	using System.Configuration;
	using System.Collections;
	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;

	public partial class Default2 : System.Web.UI.Page
	{
	 cx c = new cx();
	 protected void Page_Load(object sender, EventArgs e)
	 {
	 if (!Page.IsPostBack)
	 {
	 BindDropdownList();//页面加载
	 }

	
	 }
	 protected void BindDropdownList()//绑定dropdownlist实现商品类型无限级分类
	 {
	 DataTable dt = new DataTable();
	 try
	 {
	 string sql = "select * from TB_Class1";
	 dt = c.getdataSet(sql, "s").Tables[0];
	 CreateLevelDropDown(this.DropDownList1, dt);
	 }
	 catch (Exception) { }

	 }
	 /// <summary>
	 /// 创建分级下拉框
	 /// </summary>
	 /// <param name="ddlst"></param>
	 /// <param name="dt"></param>
	 private void CreateLevelDropDown(DropDownList ddlst, DataTable dt)
	 {
	 System.Collections.ArrayList allItems = new ArrayList();
	 DataRow[] rows = dt.Select("[parent_id]=" + 0);
	 foreach (DataRow row in rows)
	 CreateLevelDropDownAssistant(dt, ref allItems, row, string.Empty);

	 ListItem[] items = new ListItem[allItems.Count];
	 allItems.CopyTo(items);
	 ddlst.Items.AddRange(items);
	 }
	 private void CreateLevelDropDownAssistant(DataTable dt, ref ArrayList items, DataRow parentRow, string curHeader)
	 {
	 ListItem newItem = new ListItem(curHeader + parentRow["class_name"].ToString(), parentRow["class_id"].ToString());
	 items.Add(newItem);
	 parentRow.Delete();

	 DataRow[] rows = dt.Select("[parent_id]='" + newItem.Value + "'");
	 for (int i = 0; i < rows.Length - 1; i++)
	 CreateLevelDropDownAssistant(dt, ref items, rows[i], curHeader.Replace("┣", "┃").Replace("┗", "┣") + "┣");

	 if (rows.Length > 0)
	 CreateLevelDropDownAssistant(dt, ref items, rows[rows.Length - 1], curHeader.Replace("┣", "┃").Replace("┗", "┣") + "┗");
	 }


	 protected void Button1_Click(object sender, EventArgs e)//添加分类
	 {
	 int id = Convert.ToInt32(this.DropDownList1.SelectedValue);
	 string sql = "";

	 if (id == 1)//表示是根目录
	 {
	 sql = "insert into TB_Class1 (parent_id,class_name) values ('" + id + "','" + this.TextBox1.Text + "')";
	 c.ExeSql(sql);
	 Response.Write("<script>alert('跟栏目添加成功！')</script>");
	 }
	 else//在根栏目下添加子栏目
	 {
	 sql = "insert into TB_Class1 (parent_id,class_name) values ('" + id + "','" + this.TextBox1.Text + "')";
	 c.ExeSql(sql);
	 Response.Write("<script>alert('子栏目添加成功！')</script>");
	 }
	 this.DropDownList1.Items.Clear();//清空dropdownlist
	 BindDropdownList();//重新加载，添加数据完全显示
	
	 }

	}

评论列表

本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。

试试其它关键字

　dropdownlist　

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)