admin_top_list.aspx.vb

《ASP.NET C#程序设计案例教程》

Imports System
Imports System.Web
Imports System.Web.UI
Imports System.Web.UI.WebControls
Imports MicroSoft.VisualBasic
Imports System.Data
Imports nsBBS												            '因为用到了自定义业务对象，所以导入

Public Class admin_top_list: Inherits Page
	Public MyDataGrid As DataGrid

	Sub Page_Load(Sender As Object, E As EventArgs)
		'判断一下，如果不是管理员，就返回到首页
		If DataUserLog.IsAdmin()=False Then
			Response.Write("<script language='javascript'>top.location.href='../index.aspx';</script>")
		End If

		If Not Page.IsPostBack Then
			Call myDataBind()										'绑定数据
		End If
	End Sub

	'该过程用于置顶或取消置顶
	Sub myDataGrid_Command(Sender As Object, E As DataGridCommandEventArgs)
		'必须加这个判断，否则切换页面时也会先触发该过程并执行下面的语句，就会产生错误
		If e.CommandName="AddSetTop" Then
			Dim dbs As New DataBusiness()
			Call dbs.AddSetTop(MyDataGrid.DataKeys(E.Item.ItemIndex))

			'重新绑定数据
			Call myDataBind()
		End If
	End Sub

	'该过程用于分页
	Sub MyDataGrid_Page(sender As Object, e As DataGridPageChangedEventArgs)
		myDataGrid.CurrentPageIndex=e.NewPageIndex								
		Call myDataBind()												'绑定数据
	End Sub


	'该过程用于绑定数据
	Sub myDataBind()
		'下面建立DataBusiness对象，返回所有文章
		Dim dbs As New DataBusiness()
		Dim dv As DataView=dbs.GetBBS()
		dv.RowFilter="Layer=1"						'这里原来返回的是所有文章，这里只要第1层文章
		'下面绑定数据
		myDataGrid.DataSource=dv
		myDataGrid.DataBind()	
	End Sub
End Class