XML数据操作指南：增删改查与分页实现

using System.Xml;//必须引用的命名空间
public partial class Admin_VideoList : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
         bind((AspNetPager1.StartRecordIndex / AspNetPager1.PageSize) + 1);   
    }
    /// <summary>
    /// 绑定gridview数据并显示
    /// </summary>
    /// <param name="PageIndex"></param>
    public void bind(int PageIndex)//生明一个参数 ---当前第几页
    {
        GridView1.DataSource = bindList(PageIndex);
        GridView1.DataBind();
    }
    /// <summary>
    /// 方法bindList调用video文件中的数据（供显示调用）
    /// </summary>
    /// <param name="PageIndex"></param>
    /// <returns></returns>
    public DataTable bindList(int PageIndex)
    {
        string Path = "../Video/list1.xml";//定义路径的初始值

        DataTable dt = new DataTable();//创建table 暂时存放数据
        dt.Columns.Add("Cid", typeof(string));//创建table列的集合
        dt.Columns.Add("name", typeof(string));
        dt.Columns.Add("videotitle", typeof(string));

        dt.Columns.Add("link", typeof(string));
        dt.Columns.Add("thumb", typeof(string));

        XmlDataDocument xmlData = new XmlDataDocument();//创建检索数据的xmldata
        xmlData.Load(Server.MapPath(Path));//xmldata获取路径
        XmlNode root = xmlData.SelectSingleNode("item");//声明一个节点item

        int PageSize = 3;//每页三条记录
        AspNetPager1.PageSize = PageSize;//AspNetPager1是一个分页控件
        int i = 0;
        int count = 0;

        foreach (XmlNode node in root)
        {
             count++;
             i++;
            DataRow dr = dt.NewRow();//声明table中的rows
            if (i >((PageIndex - 1) * PageSize) && i <= (PageIndex * PageSize))
            {
                dr["Cid"] = node.Attributes["Cid"].Value;//给rows中列赋值
                dr["name"] = node.Attributes["name"].Value;
                dr["videotitle"] = node.Attributes["videotitle"].Value;
                dr["link"] = node.Attributes["link"].Value;
                dr["thumb"] = node.SelectSingleNode("thumb").ChildNodes.Item(0).Value;//寻找新的节点thumb 并赋值

                dt.Rows.Add(dr);//给datatable添加一条记录
              }
          
            AspNetPager1.RecordCount = count; //有几条记录要显示---PageSize是要显示几条 
                                                                               //往往最后一页的记录count会<PageSize