GridView使用技巧之一 全选 删除 排序

using System; using System.Data; using System.Configuration; using System.Collections; using System.Collections.Generic; using System.Data.SqlClient; 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 _Default : System.Web.UI.Page { public SqlConnection conn = new SqlConnection("Data source=.;database=Panda;user id=sa;password=sa"); protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataBonud(); } } public void DataBonud() { conn.Open(); string sql = "select * from Users"; DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(sql, conn); DataView dv = new DataView();//排序 da.Fill(ds); dv.Table = ds.Tables[0]; dv.Sort = "statuesId desc";//字段加排序方式 this.GridView1.DataSource = dv; this.GridView1.DataBind(); conn.Close(); } protected void CheckBox2_CheckedChanged(object sender, EventArgs e) { for (int i = 0; i < GridView1.Rows.Count; i++) { CheckBox box = GridView1.Rows[i].FindControl("CheckBox1") as CheckBox; if (CheckBox2.Checked==true) { box.Checked = true; } else { box.Checked = false; } } } protected void Button2_Click(object sender, EventArgs e) { for (int i = 0; i < this.GridView1.Rows.Count; i++) { CheckBox box = GridView1.Rows[i].FindControl("CheckBox1") as CheckBox; if (box.Checked==true) { int ID=Convert.ToInt32( this.GridView1.Rows[i].Cells[1].Text); string sql = "delete from Users where Id =@id"; SqlParameter[] param = new SqlParameter[] {new SqlParameter("Id",ID) }; SqlCommand com = new SqlCommand(sql, conn); com.Parameters.AddRange(param); conn.Open(); int isok=com.ExecuteNonQuery(); conn.Close(); if (isok>0) { Page.ClientScript.RegisterStartupScript(this.GetType(),"","alert('成功咯')",true); } else { return; } } } DataBonud(); } }

 

页面代码：

 

 <form id="form1" runat="server">
    <div>
        <asp:GridView ID="GridView1" runat="server">
        <Columns>
        <asp:TemplateField HeaderText="选择">
        <ItemTemplate>
            <asp:CheckBox ID="CheckBox1" runat="server" />
        </ItemTemplate>
        </asp:TemplateField>
        </Columns>
        </asp:GridView>
    </div>
        <asp:CheckBox ID="CheckBox2" runat="server" Text="全选" OnCheckedChanged="CheckBox2_CheckedChanged" AutoPostBack="true" /><asp:Button
            ID="Button2" runat="server" Text="删除" OnClick="Button2_Click" /><asp:Button ID="Button1" runat="server" Text="取消" />
        &nbsp;<br />
    </form>