//全选
protected void CheckBox2_CheckedChanged(object sender, EventArgs e)
{
for (int i = 0; i <= GridView1.Rows.Count-1;i++ )
{
CheckBox cbox = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1");
if (CheckBox2.Checked == true)
{
cbox.Checked = true;
}
else
{
cbox.Checked = false;
}
}
}
//全部删除
protected void btnAllDelete_Click(object sender, EventArgs e)
{
for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
{
CheckBox cbox = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1");
if (cbox.Checked == true)
{
string sqlstr = "delete from tb_Member where MemberID='"+GridView1.DataKeys[i].Value+"'";
SqlConnection myConn = GetConnection();
SqlCommand myCmd = new SqlCommand(sqlstr, myConn);
myConn.Open();
myCmd.ExecuteNonQuery();
myConn.Close();
}
}
bind();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
CheckBox2.Checked = false;
string sqlstr = "delete from tb_Member where MemberID=" + Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString());
SqlConnection myConn = GetConnection();
SqlCommand myCmd = new SqlCommand(sqlstr, myConn);
myConn.Open();
myCmd.ExecuteNonQuery();
myConn.Close();
bind();
}