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