在asp中如何用一个button删除多条勾选的记录(gridview中的)?

[yaokaipeng]

请各位大侠给出cs中的代码,谢谢

[fffxcg]

循环逐条删除？？？
等待高手答案.....

[phommy]

逐条删肯定不如用in子句删... 不过我也不会-_-

[xbugirl]

string del = "";
把勾选的数据全扔进 del 里。然后
delete from 表 Where id in ("+del+")

[xray2005]

LZ,给你看看我的cs代码:
//删除选中按钮事件
protected void deleteSelectedBtn_Click(object sender, EventArgs e)
{
int intFlag=0;
for (int i = 0; i < this.ShowMailGridView.Rows.Count; i++)
{
GridViewRow row = this.ShowMailGridView.Rows[i];
HtmlInputCheckBox selectedChkbox=(HtmlInputCheckBox)row.FindControl("selectedchkbox") as System.Web.UI.HtmlControls.HtmlInputCheckBox;
if (selectedChkbox !=null && selectedChkbox.Checked)
{
int InfoId = Convert.ToInt32(selectedChkbox.Value);
intFlag = Mail.DeleteMail(InfoId);
}
}
if (intFlag > 0)
{
thisShowMailGridViewDataBind();
}

}
//删除全部按钮事件
protected void deleteAllBtn_Click(object sender, EventArgs e)
{
int intFlag = 0;
for (int i = 0; i < this.ShowMailGridView.Rows.Count; i++)
{
GridViewRow row = this.ShowMailGridView.Rows[i];
HtmlInputCheckBox selectedChkbox=(HtmlInputCheckBox)row.FindControl("selectedchkbox") as System.Web.UI.HtmlControls.HtmlInputCheckBox;
if(selectedChkbox !=null)
{
int InfoId = Convert.ToInt32(selectedChkbox.Value);
intFlag = Mail.DeleteMail(InfoId);
}
}
if (intFlag > 0)
{
thisShowMailGridViewDataBind();
}


}

[xray2005]

HTML,gridview中的ItemTemplate代码
<ItemTemplate>
<table border="0" cellpadding="0" cellspacing="0" width="100%" >
<tr align="left" style="font-weight:normal;font-size:9pt" valign="middle">
<td width="4%" align="center">
<input type="checkbox" id="selectedchkbox" value='<%#DataBinder.Eval(Container.DataItem,"InfoID") %>' runat="server" /></td>
<td width="4%" align="center> </td>
<td align="left" valign="middle" width="35%">
<a href="LookMail.aspx?MailId=<%#DataBinder.Eval(Container.DataItem,"MailID")%>" target="_self"><font color="#9933ff"><%DataBinder.Eval(Container.DataItem, "Subject")%></font></a>
</td>
<td align="center" valign="middle" width="15%">
<%#DataBinder.Eval(Container.DataItem,"UserID") %>
</td>
<td align="center" valign="middle" width="15%">
<%=ReceiversNamelbstring%>
</td>
<td align="center" valign="middle" width="15%">
<%#DataBinder.Eval(Container.DataItem, "SendDate", "{0:yyyy-MM-dd HH:mm}")%>
</td>

<td align="center" valign="middle" width="12%">

</td>
</tr>
</table>
</ItemTemplate>

[yaokaipeng]

谢谢各位,尤其是风车车,那么详细,偶也是四川的哈~~