界面展示如下:
<asp:TreeView ID="TreeView1" runat="server" ImageSet="Faq" ShowLines="True">
<HoverNodeStyle Font-Underline="True" ForeColor="Purple" />
<NodeStyle Font-Names="Tahoma" Font-Size="8pt" ForeColor="DarkBlue"
HorizontalPadding="5px" NodeSpacing="0px" VerticalPadding="0px" />
<ParentNodeStyle Font-Bold="False" />
<SelectedNodeStyle Font-Underline="True" HorizontalPadding="0px"
VerticalPadding="0px" />
</asp:TreeView>
后台操作如下:
namespace TreeView绑定数据
{
public partial class Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
InsertNode();
}
public void InsertNode()
{
Class1 cl = new Class1();
DataTable dt = cl.ext_Table();
SearchNode(TreeView1.Nodes,dt,"0");
}
public void SearchNode(TreeNodeCollection nodes, DataTable ds, string parentid)
{
string pnodekey;
pnodekey = string.Format("parentid={0}", parentid);
DataRow[] drs = ds.Select(pnodekey);
TreeNode node;
foreach (DataRow dr in drs)
{
node = new TreeNode();
node.Text = (string)dr["Name"];
node.Value = dr["id"].ToString();
nodes.Add(node);
SearchNode(node.ChildNodes,ds, node.Value);
}
}
}
}
Class1类展示如下:
public class Class1
{
//在"配置文件"中读起连接字符串
public string ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
public DataTable ext_Table()
{
OleDbConnection myConnection = new OleDbConnection(ConnectionString);
myConnection.Open();
OleDbCommand selectCommand = new OleDbCommand("select * from C_Word", myConnection);
OleDbDataAdapter da = new OleDbDataAdapter(selectCommand);
DataSet ds = new DataSet();
da.Fill(ds);
myConnection.Close();
return ds.Tables[0];
}
}