数据表:
CREATE TABLE CateTable (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[CateName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[RootID] [int] NOT NULL ,
[ParentID] [int] NOT NULL
)
GO
存储过程:
CREATE PROCEDURE CateTable_GetList AS
BEGIN
Select CateID, CateName, RootID, ParentID From CateTable Order By CateID,RootID,ParentID
END
代码:
private
void
MainForm_Load(
object
sender, EventArgs e)
... {
//从数据库中读取数据
SqlConnection con = new SqlConnection(ConnString.ConStr);
SqlCommand cmd = new SqlCommand("CateTable_GetList", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
try
...{
sda.Fill(ds);
}
catch
...{
}
finally
...{
cmd = null;
con.Close();
}
//往TreeView中添加树节点
//添加根节点
TreeNode tn = new TreeNode();
tn.Text = "种类";
tn.Name = "0";//Name作为ID
tn.Tag = "0";//Tag作为RootID
tn.ImageIndex = 0;
tn.SelectedImageIndex = 0;
tv.Nodes.Add(tn);//该TreeView命名为tv
tv.SelectedNode = tv.TopNode;
//把其他节点加上去
if (ds != null)
...{
foreach (DataRow dr in ds.Tables[0].Rows)
...{
tn = new TreeNode();
tn.Text = dr["CateName"].ToString();
tn.Name = dr["CateID"].ToString();//Name作为CateID
tn.Tag = dr["RootID"].ToString();//Tag作为RootID
tn.ImageIndex = 1;
tn.SelectedImageIndex = 1;
//判断是否为主节点
if (dr["CateID"].ToString() == dr["RootID"].ToString())
...{
//主节点
tv.SelectedNode = tv.TopNode;
}
else
...{
//其他节点
if (tv.SelectedNode.Name != dr["ParentID"].ToString())
...{
TreeNode[] tn_temp = tv.Nodes.Find(dr["ParentID"].ToString(), true);
if (tn_temp.Length > 0)
...{
tv.SelectedNode = tn_temp[0];
}
}
}
tv.SelectedNode.Nodes.Add(tn);
}
tv.ExpandAll();//展开TreeView
tv.SelectedNode = tv.TopNode;
}
}
... {
//从数据库中读取数据
SqlConnection con = new SqlConnection(ConnString.ConStr);
SqlCommand cmd = new SqlCommand("CateTable_GetList", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
try
...{
sda.Fill(ds);
}
catch
...{
}
finally
...{
cmd = null;
con.Close();
}
//往TreeView中添加树节点
//添加根节点
TreeNode tn = new TreeNode();
tn.Text = "种类";
tn.Name = "0";//Name作为ID
tn.Tag = "0";//Tag作为RootID
tn.ImageIndex = 0;
tn.SelectedImageIndex = 0;
tv.Nodes.Add(tn);//该TreeView命名为tv
tv.SelectedNode = tv.TopNode;
//把其他节点加上去
if (ds != null)
...{
foreach (DataRow dr in ds.Tables[0].Rows)
...{
tn = new TreeNode();
tn.Text = dr["CateName"].ToString();
tn.Name = dr["CateID"].ToString();//Name作为CateID
tn.Tag = dr["RootID"].ToString();//Tag作为RootID
tn.ImageIndex = 1;
tn.SelectedImageIndex = 1;
//判断是否为主节点
if (dr["CateID"].ToString() == dr["RootID"].ToString())
...{
//主节点
tv.SelectedNode = tv.TopNode;
}
else
...{
//其他节点
if (tv.SelectedNode.Name != dr["ParentID"].ToString())
...{
TreeNode[] tn_temp = tv.Nodes.Find(dr["ParentID"].ToString(), true);
if (tn_temp.Length > 0)
...{
tv.SelectedNode = tn_temp[0];
}
}
}
tv.SelectedNode.Nodes.Add(tn);
}
tv.ExpandAll();//展开TreeView
tv.SelectedNode = tv.TopNode;
}
}