GridView实战参考(二)

最新推荐文章于 2021-08-27 08:48:33 发布

原创最新推荐文章于 2021-08-27 08:48:33 发布 · 1.9k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#object #sorting #string #session #textbox #sql

.NET & C# 专栏收录该内容

67 篇文章

订阅专栏

本文介绍了一个ASP.NET应用程序中GridView控件的各种操作，包括排序、分页、编辑、更新及删除等核心功能，并展示了如何通过后台代码实现这些功能。

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

代码页 Default3.aspx.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;
using _14Base;
public partial class Default3 : AdminBase
{
    Conn conn = new Conn();
    private int TotalNum = 0;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            Bind();
            Session["SortDirection"] = "Desc";
        }
    }
    private void Bind()
    {
        Bind("id", "Desc");
    }
    /// <summary>
    /// 绑顶
    /// </summary>
    /// <param name="SortPression"></param>
    /// <param name="SortDirction"></param>
    private void Bind(string SortPression,string SortDirction)
    {
        string sql = "select * from Test order by " + SortPression + " " + SortDirction;
        GridView1.DataSource = conn.GetSet(sql).Tables[0].DefaultView;
        GridView1.DataBind();
    }
    /// <summary>
    /// 分页
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        Bind();
    }
    /// <summary>
    /// 更新
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        TextBox NewNum = (TextBox)GridView1.Rows[e.RowIndex].Cells[5].Controls[0];
        int Sex=0;
        if (Request.Form["SltSex"] == null)
        {
             Sex = 0;
        }
        else
        {
             Sex = int.Parse(Request["SltSex"].ToString());
        }

        int n=int.Parse(GridView1.Rows[e.RowIndex].Cells[1].Text);
        string sql = "update Test set Num=" + NewNum.Text + ",sex=" + Sex.ToString()+ " where id=" + n.ToString();
        conn.ExecSQL(sql);
        GridView1.EditIndex = -1;
        Bind();

    }
    /// <summary>
    /// 排序
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
    {
        //GridView不支持对自身列的排序，而是使用对数据源的排序来实现
        //The GridView control does not perform its own sorting of columns, but rather relies on the data source control to perform sorting on its behalf
        string sortDirection="desc";
        if (Session["SortDirection"]== null || Session["SortDirection"].ToString() == "Desc")
        {
            sortDirection = "desc";
            Session["SortDirection"] = "Asc";

        }
        else
        {
            Session["SortDirection"] = "Desc";
            sortDirection="asc";
        }
        Bind(e.SortExpression,sortDirection);
    }
    protected void GridView1_DataBinding(object sender, EventArgs e)
    {

    }
    /// <summary>
    /// 实现列汇总
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void GridView1_DataBound(object sender, EventArgs e)
    {
        if (GridView1.Rows.Count > 0)
        {
            GridView1.FooterRow.Cells[5].Text = "总计：" + TotalNum.ToString();
        }
    }
    /// <summary>
    /// 实现删除
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        int n = int.Parse(GridView1.Rows[e.RowIndex].Cells[1].Text);
        string sql = "delete from Test where id=" + n.ToString();
        conn.ExecSQL(sql);
        Bind();

    }
    /// <summary>
    /// 编辑列
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex;
        Bind();
    }
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        Bind();
    }
    protected void GridView1_Sorted(object sender, EventArgs e)
    {
    }
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            DataRowView dr = (DataRowView)e.Row.DataItem;
            TotalNum = TotalNum + Convert.ToInt32(dr["num"]);
        }
    }
    /// <summary>
    /// 批量删除
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void Button1_Click(object sender, EventArgs e)
    {
        string sql = "delete from Test where id in (" + Request.Form["Checkbox1"] + ")";
        conn.ExecSQL(sql);
        Bind();
    }
}