select
ABU01 AS [编码] --编码
,ABU02 AS [名称] --名称
,ABBRP AS [拼音] --中文拼音缩写
,ABBRW AS [五笔] --中文五笔缩写
,ABU01A AS [上级编码] --上级编码
from
ABU1
父子层次关系通过 [上级编码]与[编码]确定
则
//获取数据集
DataView dvData = SqlHelper.ExecuteDataset(Pars.ConnStr, CommandType.Text, @"select ABU01 AS [编码],ABU02 AS [名称],ABBRP AS [拼音],ABBRW AS [五笔],ABU01A AS [上级编码] from ABU1").Tables[0].DefaultView;
//设置TreeList的父子关系
treeList1.KeyFieldName = "编码";
treeList1.ParentFieldName = "上级编码";
//绑定数据源
treeList1.DataSource = dvData;
treeList1.ForceInitialize();
即可