實(shí)例分析VB.NET Treeview結(jié)構(gòu)
本人很喜歡VB.NET,在工作中也很喜歡總結(jié)關(guān)于VB.NET Treeview結(jié)構(gòu)的經(jīng)驗(yàn)教訓(xùn),我們簡(jiǎn)單分析一下VB.NET Treeview結(jié)構(gòu)(筆者準(zhǔn)備在另文專門剖析一下VB.NET Treeview結(jié)構(gòu),以方便有興趣的網(wǎng)友進(jìn)行高級(jí)應(yīng)用)
Treeview是由節(jié)點(diǎn)TreeNode組成的,第一級(jí)的稱之為根節(jié)點(diǎn)TreeRoot,在根節(jié)點(diǎn)之下一級(jí)的稱之為某個(gè)根節(jié)點(diǎn)的子節(jié)點(diǎn)TreeLeaf,某個(gè)子節(jié)點(diǎn)之下一級(jí)的子節(jié)點(diǎn)就稱為該子節(jié)點(diǎn)的子節(jié)點(diǎn)。第個(gè)節(jié)點(diǎn)有兩個(gè)標(biāo)識(shí)方式,一個(gè)是它的Text,即顯示出來的內(nèi)容;另一個(gè)是它的Tag屬性,一般用唯一標(biāo)識(shí)碼對(duì)其進(jìn)行標(biāo)識(shí),以用于在使用時(shí)對(duì)節(jié)點(diǎn)的識(shí)別。在本文中,也主要用Text屬性來顯示節(jié)點(diǎn)的名稱字段,用Tag屬性來顯示節(jié)點(diǎn)的編號(hào)屬性。(節(jié)點(diǎn)編號(hào)被設(shè)為主鍵,也就是唯一的標(biāo)識(shí)了)
1.加載根節(jié)點(diǎn)
好了,我們?cè)撻_始在VB.NET中進(jìn)行演練了!第一步,當(dāng)然是看看怎么在窗體起始的時(shí)候加載根節(jié)點(diǎn):
- '定義公用變量
- Dim myconnection As New OleDb.OleDbConnection()
- Dim MyAdapater As New OleDb.OleDbDataAdapter()
- Dim mycommand As New OleDb.OleDbCommand()
- Dim ds As New DataSet()
- Private Sub Form1_Load(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles MyBase.Load- '載入根節(jié)點(diǎn)表至treeview中,作為第一級(jí)
- myconnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;
- Data Source=" & Application.StartupPath & "\project.mdb"
- '數(shù)據(jù)庫連接請(qǐng)自行更換
- mycommand.CommandText = "SELECT 根節(jié)點(diǎn)編號(hào),根節(jié)點(diǎn)名稱 FROM 根節(jié)點(diǎn)"
- mycommand.Connection = myconnection
- Try
- myconnection.Close()
- myconnection.Open()
- Dim mysqlreader As OleDb.OleDbDataReader = mycommand.ExecuteReader
- TreeView1.Nodes.Clear()
- While mysqlreader.Read()
- Dim tree_root As New TreeNode()
- tree_root.Tag = mysqlreader.GetString(0)
- '把編號(hào)放入tag中
- tree_root.Text = mysqlreader.GetString(1)
- '樹上顯示的是根節(jié)點(diǎn)名稱
- '請(qǐng)根據(jù)你數(shù)據(jù)庫字段的類型來決定是否用getstring或其它類型
- TreeView1.Nodes.Add(tree_root)
- End While
- Catch ex As Exception
- MessageBox.Show(ex.ToString, "數(shù)據(jù)表根節(jié)點(diǎn)載入錯(cuò)誤", vbOKOnly)
- Finally
- myconnection.Close()
- End Try
- TreeView1.ExpandAll()
- TreeView1.Select()
- End Sub
2.點(diǎn)擊時(shí)加入子節(jié)點(diǎn)
對(duì)TreeView的點(diǎn)擊,對(duì)于TreeView控件本身,并沒有為哪一個(gè)級(jí)別的Node編寫點(diǎn)擊(選擇)事件處理程序,而是把所有節(jié)點(diǎn)的點(diǎn)擊事件都寫入了一個(gè)AfterSelect事件中。因此,在編寫點(diǎn)擊加入子節(jié)點(diǎn)的程序之前,我們還必須編寫一個(gè)查找點(diǎn)擊的節(jié)點(diǎn)是哪一級(jí)節(jié)點(diǎn)的方法。
- Public Function NodeLevel(ByVal n As TreeNode) As Byte
- '* 找出樹中當(dāng)前節(jié)點(diǎn)的級(jí)數(shù)
- Dim i As Byte = 1
- Dim m As String
- Do Until n.Parent Is Nothing
- nn = n.Parent
- i += 1
- Loop
- Return i
- End Function
通過這個(gè)函數(shù),就可以很方便地得到節(jié)點(diǎn)的級(jí)別?,F(xiàn)在我們可以放心地編寫節(jié)點(diǎn)選擇事件處理程序,以實(shí)現(xiàn)動(dòng)態(tài)加載各級(jí)節(jié)點(diǎn)的子節(jié)點(diǎn)。
- Private Sub TreeView1_AfterSelect(ByVal sender As System.Object,
ByVal e As System.Windows.Forms.TreeViewEventArgs) Handles TreeView1.AfterSelect- Select Case NodeLevel(e.Node).ToString
- Case "1"
- If e.Node.GetNodeCount(False) = 0 Then
- mycommand.CommandText = "select 第一級(jí)子節(jié)點(diǎn)編號(hào),第一級(jí)子節(jié)點(diǎn)名稱
from 第一級(jí)子節(jié)點(diǎn) where 根節(jié)點(diǎn)編號(hào) ='" & e.Node.Tag & "'"- fill_treeleaf()
- End If
- Case "2"
- If e.Node.GetNodeCount(False) = 0 Then
- mycommand.CommandText = "select 第二級(jí)子節(jié)點(diǎn)編號(hào),第二級(jí)子節(jié)點(diǎn)名稱
from 第二級(jí)子節(jié)點(diǎn) where 第一級(jí)子節(jié)點(diǎn)編號(hào) ='" & e.Node.Tag & "'"- fill_treeleaf()
- End If
- End Select
- End Sub
- Public Sub fill_treeleaf()
- mycommand.Connection = myconnection
- Try
- myconnection.Open()
- Dim mysqlreader As OleDb.OleDbDataReader = mycommand.ExecuteReader
- While mysqlreader.Read()
- Dim tree_leaf As New TreeNode()
- tree_leaf.Tag = mysqlreader.GetString(0)
- tree_leaf.Text = mysqlreader.GetString(1)
- TreeView1.SelectedNode.Nodes.Add(tree_leaf)
- End While
- Catch ex As Exception
- MsgBox(ex.Message)
- Finally
- myconnection.Close()
- End Try
- End Sub
【編輯推薦】