web/left.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;
using System.Data.SqlClient;
using US.DBUtility;

public partial class left : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["iGId"] != null)
        {


            string id = Session["iGId"].ToString();
            SqlDataReader dr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, "select txt_PurviewList from Groups where i_GId='" + id + "'", null);
            dr.Read();
            string p = dr.GetValue(0).ToString();
            string[] pug = p.Split(',');
            TreeNode a = new TreeNode("五爱人才招聘网");
            for (int i = 0; i < pug.Length; i++)
            {
                dr = SQLHelper.ExecuteReader(SQLHelper.ConnectionStringLocalTransaction, CommandType.Text, "select vc_PWName,vc_LinkUrl from Purview where i_PUWId='" + pug[i] + "'", null);
                dr.Read();
                string vc_PWName = dr.GetValue(0).ToString();
                string vc_LinkUrl = dr.GetValue(1).ToString();
                TreeNode tn = new TreeNode();
                tn.Text = vc_PWName;
                tn.NavigateUrl = vc_LinkUrl;
                tn.Target = "right";
                a.ChildNodes.Add(tn);
            }
            TreeView1.Nodes.Add(a);

        }

    }
}