ASPxTreeList控件常见示例：以代码方式添加新的节点-控件新闻-慧都网

ASPxTreeList控件常见示例：以代码方式添加新的节点

原创|其它|编辑：郝浩|2012-11-06 11:54:41.000|阅读 1760 次

概述：本示例主要展示如何通过代码方式添加新的节点。在本示例中ASPxTreeList控件被绑定到SQL数据库。

本示例主要展示如何通过代码方式添加新的节点。在本示例中ASPxTreeList控件被绑定到SQL数据库。

using System.Data.SqlClient;

protected void Button1_Click(object sender, EventArgs e) {
SqlConnection conn = new SqlConnection();
conn.ConnectionString= "Data Source=(local);Initial Catalog=TestDb;Integrated Security=True";
conn.Open();
int id = GenerateId();
int parentId = 0;

if (ASPxTreeList1.FocusedNode != null)
parentId = (int)ASPxTreeList1.FocusedNode["ID"];

string textCmd = string.Format("INSERT INTO [Table1] ([ID], [ParentID], [Name]) VALUES ({0},
{1}, '{2}')", id, parentId, ASPxTextBox1.Text);
SqlCommand cmd = new SqlCommand(textCmd, conn);
cmd.ExecuteNonQuery();
conn.Close();
ASPxTreeList1.DataBind();
}

Asp

<dxwtl:ASPxTreeList ID="ASPxTreeList1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" KeyFieldName="ID"
ParentFieldName="ParentID" Width="307px">
<Columns>
<dxwtl:TreeListTextColumn FieldName="Name" VisibleIndex="0">
</dxwtl:TreeListTextColumn>
<dxwtl:TreeListSpinEditColumn FieldName="ID" VisibleIndex="1" Visible="False">
<PropertiesSpinEdit DisplayFormatString="g" NumberFormat="Custom">
</PropertiesSpinEdit>
</dxwtl:TreeListSpinEditColumn>
<dxwtl:TreeListSpinEditColumn FieldName="ParentID" VisibleIndex="1" Visible="False">
<PropertiesSpinEdit DisplayFormatString="g" NumberFormat="Custom">
</PropertiesSpinEdit>
</dxwtl:TreeListSpinEditColumn>
</Columns>
<SettingsBehavior AllowFocusedNode="True" />
</dxwtl:ASPxTreeList>

运行代码，结果如下：