asp.net实现批量删除实例

本文实例讲述了asp.net实现批量删除功能的方法。对于asp.net的学习有一定的参考价值。分享给大家供大家参考之用。具体实现方法入戏：

.aspx文件代码如下：

<asp:gridview id="gridview1" runat="server" width="100%" emptydatatext="暂时无数据" bordercolor="white" onrowdeleting="gridview1_rowdeleting">
<columns>
<asp:templatefield headertext="选择">
<itemstyle width="20px" />
    <itemtemplate>
      <asp:checkbox id="id" runat="server" />
    </itemtemplate>
  </asp:templatefield>
   <asp:boundfield datafield="id" headertext="序号" >
 <itemstyle width="20px" />
   </asp:boundfield>
   <asp:templatefield headertext="标题">
 <itemstyle width="400px" />
 <itemtemplate>
   <a href="../shangpu/<%#eval_r("pageurl") %>" target="_blank"><%#eval_r("title") %></a>
 </itemtemplate>
   </asp:templatefield>
   <asp:templatefield headertext="发表时间">
 <itemstyle width="100px" />
 <itemtemplate>
   <%# convert.todatetime(eval_r("addtime")).date.tostring("yyyy-mm-dd") %>
 </itemtemplate>
   </asp:templatefield>
   <asp:hyperlinkfield datanavigateurlformatstring="shangpu_edit.aspx?id={0}" text="修改" navigateurl="shangpu_edit.aspx?id={0}" datanavigateurlfields="id" >
 <itemstyle width="30px" />
   </asp:hyperlinkfield>
    <asp:commandfield showdeletebutton="true" headertext="删除" deletetext="<div id="de" onclick="javascript:return confirm('确定删除吗？')">删除</div>" >
 <itemstyle width="30px" />
   </asp:commandfield>
 </columns>
 <emptydatatemplate>
 <font color=red>暂时无数据</font>
 </emptydatatemplate>
<rowstyle height="20px" />
  </asp:gridview>
 

.cs 文件代码如下：

protected void btndeleteall_click(object sender, eventargs e)
{
string sqltext = "(";
for (int i = 0; i < gridview1.rows.count; i++)
{
  checkbox chb = (checkbox)gridview1.rows[i].findcontrol("id");
  if (chb.checked)
  {
 sqltext = sqltext + gridview1.datakeys[i].value.tostring() + ",";
  }
}
sqltext = sqltext.substring(0, sqltext.length - 1) + ")";
sqltext = "delete from shangpu where id in" + sqltext;
string sqlcon = configurationmanager.appsettings["connectionstring"].tostring();
sqlconnection con = new sqlconnection(sqlcon);
con.open();
sqlcommand cmd = new sqlcommand(sqltext, con);
try
{
  int count = convert.toint32(cmd.executenonquery());
  if (count > 0)
  {
 viewbind();
 messagebox.show(this, "删除成功,共删除" + count + "条记录！");
  }
}
catch
{
  messagebox.show(this, "删除失败！");
}
finally
{
  con.close();
  con.dispose();
}
}

感兴趣的朋友可以调试运行一下本文实例，学有余力的朋友还可以对代码作出改进以完善其功能。希望本文实例对大家的asp.net学习有一定的帮助作用。