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

来源：互联网发布：大话西游计算器软件编辑：程序博客网时间：2024/06/04 18:05

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(); }}

页面代码：

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

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