InsusMenu.ascx.vb
Imports System.Data
Imports Insus.NET
Partial Class AscxControls_InsusMenu
Inherits System.Web.UI.UserControl
‘宣告实例
Dim objVideoLibrary As New VideoLibrary()
Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load
If Not IsPostBack Then
Data_Binding()
End If
End Sub
Private Sub Data_Binding()
‘从数据库获取数据，绑定在第一层的GridView
Me.GridViewYear.DataSource = objVideoLibrary.GetYear()
Me.GridViewYear.DataBind()
End Sub
‘数据绑定在第二层的GridView
Protected Sub GridViewYear_RowDataBound(sender As Object, e As GridViewRowEventArgs)
Dim dvr As DataRowView = DirectCast(e.Row.DataItem, DataRowView)
If e.Row.RowType = DataControlRowType.DataRow Then
If e.Row.FindControl(“GridViewMonth”) IsNot Nothing Then
Dim Gv As GridView = DirectCast(e.Row.FindControl(“GridViewMonth”), GridView)
objVideoLibrary.Year = ConvertData.ToSmallInt(dvr(“Year”))
Gv.DataSource = objVideoLibrary.GetMonthByYear()
Gv.DataBind()
End If
End If
End Sub
‘数据绑定在第三层的GridView
Protected Sub GridViewMonth_RowDataBound(sender As Object, e As GridViewRowEventArgs)
Dim dvr As DataRowView = DirectCast(e.Row.DataItem, DataRowView)
If e.Row.RowType = DataControlRowType.DataRow Then
If e.Row.FindControl(“GridViewVideoFile”) IsNot Nothing Then
Dim Gv As GridView = DirectCast(e.Row.FindControl(“GridViewVideoFile”), GridView)
objVideoLibrary.Year = ConvertData.ToSmallInt(dvr(“Year”))
objVideoLibrary.Month = Conver来源gaodai#ma#com搞@代~码网tData.ToTinyInt(dvr(“Month”))
Gv.DataSource = objVideoLibrary.GetByYearAndMonth()
Gv.DataBind()
End If
End If
End Sub
End Class
