12-18checkbox 实现全选，全不的功能（服务端和客户端）

最新推荐文章于 2021-02-27 01:18:00 发布

刘晓飞

最新推荐文章于 2021-02-27 01:18:00 发布

阅读量369

点赞数

分类专栏： ASP高级

本文链接：https://blog.csdn.net/lxfzgg/article/details/8315805

版权

ASP高级专栏收录该内容

27 篇文章 0 订阅

订阅专栏

********************************Demo.aspx

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

<!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 chage(sender) {
            var table = document.getElementById("GridView1");
            for (var i = 1; i < table.rows.length; i++) {
                table.rows[i].cells[0].getElementsByTagName("input")[0].checked = sender.checked;
            }
        }
    </script>--------------------------------------------客户端
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <br />
        <br />
        <asp:SqlDataSource ID="SqlDataSource1" runat="server"
            ConnectionString="<%$ ConnectionStrings:studentConnectionString3 %>"
            SelectCommand="SELECT [sname], [sex], [age], [sid] FROM [student]"></asp:SqlDataSource>
        <asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1">
            <Columns>
                <asp:TemplateField>
                    <HeaderTemplate>
                        <asp:CheckBox ID="CheckBox2" runat="server" AutoPostBack="True"
                            oncheckedchanged="CheckBox2_CheckedChanged1" />
                        <br />
                        <input id="Checkbox3" type="checkbox" onclick ="chage(this)" />
                    </HeaderTemplate>
                    <ItemTemplate>
                        <asp:CheckBox ID="CheckBox1" runat="server" />
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>
        </asp:GridView>
        <br />
        <br />
    </div>
    </form>
</body>
</html>

********************************Demo.aspx.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using ExecuteReader3;
using System.Data;

namespace DataList
{
    public partial class Demo : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if(!IsPostBack )
            {
               bindData();
            }
        }

        private void bindData()
        {
            string sql = "select * from student";
            DataTable dt = sqlhelp.Executedatatable(sql);
            this.DataList1.DataSource = dt;
            this.DataList1.DataBind();
        }

        protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
        {
            if (e.CommandName == "buy")
            {
                Response.Write(e.CommandArgument .ToString ());
            }
        }
        protected void DataList1_EditCommand(object source, DataListCommandEventArgs e)
        {
            this.DataList1.EditItemIndex = e.Item.ItemIndex;
            this.bindData();//重新在绑一次
        }

        protected void DataList1_UpdateCommand(object source, DataListCommandEventArgs e)
        {
            string sql = "update student set sname=@name,sex=@sex,age=@age where sid=@sid";

            string name =(e.Item.FindControl("txtname") as TextBox).Text;
            string sex = (e.Item.FindControl("txtsex") as TextBox).Text;
            string age = (e.Item.FindControl("txtage") as TextBox).Text;
            SqlParameter[] pms = new SqlParameter[]
            {
               new SqlParameter ("@name",name ),
               new SqlParameter ("@sex",sex ),
               new SqlParameter ("@age",age ),
               new SqlParameter ("@sid",e.CommandArgument )
            };
            sqlhelp.ExcuteNonQuery(sql,pms);
        }

        protected void DataList1_CancelCommand(object source, DataListCommandEventArgs e)
        {
            this.DataList1.EditItemIndex = -1;//谁也不编辑了
            this.bindData();//再重新绑定一下
        }

        protected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e)
        {
            string sql = "delete from student where sid=@sid" ;
            SqlParameter pm = new SqlParameter("@sid",e.CommandArgument );
            sqlhelp.ExcuteNonQuery(sql,pm);
            this.bindData();
        }
    }
}

刘晓飞

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
12-18checkbox 实现全选，全不的功能（服务端和客户端）

********************************Demo.aspxhttp://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">http://www.w3.org/1999/xhtml"> function chage(sender) { var
复制链接

扫一扫

专栏目录