四、简单示例
对左边树形结构进行选择,在右边表格中查询显示结果。
说明:
1、 SelectedIndexChange事件是对树结构进行选择时产生的,还有一个触发条件autopostback=true。
2、 例中数据库由SQL 2000建立。 
代码如下:
| Imports System.Data Imports System.Data.SqlClient Public Class tree1 Inherits System.Web.UI.Page Protected WithEvents Button1 As System.Web.UI.WebControls.Button Protected WithEvents DataGrid1 As System.Web.UI.WebControls.DataGrid Protected WithEvents Label1 As System.Web.UI.WebControls.Label Protected WithEvents Label2 As System.Web.UI.WebControls.Label Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim strconnection As String = "server=zln/netsdk;uid=sa;pwd=sa;database=english" Dim conn As New SqlConnection(strconnection) conn.Open() Dim sql As String = "select * from zlk where kemu='" & session("node").ToString & "'" Dim cmd As New SqlCommand(sql, conn) Dim da As SqlDataReader da = cmd.ExecuteReader DataGrid1.DataSource = da DataGrid1.DataBind() End Sub Private Sub TreeView1_SelectedIndexChange(ByVal sender As Object, ByVal e As Microsoft.Web.UI.WebControls.TreeViewSelectEventArgs) Handles TreeView1.SelectedIndexChange Dim ndsel As New Microsoft.Web.UI.WebControls.TreeNode() ndsel = TreeView1.GetNodeFromIndex(TreeView1.SelectedNodeIndex) session("node") = ndsel.Text End Sub End Class |
http://dev.xuezhishi.net/website/NET/2007-10-17/20761.html