using ..;
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
namespace WebApp
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif)
{
public partial class _Default : System.Web.UI.Page
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
TreeNode node;
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
protected void Page_Load(object sender, EventArgs e)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
BindTree();
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
private void BindTree()
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
string cmdText = "SELECT AreaID,Name FROM Area WHERE substring(AreaID,3,4)='0000'";
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
using (SqlDataReader dr = SqlHelper.ExcuteReader(ConfigurationManager.ConnectionStrings["SqlConn"].ConnectionString, cmdText, null))
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
while (dr.Read())
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
node = new TreeNode();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
node.Text = dr.GetString(1);
node.Value = dr.GetString(0);
node.NavigateUrl = "page.html?id=" + dr.GetString(0);
node.Target = "_blank";
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
TreeView1.Nodes.Add(node);
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
GetChilds(dr.GetString(0));
}
}
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
private void GetChilds(string parentid)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
string cmdText = "SELECT AreaID,Name FROM Area WHERE substring(AreaID,1,2)='" + parentid.Substring(0, 2) + "' AND substring(AreaID,5,2)='00'";
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
using (SqlDataReader dr = SqlHelper.ExcuteReader(ConfigurationManager.ConnectionStrings["SqlConn"].ConnectionString, cmdText, null))
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
while (dr.Read())
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
TreeNode cnode = new TreeNode();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
cnode.Text = dr.GetString(1);
cnode.NavigateUrl = "subpage.html?id="+dr.GetString(0);
cnode.Target = "_blank";
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
node.Expanded = false;
node.ChildNodes.Add(cnode);
}
}
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
protected void TreeView1_SelectedNodeChanged(object sender, EventArgs e)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
TreeView1.SelectedNode.Expanded = true;
}
}
}
posted @
2007-06-09 09:21
M'
阅读(
245)
评论()
编辑
收藏
举报