在DataGrid中，实行多选删除操作：在模板列中添加CheckBox工具即可
在后台代码中可以这样写：
/// <summary>
/// 删除所选车辆信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button2_Click(object sender, EventArgs e) //Button2这是删除按钮
{
foreach (DataGridItem dele in this.dgCar.Items)
{
CheckBox cb = (CheckBox)dele.FindControl("CheckBox1");
if (cb.Checked)
{
///执行删除方法就可以了
int i_ID = int.Parse(dele.Cells[0].Text);//表中位置id获得
SYJ.sqlServer corp_list_del = new SYJ.sqlServer(SYJ.common.gDbConnStr(""));
string del_sql = "delete from Ai_ObjComm where ID=" + i_ID;
corp_list_del.sqlInsertUpdateDelete(del_sql);
}
}
SYJ.common.msgBox(this, "所选车辆删除成功！");
this.car_infor_bind();
}
当然，可以为删除事件增加一个提示对话框：
就在Pageload事件的!Page.postback补充一句即可: this.btDel.Attributes.Add("OnClick", "javascript:return confirm('确认要删除吗？')");
2、DataGrid的删除事件：
protected void DataGrid1_DeleteCommand(object source, DataGridCommandEventArgs e)
{
int i = int.Parse(this.dg1.Items[e.Item.ItemIndex].Cells[0].Text);
SYJ.sqlServer del = new SYJ.sqlServer(SYJ.common.gDbConnStr(""));
string del_sql = "delete from Gps_User_List where User_ID=" + i;
if (del.sqlInsertUpdateDelete(del_sql) > 0)
{
SYJ.common.msgBox(this, "你已经删除用户" + this.dg1.Items[e.Item.ItemIndex].Cells[1].Text);
}
else
{
SYJ.common.msgBox(this, "删除失败");
}
this.user_bind();
}
3、删除确认对话框：
protected void DataGrid1_ItemCreated(object sender, DataGridItemEventArgs e)
{
switch (e.Item.ItemType)
{
case ListItemType.Item:
case ListItemType.AlternatingItem:
case ListItemType.EditItem:
TableCell myTableCell;
myTableCell = e.Item.Cells[10];
LinkButton myDeleteButton;
myDeleteButton = (LinkButton)myTableCell.Controls[0];
myDeleteButton.Attributes.Add("onclick", "return confirm('您是否确定要删除此用户吗？');"); break;
default: break;
}
}
4、DataGrid的选择事件：
private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
{
this.TextBox1.Text=this.DataGrid1.Items[this.DataGrid1.SelectedIndex].Cells[6].Text;
this.Label1.Text=this.DataGrid1.Items[this.DataGrid1.SelectedIndex].Cells[0].Text;
}
5、DataGrid的分页事件：
protected void DataGrid1_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
{
this.dg1.CurrentPageIndex = e.NewPageIndex;
this.user_bind();
}
6、//DataGrid的更新事件
private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
int a_id=int.Parse(this.DataGrid1.Items[e.Item.ItemIndex].Cells[0].Text);获取修改id号
string pwd=this.DataGrid1.Items[e.Item.ItemIndex].Cells[2].Text;//原密码
TextBox Admin_name_txt=(TextBox)e.Item.Cells[1].Controls[0];
Admin_name_txt.Width=100;
TextBox Admin_pwd_txt=(TextBox)e.Item.Cells[2].Controls[0];
TextBox Admin_right_txt=(TextBox)e.Item.Cells[3].Controls[0];
Admin_right_txt.Width=50;
string Admin_name=Admin_name_txt.Text;
string Admin_pwd=WebTools.WebTools.EncryptPassword(Admin_pwd_txt.Text,"MD5");
string Admin_right=Admin_right_txt.Text;
BusinessEntity.CAdmin c_admin=new BusinessEntity.CAdmin();
c_admin.A_id=a_id;
c_admin.Admin_name=Admin_name;
c_admin.Admin_right=Convert.ToInt32(Admin_right);
BusinessLogic.CAdmin ca_admin=new BusinessLogic.CAdmin();
if(ca_admin.update_Admin(c_admin)>0)
{
WebTools.WebTools.MessageBox("恭喜你，修改成功");
}
else
{
WebTools.WebTools.MessageBox("对不起，系统忙！");
}
this.DataGrid1_CancelCommand(null,null);
}
7、//DataGrid中的(编辑)取消事件
private void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
this.DataGrid1.EditItemIndex=-1;
this.Admin_Bind();
}
8、//DataGrid中的编辑事件
private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
this.DataGrid1.EditItemIndex=e.Item.ItemIndex;
this.Admin_Bind();
}