62,046
社区成员
发帖
与我相关
我的任务
分享
string rootTreeValue = this.TreeView1.SelectedValue;
string strSql = string.Format("SELECT id,name FROM DM WHERE fatherID = '{0}' ORDER BY itemorder", rootTreeValue);
SqlDataReader reader = SqlHelper.ExecuteReader(strConnectionString, CommandType.Text, strSql, null);
//建立子节点,遍历。
while(reader.Read())
{
TreeNode Node = new TreeNode();
Node.Value = reader["id"].ToString();
Node.Text = reader["name"].ToString();
Node.Target = "content";
Node.NavigateUrl = string.Format("content.aspx?id={0}", reader["id"].ToString());
TreeView1.SelectedNode.ChildNodes.Add(Node); //在选中节点下添加子节点
}
<asp:TreeView ID="TreeView1" runat="server"
onselectednodechanged="TreeView1_SelectedNodeChanged">
</asp:TreeView>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
getDataTable();
if (ViewState["Table"] != null)
{
DataTable dt = ViewState["Table"] as DataTable;
foreach (DataRow row in dt.Select("ParentID=0"))
{
TreeNode node = new TreeNode();
node.Value = row["ID"].ToString();
node.Text = row["Name"].ToString();
TreeView1.Nodes.Add(node);
}
}
}
}
public void getDataTable()
{
string[] name = { "一级菜单", "二级菜单", "三级菜单", "四级菜单" };
DataTable dt = new DataTable();
dt.Columns.Add("ID", Type.GetType("System.Int32"));
dt.Columns.Add("Name", Type.GetType("System.String"));
dt.Columns.Add("ParentID", Type.GetType("System.Int32"));
for (int i = 0; i < name.Length; i++)
{
DataRow row = dt.NewRow();
row[0] = i + 1;
row[1] = name[i];
row[2] = i;
dt.Rows.Add(row);
}
ViewState["Table"] = dt;
}
protected void TreeView1_SelectedNodeChanged(object sender, EventArgs e)
{
TreeNode node = TreeView1.SelectedNode;
DataTable dt = ViewState["Table"] as DataTable;
foreach (DataRow row in dt.Select("ParentID=" + node.Value + ""))
{
TreeNode n = new TreeNode();
n.Value = row["ID"].ToString();
n.Text = row["Name"].ToString();
n.Expand();
node.ChildNodes.Add(n);
}
}