这句语句应该怎么写？

Question

 tableCId Name Department  branch
1 111 部门1          分公司1
2 222 部门3          分公司3
3 333 部门1          分公司1
4 33 部门1           分公司1
5 78 部门2           分公司1
6 99 部门3           分公司3
<asp:TreeView ID="TreeView1" runat="server" onclick="client_OnTreeNodeChecked(event)">
            <DataBindings>
                <asp:TreeNodeBinding TextField="根(分公司)" />
                <asp:TreeNodeBinding TextField="父1(部门)" />
                <asp:TreeNodeBinding TextField="父2(员工)(Name)" />
            </DataBindings>
            <Nodes>
                <asp:TreeNode ShowCheckBox="True" Text="根" Value="节点">
                    <asp:TreeNode ShowCheckBox="True" Text="父1" Value="父1">
                        <asp:TreeNode ShowCheckBox="True" Text="父2" Value="父2">
                            <asp:TreeNode ShowCheckBox="True" Text="子" Value="子"></asp:TreeNode>
                            <asp:TreeNode ShowCheckBox="True" Text="子2" Value="子2"></asp:TreeNode>
                            <asp:TreeNode ShowCheckBox="True" Text="子3" Value="子3"></asp:TreeNode>
                        </asp:TreeNode>
                    </asp:TreeNode>
                </asp:TreeNode>
            </Nodes>
        </asp:TreeView>请问用数据库如何绑定到这个treeview上？Treeview中的TextField应该如何写？

Answer 1

前台
<asp:TreeView ID="TreeView1" runat="server"
                Font-Size="9pt" OnSelectedNodeChanged="TreeView1_SelectedNodeChanged" 
                OnTreeNodeExpanded="TreeView1_TreeNodeExpanded" 
                CollapseImageUrl="../images/kai.jpg" ExpandImageUrl="../images/he.jpg" 
                NoExpandImageUrl="../images/wen.jpg" style="margin-right: 0px" 
                ForeColor="Black">
                <NodeStyle HorizontalPadding="5px" VerticalPadding="5px" />
            </asp:TreeView>
TreeView1.Nodes.Clear();
                    TreeNode nodeRoot = new TreeNode("全部", strRootID);
                    nodeRoot.NavigateUrl = "javascript:OnTreeNodeClick('" + m_strClass + "','" + strRootID + "');";
                    TreeView1.Nodes.Add(nodeRoot);
                    AddChildNode(nodeRoot, dt, nClassCharCount, nLength);
                    nodeRoot.Expand();