在使用Dev的treelist的过程中遇到了一个糟心的事,绑定好数据源,设置完KeyFieldName和ParentFieldName
DataTable dtPublictree = pADOHelper.GetDataTable("SELECT * from " + CommonClass.tableTreePublic + " where c_appid = '" + strAppID + "'order by i_order asc,c_name desc");//order by c_code
treeList1.DataSource = dtPublictree;
treeList1.KeyFieldName = "i_id";
treeList1.ParentFieldName = "i_pid";
但是!死活显示不了层级
百度到心累,终于在一篇博客里找到了线索:TreeList不显示分级列表---Dev踩坑记
改完字段类型
alter table pt_webapps_tree_public_t alter COLUMN i_pid type int8 using i_pid::int8 ;
完美显示:
失之毫厘差之千里,仅仅是int8和int4的区别,结果造成这么个问题。谨记!!