在gridview中用checkbox选择及排序功能

最新推荐文章于 2023-03-30 21:05:30 发布
最新推荐文章于 2023-03-30 21:05:30 发布
阅读量1.2k 收藏
点赞数
分类专栏： C#
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/zhs954838550/article/details/8748392
版权

前台代码

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="GridView.aspx.cs" Inherits="GridView.GridView" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
     <script type="text/javascript">
         function showinfo() {
             if (confirm('真的要删除吗') == false)
                 return false;
         }
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
            AllowSorting="True" onrowdatabound="GridView1_RowDataBound"
            onsorting="GridView1_Sorting" ShowFooter="True" >
           
            <Columns>
                <asp:TemplateField HeaderText="选择">
                    <ItemTemplate>
                        <asp:CheckBox ID="ck1" runat="server" />
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:BoundField DataField="NewsTitle" HeaderText="标题" />
                <asp:BoundField DataField="NewsContent" HeaderText="内容" />
                <asp:BoundField DataField="CreateTime" DataFormatString="{0:yyyy-mm-dd}"
                    HeaderText="创建时间" SortExpression="CreateTime" />
                <asp:BoundField DataField="ClassName" HeaderText="类别" />
                <asp:BoundField DataField="RealName" HeaderText="创建人"
                    SortExpression="RealName" />
                <asp:TemplateField HeaderText="操作">
                    <ItemTemplate>
                        <asp:LinkButton ID="btnEdit" runat="server" CommandArgument='<%#Eval("Id") %>' οnclick="btnEdit_Click">编辑</asp:LinkButton>
                      
                    </ItemTemplate>
                   
                </asp:TemplateField>
                <asp:TemplateField HeaderText="操作">
                    <ItemTemplate>
                        <asp:LinkButton ID="btndelete" runat="server" CommandArgument='<%#Eval("Id") %>'  οnclick="btndelete_Click"  OnClientClick="return showinfo();">删除</asp:LinkButton>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="操作">
                    <ItemTemplate>
                        <asp:LinkButton ID="btnAdd" runat="server" οnclick="btnAdd_Click">添加</asp:LinkButton>
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>
        </asp:GridView>
        <table style="width: 40%;">
            <tr>
             <td>
                <asp:Button ID="btnFirst" runat="server" Text="第一页" οnclick="btnFirst_Click" />
            </td>
            <td>
                <asp:Button ID="btnPre" runat="server" Text="上一页" οnclick="btnPre_Click" />
            </td>
            <td>
                <asp:Button ID="btnNext" runat="server" Text="下一页" οnclick="btnNext_Click" />
            </td>
             <td>
                 <asp:Button ID="btnLast" runat="server" Text="最后一页" οnclick="btnLast_Click" />
            </td>
            <td>
            <asp:Button ID="btndelete2" runat="server" Text="删除" OnClientClick="return showinfo()" οnclick="btndelete2_Click" />
            </td>
            </tr>
           
        </table>

    </div>
    </form>
</body>
</html>

 

后台代码

 

 private void LoadData()
        {
            SqlConnection conn = new SqlConnection(constr);
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            conn.Open();
            //cmd.CommandText = "select T1.Id,T1.NewsTitle,SUBSTRING(T1.NewsContent,0,20)+'......' as NewsContent,T1.CreateTime,T2.ClassName,T3.RealName From T_News1 T1 inner join T_NewsClass T2 on T1.ClassId=T2.ClassId inner join T_User T3 on T1.NewsCreator=T3.UserId";
            //cmd.CommandText = "select * from (select ROW_NUMBER() over(order by T1.Id) as rownum,T1.Id,T1.NewsTitle,SUBSTRING(T1.NewsContent,0,20)+'......' as NewsContent,T1.CreateTime,T2.ClassName,T3.RealName From T_News1 T1 inner join T_NewsClass T2 on T1.ClassId=T2.ClassId inner join T_User T3 on T1.NewsCreator=T3.UserId)as A where A.rownum>(@pageIndex-1)* @pageSize and A.rownum<= @pageSize*@pageIndex";
            string sqlstr = "SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY T1.Id DESC)AS rownumber, T1.Id,T1.NewsTitle,SUBSTRING(T1.NewsContent,0,20)+'......' AS NewsContent,T1.CreateTime,T2.ClassName,T3.RealName  FROM T_News1 T1 INNER JOIN T_NewsClass T2 ON T1.ClassId=T2.ClassId INNER JOIN T_User T3 ON T1.NewsCreator=T3.UserId)A WHERE A.rownumber>(@pageindex-1)*@pagesize AND A.rownumber<=@pageindex*@pagesize";
            if (ViewState["sortexp"]!=null)
            {
                Dictionary<string, string> dic = ViewState["sortexp"] as Dictionary<string, string>;
                string sqlorder = string.Empty;
                foreach (KeyValuePair<string,string> item in dic)
                {
                    sqlorder += item.Key + " " + item.Value+",";
                }
                sqlstr=sqlstr+" ORDER BY "+sqlorder.TrimEnd(',');
            }
            cmd.CommandText = sqlstr;

           
            cmd.Parameters.Add(new SqlParameter("@pageindex", ViewState["pageindex"]));
            cmd.Parameters.Add(new SqlParameter("@pagesize", pagesize));
            SqlDataAdapter adapter = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            adapter.Fill(dt);
            GridView1.DataSource = dt;
            GridView1.DataBind();

        }

        protected void btnFirst_Click(object sender, EventArgs e)
        {
            ViewState["pageindex"] = 1;
            LoadData();
        }

        protected void btnPre_Click(object sender, EventArgs e)
        {
            int pageindex = Convert.ToInt32(ViewState["pageindex"]);
            if (pageindex <= Convert.ToInt32(ViewState["pagelastindex"]))
            {
                pageindex--;
                ViewState["pageindex"] = pageindex;
                LoadData();
            }
        }

        protected void btnNext_Click(object sender, EventArgs e)
        {
            int pageindex =Convert.ToInt32( ViewState["pageindex"]);
            if (pageindex < Convert.ToInt32(ViewState["pagelastindex"]))
            {
                pageindex++;
                ViewState["pageindex"] = pageindex;
                LoadData();
            }
        }

 

 

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
        {
           
            #region
            if (e.Row.RowType == DataControlRowType.Header)
            {
                for (int i = 0; i < e.Row.Cells.Count; i++)
                {
                    if (e.Row.Cells[i].Controls.Count > 0)
                    {
                        LinkButton link = e.Row.Cells[i].Controls[0] as LinkButton;
                        string sortexp = link.CommandArgument;
                        if (ViewState["sortexp"] != null)
                        {
                            Dictionary<string, string> dic = ViewState["sortexp"] as Dictionary<string, string>;
                            if (dic.ContainsKey(sortexp))
                            {
                                Literal li = new Literal();
                                if (dic[sortexp] == "ASC")
                                {
                                    li.Text = "↑";

                                }
                                else
                                {
                                    li.Text = "↓";
                                }
                                e.Row.Cells[i].Controls.Add(li);

                            }
                        }
                    }
                }
            }
            #endregion
            #region 分别计算出每一页中创建者为刘晓飞和肖维哲的新闻记录的数量
            if (e.Row.RowType == DataControlRowType.DataRow)
                {
                    if (e.Row.Cells[5].Text == "刘晓飞")
                    {
                        lcount++;
                    }
                    else if (e.Row.Cells[5].Text == "肖唯哲")
                    {
                        xcount++;
                    }
                }
            #endregion
            #region 在页脚显示新闻记录数量
            if (e.Row.RowType == DataControlRowType.Footer)
                {
                    e.Row.Cells[0].Text = string.Format("刘晓飞:{0},肖伟哲:{1}", lcount, xcount);
                    //合并单元格，就是删除多余的单元格，然后让剩下的单元格占据所有单元格的宽度之和
                    e.Row.Cells.RemoveAt(7);
                    e.Row.Cells.RemoveAt(6);
                    e.Row.Cells.RemoveAt(5);
                    e.Row.Cells.RemoveAt(4);
                    e.Row.Cells.RemoveAt(3);
                    e.Row.Cells.RemoveAt(2);
                    e.Row.Cells.RemoveAt(1);
                    e.Row.Cells[0].ColumnSpan = 8;
                    e.Row.Cells[0].HorizontalAlign = HorizontalAlign.Right;
                }
            #endregion
        }

        //选中多条删除
        protected void btndelete2_Click(object sender, EventArgs e)
        {
            string sqlid = string.Empty;
            foreach (GridViewRow row in this.GridView1.Rows)
            {
               CheckBox chek= row.Cells[0].FindControl("ck1") as CheckBox;
               if (chek.Checked == true)
               {
                   LinkButton link = row.Cells[6].FindControl("btnEdit") as LinkButton;
                   sqlid+= link.CommandArgument + ",";
                
               }
               if (DeleteNews(sqlid.TrimEnd(',')) > 0)
               {
                   ClientScript.RegisterStartupScript(this.GetType(), "aaa", "alert('删除成功')", true);
                   LoadData();
               }
            }
           
        }
        private int DeleteNews(string sqlid)
        {
            SqlConnection conn = new SqlConnection(constr);
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            //每次都显式打开
            conn.Open();
            cmd.CommandText = " DELETE FROM T_News1 WHERE Id IN(" + sqlid + ")";
            int totalcount = cmd.ExecuteNonQuery();
            cmd.Dispose();
            conn.Dispose();
            return totalcount;
        }
      
    }

 


protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
        {
           
            #region
            if (e.Row.RowType == DataControlRowType.Header)
            {
                for (int i = 0; i < e.Row.Cells.Count; i++)
                {
                    if (e.Row.Cells[i].Controls.Count > 0)
                    {
                        LinkButton link = e.Row.Cells[i].Controls[0] as LinkButton;
                        string sortexp = link.CommandArgument;
                        if (ViewState["sortexp"] != null)
                        {
                            Dictionary<string, string> dic = ViewState["sortexp"] as Dictionary<string, string>;
                            if (dic.ContainsKey(sortexp))
                            {
                                Literal li = new Literal();
                                if (dic[sortexp] == "ASC")
                                {
                                    li.Text = "↑";

                                }
                                else
                                {
                                    li.Text = "↓";
                                }
                                e.Row.Cells[i].Controls.Add(li);

                            }
                        }
                    }
                }
            }
            #endregion
            #region 分别计算出每一页中创建者为刘晓飞和肖维哲的新闻记录的数量
            if (e.Row.RowType == DataControlRowType.DataRow)
                {
                    if (e.Row.Cells[5].Text == "刘晓飞")
                    {
                        lcount++;
                    }
                    else if (e.Row.Cells[5].Text == "肖唯哲")
                    {
                        xcount++;
                    }
                }
            #endregion
            #region 在页脚显示新闻记录数量
            if (e.Row.RowType == DataControlRowType.Footer)
                {
                    e.Row.Cells[0].Text = string.Format("刘晓飞:{0},肖伟哲:{1}", lcount, xcount);
                    //合并单元格，就是删除多余的单元格，然后让剩下的单元格占据所有单元格的宽度之和
                    e.Row.Cells.RemoveAt(7);
                    e.Row.Cells.RemoveAt(6);
                    e.Row.Cells.RemoveAt(5);
                    e.Row.Cells.RemoveAt(4);
                    e.Row.Cells.RemoveAt(3);
                    e.Row.Cells.RemoveAt(2);
                    e.Row.Cells.RemoveAt(1);
                    e.Row.Cells[0].ColumnSpan = 8;
                    e.Row.Cells[0].HorizontalAlign = HorizontalAlign.Right;
                }
            #endregion
        }

        //选中多条删除
        protected void btndelete2_Click(object sender, EventArgs e)
        {
            string sqlid = string.Empty;
            foreach (GridViewRow row in this.GridView1.Rows)
            {
               CheckBox chek= row.Cells[0].FindControl("ck1") as CheckBox;
               if (chek.Checked == true)
               {
                   LinkButton link = row.Cells[6].FindControl("btnEdit") as LinkButton;
                   sqlid+= link.CommandArgument + ",";
                
               }
               if (DeleteNews(sqlid.TrimEnd(',')) > 0)
               {
                   ClientScript.RegisterStartupScript(this.GetType(), "aaa", "alert('删除成功')", true);
                   LoadData();
               }
            }
           
        }
        private int DeleteNews(string sqlid)
        {
            SqlConnection conn = new SqlConnection(constr);
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            //每次都显式打开
            conn.Open();
            cmd.CommandText = " DELETE FROM T_News1 WHERE Id IN(" + sqlid + ")";
            int totalcount = cmd.ExecuteNonQuery();
            cmd.Dispose();
            conn.Dispose();
            return totalcount;
        }
      
    }

 

 

成长的小码农
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Checkbox多选框实现点击顺序排序
qq_43717742的博客
12-21 935
Checkbox多选框实现点击顺序排序
checkbox根据点击顺序排序
weixin_43932597的博客
02-09 234
checkbox根据点击顺序排序
C#_winform_GridView_CheckBox_多选_全选
01-12
C#_winform_GridView_CheckBox_多选_全选
antd Checkbox多选框实现点选排序
05-08 2745
实现效果： 展示代码如下： import { Row, Col, Badge, Checkbox } from 'antd'; const CheckboxGroup = Checkbox.Group; ... <Col span={6} style={{ margin: '8px 0' }}> <Badge count={this.state.sort_reply...
el-checkbox-group 选中返回的数组按照选项顺序排列 || el-radio-group单击选中、双击取消选中
最新发布
Y_seaboy的博客
03-30 745
【代码】解决el-checkbox-group input事件返回的数组不是按照选项顺序排列的问题。
asp.net gridview中用checkbox全选的几种实现的区别
10-29
几天为了改变客户端grid的全选效率问题，详细研究了ext中grid的全选和gridview中通过脚本实现的全选效率，总结一下，供大家参考，有错误的地方，希望大侠指正，小弟献丑了。
GridView的CheckBox列选择及多参数传递三步搞定
10-27
GridView的CheckBox列选择及多参数传递三步实现:GridView的列设置/全选的Js处理/后台对所选值的获取，操作步骤很详细，有利于新手学习，感兴趣的朋友可以了解下啊
Winform中GridView分组排序功能实现方法
09-04
主要介绍了Winform中GridView分组排序功能实现方法,以实例形式详细说明了分组排序的实现方法,并附带完整的DBHelp类代码,是非常实用的技巧,需要的朋友可以参考下
gridview和checkboxlist的嵌套相关应用
10-27
在GridView中嵌套CheckBoxList，通常是为每一行数据添加一个CheckBoxList，这样用户可以选择某一行中的多个子项。在这个例子中，我们看到代码中通过JavaScript来处理CheckBoxList的点击事件，这通常发生在客户端，即...
checkbox选中根据点击先后顺序依次显示
weixin_30408675的博客
07-27 1178
<SCRIPT LANGUAGE="JavaScript"> var cache=[]; var cbs=document.getElementsByTagName("INPUT"); for (var i=0;i<cbs.length;++i ) { if(cbs[i].type!='check...
GridView与javascript、checkbox
weixin_33995481的博客
12-31 51
a.aspx <asp:GridView runat="server" ID="GridView1" AutoGenerateColumns="False"> <Columns> <asp:TemplateField> ...
QTableWidget中插入复选框及点击表头排序
Alexabc3000的专栏
02-09 1453
QTableWidget中插入复选框及点击表头排序 关键词：QTableWidget（控件），复选框，点击表头排序 为了在Qt中实现在表中插入复选框、以及点击表头实现排序功能（要求有的列按数值排序、有的列按字典序排序），耗费了我好几天时间，还是比较痛苦的几天，在网上查了相关资料，将其总结如下。 创建一个对话框，向对话框添加QTableWidget控件，并栅格布局（“Lay out in a Grid”）。在对话框的构造函数中插入代码（此处仅仅是为了易于实现，这些代码当然也可写在别的函数中）..
C# 遍历CheckBox的三种简单方法
头发凌乱的小博客
09-04 2017
//遍历CheckBox方法1             foreach (Control c in groupBox1.Controls)//遍历groupBox1内的所有控件             {                 if (c is CheckBox)//只遍历CheckBox控件                  {                     ((CheckB
嵌入checkbox数据丢失问题
weixin_34405925的博客
03-19 110
嵌入checkbox数据丢失问题 为了综合应用需求，将checkbox嵌入datagrid中作为一列，这个显示效果之前已经提到过，但是随之而来的是另一个问题，datagrid使用 滚动条查看数据时，checkbox的值会变化，出现很诡异的现象（多选或少选），总之不能确保勾选的是用户想要选择的记录。为了解决这个问题，在网上荡 了好些天，看了...
换页时,Gridview当前页选中的CheckBox选中状态不会丢失
godpreserve的专栏
05-06 1866
    客户端代码:function check(opt,id){    var chk = window.document.getElementById(opt);    if(chk.checked == true)    {        chk.checked = false;    }    else    {        chk.checked = true;    }    v
原生js实现多选框的排序以及可选个数控制
Hey firefly
02-21 3173
展示页面： http://codepen.io/crystalYY/pen/ggNjQR主要效果： 最多可选择三项，用户尝试选择第四项时，多选框变为disabled禁用状态 按照用户点击的顺序实时给出已选择的多选框所对应的序号 左下方实时提醒用户当前已选择了几项 实现思路： 设置一个用来存放已经选定的多选框，即obj.checked=true的value的数组checkedArray 效果1实现思路
JS实现table动态生成过程中，移动行checkbox值丢失问题的解决
thomas0988
09-25 199
 最近在做项目过程中遇到这样一个疑问：（查看实例代码TEST1）　　DHTML中table对象的moveRow方法实现对table中表格行移动到新位置。例子TEST1中行2包含文本框、复选框、下拉框，当分别键入值后对行2执行上移操作后，我们发现，文本框与下拉框的值不会丢失，但复选框值会丢失。而如果在行2中键入值后对行1执行下移操作，这时候所有值都不会丢失。这也就说明了moveRow方法对所操作行中...
用javascript操纵GridView中CheckBox的两个常用技巧
weixin_33709219的博客
05-19 71
这篇文章同样是为了解决一个博问中的提问： 提问：关于JS读取gridview,checkbox选择情况。当然，下面的实现中，有一半是为解决这个问题而做的，另一半是很久前帮另一位朋友做的，同样关于javascript对GridView中的CheckBox的操作，只是操作顺序完全反过来了，不是获取所有选择的项，而是根据用户的输入，自动选择选择相应的项。 虽然是为了解决GridView中的CheckB...
DataGridView复选框实现全选功能，并取被选中的某行某列的值（三）
weixin_33898876的博客
10-27 468
目标： 一、选中全选这个复选框，会选中第一列所有的复选框 拉过来一个CheckBox控件(CheckBox1)覆盖在第一列的标题上，文本值：全选 方法：双击上面拉的CheckBox控件，进入其事件 private void checkBox1_CheckedChanged(object sender, EventArgs e) { ...
提升GridView功能：无代码排序、编辑与特效
在ASP.NET开发中，GridView是一个功能强大的控件，它允许用户对数据进行直观且交互式的浏览、排序、筛选和编辑。以下是一些关键的GridView技巧和应用： 1. **无代码分页与排序**： GridView的`AllowSorting`属性...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值