SQLDataReader + TreeView 使用方法

 
SQLDataReader + TreeView 使用方法
 

   WebForm5.aspx
 
   <asp:TreeView ID="TreeView1" runat="server"
   ExpandDepth="0" EnableViewState="false" />
 

 

   WebForm5.aspx.cs
 
   using System;
   using System.Web.UI.WebControls;
   using System.Data.SqlClient;
   using System.Text;
 
   namespace WebApplication9
   {
      public partial class WebForm5 : System.Web.UI.Page
      {
         protected void Page_Load(object sender, EventArgs e)
         {
            CreateLeague();
            CreateTeam();
            CreatePlayer();
         }
 
         private void CreateLeague()
         {
            String connectionString = "Data Source=.\\SqlExpress; Initial Catalog=Soccer; Integrated Security=SSPI";
            SqlConnection con1 = new SqlConnection(connectionString);
            con1.Open();
 
            StringBuilder sb = new StringBuilder();
            sb.Append("SELECT * FROM League ;");
 
            SqlCommand cmd1 = new SqlCommand(sb.ToString(), con1);
            SqlDataReader dr = cmd1.ExecuteReader();
 
            if (dr.HasRows)
            {
               while (dr.Read())
               {
                  TreeView1.Nodes.Add(new TreeNode(dr[1].ToString(), dr[0].ToString()));
               }
            }
 
            con1.Close();
            con1.Dispose();
         }
 
         private void CreateTeam()
         {
            String connectionString = "Data Source=.\\SqlExpress; Initial Catalog=Soccer; Integrated Security=SSPI";
            SqlConnection con1 = new SqlConnection(connectionString);
            con1.Open();
 
            StringBuilder sb = new StringBuilder();
            sb.Append("SELECT * FROM Team ;");
 
            SqlCommand cmd1 = new SqlCommand(sb.ToString(), con1);
            SqlDataReader dr = cmd1.ExecuteReader();
 
            if (dr.HasRows)
            {
               while (dr.Read())
               {
                  foreach (TreeNode item in TreeView1.Nodes)
                  {
                     if(item.Value.ToString() == dr[2].ToString()){
                        item.ChildNodes.Add(new TreeNode(dr[1].ToString(), dr[0].ToString()));
                     }
                  }
               }
            }
 
            con1.Close();
            con1.Dispose();
         }
 
         private void CreatePlayer()
         {
            String connectionString = "Data Source=.\\SqlExpress; Initial Catalog=Soccer; Integrated Security=SSPI";
            SqlConnection con1 = new SqlConnection(connectionString);
            con1.Open();
 
            StringBuilder sb = new StringBuilder();
            sb.Append("SELECT * FROM Player ;");
 
            SqlCommand cmd1 = new SqlCommand(sb.ToString(), con1);
            SqlDataReader dr = cmd1.ExecuteReader();
 
            if (dr.HasRows)
            {
               while (dr.Read())
               {
                  foreach (TreeNode item in TreeView1.Nodes)
                  {
                     foreach (TreeNode Citem in item.ChildNodes)
                     {
                        if(Citem.Value.ToString() == dr[2].ToString()){
                           Citem.ChildNodes.Add(new TreeNode(dr[1].ToString(), dr[0].ToString()));
                        }
                     }
                  }
               }
            }
 
            con1.Close();
            con1.Dispose();
         }
      }
   }