使用datalist自定义分页，编辑删除等操作-优快云博客

本文介绍了一种使用 DataList 控件实现自定义分页的方法，并展示了如何在 ASP.NET 应用中进行编辑、删除等操作。通过示例代码，读者可以了解到具体的实现细节。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

使用datalist自定义分页，编辑删除等操作

发布时间:2008-7-24 14:19:50 浏览次数52

userlist.cs代码如下：

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;

public partial class userlist : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            fillpage();
        }
    }
    private void fillpage()
    {
        int curpage = Convert.ToInt32(lblcurpage.Text);
        string sqlstr = "select * from newsuser";
        DataTable dt = newsoperate.getdt(sqlstr);
        PagedDataSource pds = new PagedDataSource();
        pds.DataSource = dt.DefaultView;
        pds.AllowPaging = true;
        pds.CurrentPageIndex=curpage-1;
        pds.PageSize =15;

        DataList1.DataSource = pds;
        DataList1.DataKeyField = "uid";
        DataList1.DataBind();

lbltotal.Text = pds.PageCount.ToString() ;

        if (curpage == 1)
        {
            lbfirstpage.Enabled = false;
            Lblastpage.Enabled = false;
        }
        else
        {
           lbfirstpage.Enabled = true;
            Lblastpage.Enabled = true;
        }
        if (curpage == Convert.ToInt32(lbltotal.Text))
        {
            Lbnextpage.Enabled = false;
            Lbendpage.Enabled = false;
        }
        else
        {
            Lbnextpage.Enabled = true;
            Lbendpage.Enabled = true;
        }
    }
    protected void lbfirstpage_Click(object sender, EventArgs e)
    {
        lblcurpage.Text = "1";
        fillpage();
    }

    protected void Lblastpage_Click(object sender, EventArgs e)
    {
        int nowpage = Convert.ToInt32(lblcurpage.Text)-1;
        lblcurpage.Text = nowpage.ToString();
        fillpage();
    }
    protected void Lbnextpage_Click(object sender, EventArgs e)
    {
int nowpage = Convert.ToInt32(lblcurpage.Text)+1;
        lblcurpage.Text = nowpage.ToString();
        fillpage();
    }
    protected void Lbendpage_Click(object sender, EventArgs e)
    {
   lblcurpage.Text = lbltotal.Text;
        fillpage();
    }

    protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
    {
        if (e.CommandName == "select")
        {
            this.DataList1.SelectedIndex = e.Item.ItemIndex;
            fillpage();
        }
if (e.CommandName == "back")
        {
            this.DataList1.SelectedIndex = -1;
            fillpage();
        }
if (e.CommandName == "quit")
        {
            this.DataList1.EditItemIndex = -1;
            fillpage();
        }
    }
    protected void DataList1_CancelCommand(object source, DataListCommandEventArgs e)
    {
this.DataList1.SelectedIndex = -1;
            fillpage();
    }
    protected void DataList1_EditCommand(object source, DataListCommandEventArgs e)
    {
        this.DataList1.EditItemIndex = e.Item.ItemIndex;
        fillpage();
    }
    protected void DataList1_UpdateCommand(object source, DataListCommandEventArgs e)
    {

            TextBox tb = (TextBox)e.Item.FindControl("txtuname");
            TextBox tbpwd1 = (TextBox)e.Item.FindControl("txtpwd1");
            TextBox tbpwd2 = (TextBox)e.Item.FindControl("txtpwd2");

            user u = new user();
            u.uid = this.DataList1.DataKeys[e.Item.ItemIndex].ToString().Trim();
            u.uname = tbpwd1.Text;
            u.upwd = useroperate.encrypt(tbpwd1.Text);

            TextBox tboldpwd = (TextBox)e.Item.FindControl("txtoldpwd");
            CustomValidator cv = (CustomValidator)e.Item.FindControl("CustomValidator1");
            string oldpwd1 = tboldpwd.Text;
            string oldpwd2 = newsoperate.findstr("select upwd from newsuser where uid='" + u.uid + "'").Trim();
            if (oldpwd1 != oldpwd2)
            {
                cv.IsValid = false;
            }
            else
            {
                cv.IsValid = true;
            }

            if (this.IsValid)
            {
            string sqlstr = "update newsuser set uname='" + u.uname + "' , upwd='" + u.upwd + "' where uid='" + u.uid + "'";
            try
            {
                if (newsoperate.execsql(sqlstr))
                {
                    Response.Write("<script>alert('更新成功');location.href='userlist.aspx';</script>");
                }
            }
            catch (Exception)
            { Response.Write("<script>alert('更新失败');location.href='userlist.aspx';</script>"); }
        }
        }
    protected void CustomValidator1_ServerValidate(object source, ServerValidateEventArgs args)
    {

    }
    protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
    {

    }
    protected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e)
    {
        string nid = this.DataList1.DataKeys[e.Item.ItemIndex].ToString();
        string str="delete from newsuser where uid='"+nid+"'";
        try
        {
            if (newsoperate.execsql(str))
            { Response.Write("<script>alert('删除成功');location.href='userlist.aspx';</script>"); }
        }
        catch(Exception)
        {
             Response.Write("<script>alert('删除失败');location.href='userlist.aspx';</script>");
        }
    }
    protected void lbadd_Click(object sender, EventArgs e)
    {
        Panel1.Visible = true;
    }
    protected void Btnupdate_Click(object sender, EventArgs e)
    {
        if (IsValid)
        {
            user u = new user();
            u.uid = newsoperate.getid();
            u.uname = txtuname.Text;
            u.upwd = useroperate.encrypt(txtpwd2.Text);
            string sqlstr = "insert into newsuser (uid,uname,upwd)values('" + u.uid + "','" + u.uname + "','" + u.upwd + "')";
            try
            {
                newsoperate.execsql(sqlstr);
                Response.Redirect("userlist.aspx");
            }
            catch (Exception)
            {
                Response.Write("<script>alert('失败啊');location.href='userlist.aspx';</script>");
            }
        }
    }
    protected void Btncancel_Click(object sender, EventArgs e)
    {
        Response.Redirect("userlist.aspx");
    }
    protected void CustomValidator2_ServerValidate(object source, ServerValidateEventArgs args)
    {
        string name = txtuname.Text;
        string str="select count(*) from newsuser where uname='" + name + "'";
        if (newsoperate.checkexit(str))
        { args.IsValid = false; }
        else
        { args.IsValid = true; }
    }
}