aspx文件:
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="wangyi.aspx.cs" Inherits="_12._18zuoye.wangyi" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "">
<html xmlns="">
<head runat="server"> <title></title></head><body> <form id="form1" runat="server"> <div> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="sid" DataSourceID="SqlDataSource1"> <Columns> <asp:TemplateField> <HeaderTemplate> <asp:CheckBox ID="CheckBox2" runat="server" AutoPostBack="True" oncheckedchanged="CheckBox2_CheckedChanged" /> </HeaderTemplate> <ItemTemplate> <asp:CheckBox ID="CheckBox1" runat="server" /> </ItemTemplate> </asp:TemplateField> <asp:BoundField DataField="sid" HeaderText="sid" InsertVisible="False" ReadOnly="True" SortExpression="sid" /> <asp:BoundField DataField="sname" HeaderText="sname" SortExpression="sname" /> <asp:BoundField DataField="sex" HeaderText="sex" SortExpression="sex" /> <asp:BoundField DataField="age" HeaderText="age" SortExpression="age" /> </Columns> </asp:GridView> <br /> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:studentConnectionString %>" DeleteCommand="DELETE FROM [student] WHERE [sid] = @sid" InsertCommand="INSERT INTO [student] ([sname], [sex], [age]) VALUES (@sname, @sex, @age)" SelectCommand="SELECT [sid], [sname], [sex], [age] FROM [student]" UpdateCommand="UPDATE [student] SET [sname] = @sname, [sex] = @sex, [age] = @age WHERE [sid] = @sid"> <DeleteParameters> <asp:Parameter Name="sid" Type="Int32" /> </DeleteParameters> <InsertParameters> <asp:Parameter Name="sname" Type="String" /> <asp:Parameter Name="sex" Type="String" /> <asp:Parameter Name="age" Type="Byte" /> </InsertParameters> <UpdateParameters> <asp:Parameter Name="sname" Type="String" /> <asp:Parameter Name="sex" Type="String" /> <asp:Parameter Name="age" Type="Byte" /> <asp:Parameter Name="sid" Type="Int32" /> </UpdateParameters> </asp:SqlDataSource> </div> </form></body></html>aspx.cs文件:
using System;
using System.Collections.Generic;using System.Linq;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;namespace _12._18zuoye
{ public partial class wangyi : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) {}
protected void CheckBox2_CheckedChanged(object sender, EventArgs e)
{ CheckBox ckb = sender as CheckBox;//捉住CheckBook2 foreach (GridViewRow row in this.GridView1.Rows) { if (row.RowType==DataControlRowType.DataRow) { (row.Cells[0].FindControl("CheckBox1") as CheckBox).Checked = ckb.Checked;//把他的选择状态给那些记录中的CheckBook } } } }}