GridView和CheckBox结合(在分页状态下)

最新推荐文章于 2023-08-09 14:41:42 发布

smallbee605

最新推荐文章于 2023-08-09 14:41:42 发布

阅读量1.3k

点赞数

文章标签： asp server object button string delete

本文链接：https://blog.csdn.net/smallbee605/article/details/1619793

版权

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 GridView和CheckBox结合_checkbox : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

    }
    //全选
    public void selectAll()//获得开始复选框的索引
    {
        if (CheckBox1.Checked)
        {
            for (int start = 0; start < GridView1.Rows.Count; start++)//启用分页以后每个页面的第一行的索引都是0，
                                                                        //而不是它的实际行号
            {
                ((CheckBox)GridView1.Rows[start].FindControl("CheckBox2")).Checked = true;
            }
        }
        else
        {
            for (int start = 0; start < GridView1.Rows.Count; start++)
            {
                ((CheckBox)GridView1.Rows[start].FindControl("CheckBox2")).Checked = false;
            }
        }
    }

    protected void CheckBox1_CheckedChanged(object sender, EventArgs e)
    {
        selectAll();
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        //设置checkbox为false
        CheckBox1.Checked = false;
    }
    protected void CheckBox2_CheckedChanged(object sender, EventArgs e)
    {
        CheckBox1.Checked = false;
    }
    //删除
    protected void Button1_Click(object sender, EventArgs e)
    {
        //链接数据库
        System.Data.SqlClient.SqlConnection sqlcon = new System.Data.SqlClient.SqlConnection("data source=qifeng;initial catalog=myTestGridView;integrated security=SSPI;");
        //配置命令
        System.Data.SqlClient.SqlCommand sqlcom = new System.Data.SqlClient.SqlCommand();
        sqlcom.Connection = sqlcon;
        sqlcom.CommandText = "delete from stu where stuid = @id ";
        //添加参数
        System.Data.SqlClient.SqlParameter para = new System.Data.SqlClient.SqlParameter("@id", SqlDbType.Int);
        sqlcom.Parameters.Add(para);
        for (int i = 0; i < GridView1.Rows.Count; i++)
        {
            if (((CheckBox)GridView1.Rows[i].FindControl("CheckBox2")).Checked)
            {
                para.Value = GridView1.DataKeys[i].Value;//取得对应行号的主键
                                       //分页情况下每页行号的索引从0开始,用GridView1.DataKeys[i].Value可得到对应主键
                sqlcon.Open();
                sqlcom.ExecuteNonQuery();
                sqlcon.Close();
            }
        }
        //删除后刷新一下页面
        GridView1.DataSourceID = "SqlDataSource1";
    }
}

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="checkbox.aspx.cs" Inherits="GridView和CheckBox结合_checkbox" %>

<!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>GridView和CheckBox结合</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:GridView ID="GridView1" runat="server" AllowSorting="True"
            AutoGenerateColumns="False" CellPadding="4" DataKeyNames="stuid" DataSourceID="SqlDataSource1"
            ForeColor="#333333" GridLines="None" OnPageIndexChanging="GridView1_PageIndexChanging" AllowPaging="True">
            <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <Columns>
                <asp:TemplateField>
                    <ItemTemplate>
                        <asp:CheckBox ID="CheckBox2" runat="server" OnCheckedChanged="CheckBox2_CheckedChanged" AutoPostBack="true" />
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:BoundField DataField="stuid" HeaderText="stuid" InsertVisible="False" ReadOnly="True"
                    SortExpression="stuid" />
                <asp:BoundField DataField="studepid" HeaderText="studepid" SortExpression="studepid" />
                <asp:BoundField DataField="stuname" HeaderText="stuname" SortExpression="stuname" />
                <asp:CheckBoxField DataField="stusex" HeaderText="stusex" SortExpression="stusex" />
                <asp:BoundField DataField="stuaddress" HeaderText="stuaddress" SortExpression="stuaddress" />
                <asp:BoundField DataField="stuage" HeaderText="stuage" SortExpression="stuage" />
                <asp:BoundField DataField="stutuition" HeaderText="stutuition" SortExpression="stutuition" />
                <asp:BoundField DataField="stuaveragescore" HeaderText="stuaveragescore" SortExpression="stuaveragescore" />
                <asp:CommandField ShowEditButton="True" />
            </Columns>
            <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
            <EditRowStyle BackColor="#999999" />
            <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
            <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
            <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
            <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
        </asp:GridView>

    </div>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:myTestGridViewConnectionString %>"
            DeleteCommand="DELETE FROM [stu] WHERE [stuid] = @stuid" InsertCommand="INSERT INTO [stu] ([studepid], [stuname], [stusex], [stuaddress], [stuage], [stutuition], [stuaveragescore]) VALUES (@studepid, @stuname, @stusex, @stuaddress, @stuage, @stutuition, @stuaveragescore)"
            SelectCommand="SELECT * FROM [stu]" UpdateCommand="UPDATE [stu] SET [studepid] = @studepid, [stuname] = @stuname, [stusex] = @stusex, [stuaddress] = @stuaddress, [stuage] = @stuage, [stutuition] = @stutuition, [stuaveragescore] = @stuaveragescore WHERE [stuid] = @stuid">
            <DeleteParameters>
                <asp:Parameter Name="stuid" Type="Int32" />
            </DeleteParameters>
            <UpdateParameters>
                <asp:Parameter Name="studepid" Type="Int16" />
                <asp:Parameter Name="stuname" Type="String" />
                <asp:Parameter Name="stusex" Type="Boolean" />
                <asp:Parameter Name="stuaddress" Type="String" />
                <asp:Parameter Name="stuage" Type="Int32" />
                <asp:Parameter Name="stutuition" Type="Double" />
                <asp:Parameter Name="stuaveragescore" Type="Double" />
                <asp:Parameter Name="stuid" Type="Int32" />
            </UpdateParameters>
            <InsertParameters>
                <asp:Parameter Name="studepid" Type="Int16" />
                <asp:Parameter Name="stuname" Type="String" />
                <asp:Parameter Name="stusex" Type="Boolean" />
                <asp:Parameter Name="stuaddress" Type="String" />
                <asp:Parameter Name="stuage" Type="Int32" />
                <asp:Parameter Name="stutuition" Type="Double" />
                <asp:Parameter Name="stuaveragescore" Type="Double" />
            </InsertParameters>
        </asp:SqlDataSource>
        <asp:CheckBox ID="CheckBox1" runat="server" Text="全选" AutoPostBack="true" OnCheckedChanged="CheckBox1_CheckedChanged" />
        <asp:Button ID="Button1" runat="server" Text="删除" OnClick="Button1_Click" /> 
        <br />
        <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
    </form>
</body>
</html>

smallbee605

关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
1
评论
GridView和CheckBox结合(在分页状态下)

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.
复制链接

扫一扫