private void Button1_Click(object sender, System.EventArgs e)
{
DataGridItem GridItem;
DataRow GridRow;
for(int i=0;i<DataGrid1.Items.Count-1;i++)
{
GridItem=DataGrid1.Items[i];
CheckBox Find_Box=GridItem.FindControl("CheckBox1");
if(Find_Box.Checked)
{
SqlConnection Recive_Conn = new SqlConnection("server=localhost;uid=sa;pwd=;database=mail");
string new_Recive_Sql;
new_Recive_Sql="Delete email Where id="+(int)GridItem.Cells[0].Text;
Recive_Conn.Open();
SqlCommand Recive_Command = new SqlCommand(new_Recive_Sql,Recive_Conn);
Recive_Command.ExecuteNonQuery();
Recive_Conn.Close();
}
}
BinData();
}
{
DataGridItem GridItem;
DataRow GridRow;
for(int i=0;i<DataGrid1.Items.Count-1;i++)
{
GridItem=DataGrid1.Items[i];
CheckBox Find_Box=GridItem.FindControl("CheckBox1");
if(Find_Box.Checked)
{
SqlConnection Recive_Conn = new SqlConnection("server=localhost;uid=sa;pwd=;database=mail");
string new_Recive_Sql;
new_Recive_Sql="Delete email Where id="+(int)GridItem.Cells[0].Text;
Recive_Conn.Open();
SqlCommand Recive_Command = new SqlCommand(new_Recive_Sql,Recive_Conn);
Recive_Command.ExecuteNonQuery();
Recive_Conn.Close();
}
}
BinData();
}
和
new_Recive_Sql="Delete email Where id="+(int)GridItem.Cells[0].Text;
这2句
aspx<script language="javascript">
<!--function select_all()
{
for (var i=0;i<frmMain.elements.length ;i++)
if(frmMain.elements[i].name=="selItem")
frmMain.elements[i].checked=true
}function getDelId(){
var length=document.all.selItem.length;
if(document.all.selItem.checked){
document.all.selId.value+="'"+document.all.selItem.value+"',";
}
else{
for(i=0;i<length;i++){
if(document.all.selItem[i].checked){
document.all.selId.value+="'"+document.all.selItem[i].value+"',";
}
}
}
if(!window.confirm("确实要删除这些信息吗?"))
document.all.selId.value="";
}
//-->
</script><asp:TemplateColumn HeaderText="操作">
<HeaderStyle HorizontalAlign="Center" Width="50px"></HeaderStyle>
<ItemTemplate>
<input type="checkbox" name="selItem" value='<%# DataBinder.Eval(Container.DataItem,"ID") %>'>
</ItemTemplate>
</asp:TemplateColumn><input type="button" height="5" value="全选" name="selectall" onClick="return select_all()">
<input type="reset" name="Reset" value="取消选择">
<asp:button id="btnDel" runat="server" Text="删除选中"></asp:button>
<INPUT id="selId" type="hidden" runat="server" NAME="selId">cs处理部分
private void Page_Load(object sender, System.EventArgs e)
{
if (!Page.IsPostBack)
{
btnDel.Attributes["onclick"] = "getDelId()";
RefreshGrid();
}
}private void dataGrid_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
dataGrid.CurrentPageIndex=e.NewPageIndex;
RefreshGrid();
}private void RefreshGrid()
{
string sqlStr = "select * from [Article] order by ID desc";
doData.bindDtatGrid(sqlStr,dataGrid);
}
private void btnDel_Click(object sender, System.EventArgs e)
{
string strWhere="'',"+selId.Value;
strWhere=strWhere.Substring(0,strWhere.Length-1);
string delStr = "delete from [Article] where ID in ("+strWhere+")";
doData.opData(delStr);
RefreshGrid();
}