分层数据的数据源控件的实现,使用treeview控件显示无限级分类
1.数据结构如下
![](https://www.cnblogs.com/images/cnblogs_com/clingingboy/ServerControl/ch24/ch1.jpg)
2.定义节点对象,实现IHierarchyData接口,此为重点实现,因为是分层结构,所以要重复在判断是否有子节点和MessageID和ParentID是否相等.当然具体情况具体分析了
3.定义节点对象集合,实现IHierarchicalEnumerable接口
4.定义视图,继承HierarchicalDataSourceView类
5.最后定义数据源控件,实现IHierarchicalDataSource接口
贴下代码
(1)
![](https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
public class SqlHierarchyData : IHierarchyData, ICustomTypeDescriptor
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
private DataRowView item;
private string dataParentIdField;
private string dataIdField;
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
public SqlHierarchyData(string dataParentIdField, string dataIdField, DataRowView item)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
this.item = item;
this.dataParentIdField = dataParentIdField;
this.dataIdField = dataIdField;
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
bool IHierarchyData.HasChildren
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
get
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
foreach (DataRowView row in item.DataView)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
object[] array1 = row.Row.ItemArray;
object[] array2 = item.Row.ItemArray;
string a = row[dataParentIdField].ToString();
string b = item[dataIdField].ToString();
HttpContext.Current.Response.Write(array1[2]+"-"+a + "--" +array2[2]+"-" +b + "<br>");
if (a == b)
return true;
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
return false;
}
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
object IHierarchyData.Item
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
get
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
return item;
}
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
public override string ToString()
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
return dataIdField;
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
string IHierarchyData.Path
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
get
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
string path = "/*[position()=1]";
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
GetPath(item, ref path);
return path;
}
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
void GetPath(DataRowView crow, ref string path)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
foreach (DataRowView row in item.DataView)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
string c, d;
c = crow.Row.ItemArray[2].ToString();
d = crow.Row.ItemArray[0].ToString();
string a = crow[dataParentIdField].ToString();
string b = row[dataIdField].ToString();
if (a == b)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
path = "/*[position()=1]" + path;
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
//GetPath(row, ref path);
//HttpContext.Current.Response.Write("begin<br>" + c + "--" + a + "--" + b + "<br>end<br>");
//HttpContext.Current.Response.Write(path + "<br>");
}
//HttpContext.Current.Response.Write(c + "--" + a + "--" +b + "<br>");
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
}
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
string IHierarchyData.Type
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{ return dataIdField; }
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
//获取子节点
IHierarchicalEnumerable IHierarchyData.GetChildren()
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
SqlHierarchicalEnumerable children = new SqlHierarchicalEnumerable();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
foreach (DataRowView row in item.DataView)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
string a = row[dataParentIdField].ToString();
string b = item[dataIdField].ToString();
if (a == b)
children.Add(new SqlHierarchyData(dataParentIdField, dataIdField, row));
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
return children;
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
//获取父节点
IHierarchyData IHierarchyData.GetParent()
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
foreach (DataRowView row in item.DataView)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
string a = item[dataParentIdField].ToString();
string b = row[dataIdField].ToString();
if (a == b)
return new SqlHierarchyData(dataParentIdField, dataIdField, row);
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
return null;
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
ICustomTypeDescriptor Members#region ICustomTypeDescriptor Members
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
System.ComponentModel.AttributeCollection ICustomTypeDescriptor.GetAttributes()
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
return TypeDescriptor.GetAttributes(this, true);
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
string ICustomTypeDescriptor.GetClassName()
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
return TypeDescriptor.GetClassName(this, true);
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
string ICustomTypeDescriptor.GetComponentName()
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
return TypeDescriptor.GetComponentName(this, true);
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
TypeConverter ICustomTypeDescriptor.GetConverter()
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
return TypeDescriptor.GetConverter(this, true);
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
EventDescriptor ICustomTypeDescriptor.GetDefaultEvent()
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
return TypeDescriptor.GetDefaultEvent(this, true);
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
PropertyDescriptor ICustomTypeDescriptor.GetDefaultProperty()
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
return TypeDescriptor.GetDefaultProperty(this, true);
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
object ICustomTypeDescriptor.GetEditor(Type editorBaseType)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
return TypeDescriptor.GetEditor(this, editorBaseType, true);
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
EventDescriptorCollection ICustomTypeDescriptor.GetEvents(Attribute[] attributes)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
return TypeDescriptor.GetEvents(this, attributes, true);
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
EventDescriptorCollection ICustomTypeDescriptor.GetEvents()
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
return TypeDescriptor.GetEvents(this, true);
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
PropertyDescriptorCollection ICustomTypeDescriptor.GetProperties(Attribute[] attributes)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
PropertyDescriptorCollection pds = TypeDescriptor.GetProperties(item);
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
if (pds.Count > 0)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
List<SqlHierarchyDataPropertyDescriptor> list = new List<SqlHierarchyDataPropertyDescriptor>();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
foreach (PropertyDescriptor pd in pds)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
list.Add(new SqlHierarchyDataPropertyDescriptor(pd.Name));
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
SqlHierarchyDataPropertyDescriptor[] arr = new SqlHierarchyDataPropertyDescriptor[list.Count];
list.CopyTo(arr);
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
return new PropertyDescriptorCollection(arr);
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
return PropertyDescriptorCollection.Empty;
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
PropertyDescriptorCollection ICustomTypeDescriptor.GetProperties()
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
return ((ICustomTypeDescriptor)this).GetProperties(null);
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
object ICustomTypeDescriptor.GetPropertyOwner(PropertyDescriptor pd)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
if (pd is SqlHierarchyDataPropertyDescriptor)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
return this;
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
return null;
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
#endregion
}
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
public class SqlHierarchyDataPropertyDescriptor : PropertyDescriptor
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
private string name;
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
public SqlHierarchyDataPropertyDescriptor(string name)
: base(name, null)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
this.name = name;
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
public override string Name
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{ return name; }
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
public override Type ComponentType
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
get
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
return typeof(SqlHierarchyData);
}
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
public override bool IsReadOnly
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
get
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
return true;
}
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
public override Type PropertyType
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
get
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
return Type.GetType("System.String");
}
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
public override bool CanResetValue(object o)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
return false;
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
public override object GetValue(object o)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
SqlHierarchyData shd = o as SqlHierarchyData;
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
if (shd != null)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
IHierarchyData hd = (IHierarchyData)shd;
string subject = ((DataRowView)(hd.Item))[name].ToString();
return subject;
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
return null;
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
public override void ResetValue(object o)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
throw new NotSupportedException();
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
public override void SetValue(object o, object value)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
throw new NotSupportedException();
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
public override bool ShouldSerializeValue(object o)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
return true;
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
public override TypeConverter Converter
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{ return TypeDescriptor.GetConverter(typeof(System.String)); }
}
}
(2)
public class SqlHierarchicalEnumerable : ArrayList, IHierarchicalEnumerable
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
IHierarchyData IHierarchicalEnumerable.GetHierarchyData(object enumeratedItem)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
return (SqlHierarchyData)enumeratedItem;
}
}
(3)
![](https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
public class SqlHierarchicalDataSourceView : HierarchicalDataSourceView
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
string viewPath;
CustomSqlDataSource owner;
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
public SqlHierarchicalDataSourceView(CustomSqlDataSource owner, string viewPath)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
this.viewPath = viewPath;
this.owner = owner;
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
public override IHierarchicalEnumerable Select()
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
DataView dv = (DataView)this.owner.Select(DataSourceSelectArguments.Empty);
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
SqlHierarchicalEnumerable data = new SqlHierarchicalEnumerable();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
bool hasParent = false;
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
foreach (DataRowView crow in dv)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
object[] array1 = crow.Row.ItemArray;
hasParent = false;
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
foreach (DataRowView prow in dv)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
object[] array2 = prow.Row.ItemArray;
//子节点
string a = crow[owner.DataParentIdField].ToString();
//根节点
string b = prow[owner.DataIdField].ToString();
if (a == b)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
hasParent = true;
break;
}
}
//添加根节点
if (!hasParent)
data.Add(new SqlHierarchyData(owner.DataParentIdField, owner.DataIdField, crow));
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
return data;
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
}
(4)
public class CustomSqlDataSource : SqlDataSource, IHierarchicalDataSource
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
{
private SqlHierarchicalDataSourceView view = null;
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
HierarchicalDataSourceView IHierarchicalDataSource.GetHierarchicalView(string viewPath)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
if (null == this.view)
this.view = new SqlHierarchicalDataSourceView(this, viewPath);
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
return this.view;
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
private static readonly object EventKey = new object();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
event EventHandler IHierarchicalDataSource.DataSourceChanged
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
add
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
Events.AddHandler(EventKey, value);
}
remove
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
Events.RemoveHandler(EventKey, value);
}
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
public string DataParentIdField
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{ return ViewState["DataParentIdField"] != null ? (string)ViewState["DataParentIdField"] : string.Empty; }
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
set
{ ViewState["DataParentIdField"] = value; }
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
public string DataIdField
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
{
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
get
{ return ViewState["DataIdField"] != null ? (string)ViewState["DataIdField"] : string.Empty; }
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
set
{ ViewState["DataIdField"] = value; }
}
}
使用
<asp:TreeView runat="Server" ID="tv" DataSourceID="MySource">
<DataBindings>
<asp:TreeNodeBinding DataMember="MessageID" TextField="Subject" ValueField="MessageID" />
</DataBindings>
</asp:TreeView>
<custom:CustomSqlDataSource
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="Select * From Messages"
DataIdField="MessageID" DataParentIdField="ParentID" ID="MySource"
runat="server">
</custom:CustomSqlDataSource>
效果