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(); } } } |