asp.net中ajax全选反选删除,asp.net gridview实现全选,反选与删除记录的操作代码

gridview全选操作

'columns'=>array(

array(

'class'=>'CCheckBoxColumn',

//'header'=>'全选',

//'value'=>'$data->id',

//'checked'=>'true',

'htmlOptions'=>array(

'width'=>'30',

'style'=>'text-align:center',

),

),

<?php echo CHtml::ajaxLink('批量更新', array('link/dels'), array(

'type'=>'POST',

'timeout'=>'30000',

'data'=>'js:{ids:jQuery("input[name=\'link-grid_c0\[\]\']:checked").map(function(){ return $(this).val(); }).get()}',

'beforeSend'=>'function(){ $("#btn").hide(); $("#load").show(); }',

'success'=>'function(html){ alert(html); }',

'complete'=>'function(){ $("#btn").show(); $("#load").hide(); }',

'error'=>'function(a,b,c){ if(b=="timeout") { alert("本次执行过程超过30秒，请分批更新！"); }}',

));?>

正在更新，请稍后......

var ids=jQuery("input[name='link-grid_c0[]']:checked").map(function(){ return $(this).val(); });

//alert(ids.length);

asp.net gridview实现全选,反选与删除记录

.aspx中

.cs

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

SetDataBinder();

}

Button2.Attributes.Add("onclick","return confirm('你确定要删除所选择的记录么?')");

}

protected void SetDataBinder()

{

string sql = "Select * from SendMail";

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["StudyConnectionString"].ToString());

conn.Open();

SqlDataAdapter da = new SqlDataAdapter(sql ,conn );

DataSet ds = new DataSet();

da.Fill(ds,"table");

GridView1 .DataSource =ds.Tables ["table"];

GridView1.DataBind();

conn.Close();

}

///

/// 全选记录

///

///

///

protected void Button1_Click(object sender, EventArgs e)

{

CheckBox cb;

for (int i = 0; i < GridView1.Rows.Count; i++)

{

cb = (CheckBox)GridView1.Rows[i].Cells[0].FindControl("CheckBox1");

cb.Checked = true;

}

}

///

/// 执行删除操作,删除所选择的项

///

///

///

protected void Button2_Click(object sender, EventArgs e)

{

string sql="(";

for (int i = 0; i < GridView1.Rows.Count; i++)

{

CheckBox cb = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1");

if (cb.Checked == true)

{

sql = sql + Convert.ToInt32(GridView1.DataKeys[i].Value) + ",";

}

}

//去掉最后的逗号,并且加上右手号

sql = sql.Substring(0,sql.Length -1)+")";

sql = "delete SendMail where MailID in"+sql;

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["StudyConnectionString"].ToString());

conn.Open();

try

{

//执行删除语句

SqlCommand cmd = new SqlCommand(sql, conn);

int delcount = Convert.ToInt32(cmd.ExecuteNonQuery());

Response.Write("alert('共删除" + delcount + "条数据');");

SetDataBinder();

}

catch (Exception ex)

{

Response.Write(ex.Message);

}

finally

{

conn.Close();

}

}

///

/// 反选操作

///

///

///

protected void Button3_Click(object sender, EventArgs e)

{

CheckBox cb;

for (int i = 0; i < GridView1.Rows.Count; i++)

{

cb = (CheckBox)GridView1.Rows[i].Cells[0].FindControl("CheckBox1");

if (cb.Checked)

{

cb.Checked = false ;

}

else

{

cb.Checked = true ;

}

}

}