TreeView加载省市数据

来源：互联网发布：mac战网无法打开编辑：程序博客网时间：2024/06/05 12:49

using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.SqlClient;using System.Xml;namespace 省市县加载到TreeView{    public partial class AreaFrm : Form    {        public AreaFrm()        {            InitializeComponent();        }        private void AreaFrm_Load(object sender, EventArgs e)        {        }        private void btnLoadData_Click(object sender, EventArgs e)        {            int pid = 0;            //1.读取TblArea中的数据            LoadAreaInfo(pid, treeViewArea.Nodes);        }        /// <summary>        /// 加载TblArea中的数据        /// </summary>        /// <param name="pid"></param>        /// <param name="treeNodeCollection"></param>        private void LoadAreaInfo(int pid, TreeNodeCollection treeNodeCollection)        {            //1.先执行查询,查询所有TblArea等于pid的            string sql = "select * from TblArea where AreaPid =@AreaPid";            SqlParameter ps = new SqlParameter("@AreaPid", pid);            DataTable dt = SqlHelper.SqlHelper.ExecuteTable(sql, CommandType.Text, ps);            //2.将dt中的数据绑定到TreeNodeCollection上            foreach (DataRow item in dt.Rows)            {                TreeNode tNode = treeNodeCollection.Add(item[1].ToString());                tNode.Tag = item[0];                //3.读取某省下面的所有城市，然后将这些数据加载到省节点上                LoadAreaInfo((int)item[0], tNode.Nodes);            }        }        }}

源代码和数据库下载：
http://download.csdn.net/detail/gongchao1212/9080183

0 0