【gridview】asp.net gridview实现全选 反选与删除记录的操作代码-全选-反选-删除记录

欢迎您访问我爱IT技术网，今天小编为你分享的编程技术是：【asp.net gridview实现全选,反选与删除记录的操作代码】，下面是详细的讲解！

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

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();
}
/// <summary>
/// 全选记录
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
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;
}
}
/// <summary>
/// 执行删除操作,删除所选择的项
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
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("<script>alert('共删除" + delcount + "条数据');</script>");
SetDataBinder();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
conn.Close();
}
}
/// <summary>
/// 反选操作
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
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 ;
}
}
}

关于asp.net gridview实现全选,反选与删除记录的操作代码的用户互动如下：

　　相关问题：

　　答： >>详细

　　相关问题：

　　答： >>详细

　　相关问题：

　　答： >>详细