videolist.aspx.cs

互动媒体学习系统 1．后台 用户注册登录后可进行发布教程、下载等操作 对教程信息进行添加、查询操作。 对视频课堂信息进行查看操作。 对语音课堂信息进行查看操作。 2．后台 输入用户名及密

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;

public partial class VideoList : System.Web.UI.Page
{
    dataOperate mydo = new dataOperate();

    protected void Page_Load(object sender, EventArgs e)
    {
        createVideo();
       
    }

    protected void createVideo()
    {         
        int curpage = Convert.ToInt32(this.labPage.Text);       
        PagedDataSource ps = new PagedDataSource();      
        try
        {         
            string sql = "select * from tb_Video where VideoType=" + Request.QueryString["TypeID"] + " ORDER BY VideoID DESC";
            ps.DataSource = mydo.rows(sql, "tb_Video").DefaultView; //ds.Tables["tb_Video"].DefaultView;           
            //启用分页
            ps.AllowPaging = true;
            //每页显示3条数据
            ps.PageSize = 10;
            //设置当前页的索引
            ps.CurrentPageIndex = curpage - 1;
            this.lnkbtnFront.Enabled = true;
            this.lnkbtnNext.Enabled = true;
            this.lnkbtnLast.Enabled = true;
            this.lnkbtnFirst.Enabled = true;
            if (curpage == 1) //等于第一页
            {
                this.lnkbtnFirst.Enabled = false;//不显示第一页按钮
                this.lnkbtnFront.Enabled = false;//不显示上一页按钮
            }
            if (curpage == ps.PageCount) //等于最后一页
            {
                this.lnkbtnNext.Enabled = false;//不显示下一页
                this.lnkbtnLast.Enabled = false;//不显示最后一页
            }
            this.labBackPage.Text = Convert.ToString(ps.PageCount);
            this.dlVideo.DataSource = ps;
            //设置数据源的关键字段
            this.dlVideo.DataKeyField = "VideoID";
            dlVideo.DataSource = ps;
            dlVideo.DataBind();
          
        }
        catch (Exception ex)
        {
            Response.Write(ex.Message.ToString());
        }     
    }

    protected void lnkbtnFirst_Click(object sender, EventArgs e)
    {
        labPage.Text = "1";//设置当前页为１
        this.createVideo();//调用自定义方法重新绑定数据
    }
    protected void lnkbtnFront_Click(object sender, EventArgs e)
    {
        //设置当前页减１
        labPage.Text = Convert.ToString(Convert.ToInt32(labPage.Text) - 1);
        this.createVideo();//调用自定义方法重新绑定数据
    }
    protected void lnkbtnNext_Click(object sender, EventArgs e)
    {
        //设置当前页加１
        labPage.Text = Convert.ToString(Convert.ToInt32(labPage.Text) + 1);
        this.createVideo();//调用自定义方法重新绑定数据
    }
    protected void lnkbtnLast_Click(object sender, EventArgs e)
    {
        //设置当前页为最后一页
        labPage.Text = labBackPage.Text;
        this.createVideo();//调用自定义方法重新绑定数据
    }
}