treeview小进展之3

今天上午终于可以实现动态绑定数据库生成treeview节点，然后点节点，就会自动查询数据库！并用DATAGRID显示出所查询到的数据出来！

效果：

文件还是用到以前的两个，只是对tree1.txt改了一下而已，

把autopostback改为true然后添加一些代码如下

    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

    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)
        
        '..实现点击后在LABLE中显示节点的名字
        Label1.Text = ndsel.Text
        '。。实现点击后连接数据库的内容
        Dim con As SqlConnection
        Dim cmd As SqlCommand
        Dim str As String
        Dim dr As SqlDataReader
        con = New SqlConnection("server=(local);uid=sa;pwd=;database=lab1")
        str = "select * from Student_Table where xname='" & ndsel.Text & "'"
        cmd = New SqlCommand(str, con)
        con.Open()
        dr = cmd.ExecuteReader
        DataGrid1.DataSource = dr
        DataGrid1.DataBind()
        con.Close()

 

    End Sub
End Class