























前台:
<%@ Master Language="C#" AutoEventWireup="true" CodeFile="MasterPage.master.cs" Inherits="Master_MasterPage" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title></title>
<link href="../App_Themes/myTheme/Basic.css" rel="stylesheet" type="text/css" />
</head>
<body style="margin:0">
<form id="form1" runat="server">
<div>
<table style="width:100%;height:100%;border-collapse:collapse;border-color:#44a938" border="1""">
<tr><td style="height:50px; font-size:15px" colspan="2" align="center">God is a girl!</td></tr>
<tr>
<td style="width: 160px" valign="top">
<asp:TreeView ID="TreeLeft" runat="server" ShowLines="True" OnSelectedNodeChanged="TreeLeft_SelectedNodeChanged" >
</asp:TreeView>
Parent:<asp:DropDownList ID="ddlParentID" runat="server" Width="90px"></asp:DropDownList><br />
Text: <asp:TextBox ID="txtNodeName" runat="server" Width="85px"></asp:TextBox><br />
<asp:Button ID="btnSubmit" runat="server" Text="Submit" OnClick="btnSubmit_Click" />
<asp:Button ID="btnDelete" runat="server" Text="Delete" OnClick="btnDelete_Click" />
</td>
<td valign="top" >
<asp:ContentPlaceHolder ID="ContentPlaceHolder1" runat="server">
</asp:ContentPlaceHolder>
</td>
</tr></table>
</div>
</form>
</body>
</html>
后台:
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;
using System.Data.SqlClient;public partial class Master_MasterPage : System.Web.UI.MasterPage
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
TreeleftBind();
bindGroup();
}
}
#region 绑定树
private void TreeleftBind()
{
this.TreeLeft.Nodes.Clear();
DataTable dt = master.Getdt();
DataView dv = new DataView(dt);
dv.RowFilter = "TreeParentID = 0";
TreeNode node = new TreeNode();
foreach (DataRowView drv in dv)
{
node.Text = drv["TreeName"].ToString();
node.Value = drv["ID"].ToString();
node.Expanded = true;
this.TreeLeft.Nodes.Add(node);
AddReplies(dt, node);
}
}
private void AddReplies(DataTable dt, TreeNode node)
{
DataView dv
= new DataView(dt);}
#endregion#region 绑定DropDownList类:
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;/// <summary>
/// Summary description for master
/// </summary>
public class master
{
public master()
{
//
// TODO: Add constructor logic here
//
}/// <summary>
/// 删除节点
/// </summary>
/// <param name="datakey"></param>
public static void DeleteRecords(string datakey)
{
string strDelete = String.Format("DELETE FROM [AutoTree] where ID = {0}", datakey);
GetDB.cmdExecute(strDelete);
}/// <summary>
/// 返回DataTable
/// </summary>
/// <returns></returns>
public static DataTable Getdt()
{
SqlConnection cn = GetDB.GetConnect();
string strSQL = "select * from AutoTree";
SqlDataAdapter da = new SqlDataAdapter(strSQL, cn);
DataTable dt = new DataTable();
da.Fill(dt);
return dt;
}/// <summary>
/// 为Tree添加新节点
/// </summary>
/// <param name="tblName"></param>
/// <param name="_TreeName"></param>
/// <param name="_TreeParentID"></param>
/// <param name="txtName"></param>
/// <param name="rootID"></param>
public static void InsertNode(string tblName, string _TreeName, string _TreeParentID, string txtName,string rootID)
{
using (SqlConnection Conn = GetDB.GetConnect())
{
SqlCommand cmd = new SqlCommand(String.Format("insert into {0} ({1},{2}) values (@TreeName,@TreeParentID)",tblName,_TreeName,_TreeParentID), Conn);
cmd.Parameters.Add("@TreeName", SqlDbType.NVarChar, 50).Value = txtName;
cmd.Parameters.Add("@TreeParentID", SqlDbType.NVarChar, 50).Value = rootID;
Conn.Open();
cmd.ExecuteNonQuery();
Conn.Close();
}
}
}
图:
此内容由惯性聚合(RSS阅读器)自动聚合整理,仅供阅读参考。 原文来自 — 版权归原作者所有。