62,243
社区成员




/// <summary>
/// 删除选中行数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnDel_Click(object sender, EventArgs e)
{
string name = Convert.ToString(mainView.SelectedRows[0].Cells[1].Value);
if (MessageBoxEx.Show("确认是否删除选中员工资料?", "警告:操作需谨慎。本条资料一旦删除将不可恢复!", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.No)
{
return;
}
DialogResult result = MessageBoxEx.Show("请再次确认是否删除员工【" + name + "】的资料?", "警告:操作需谨慎。本条资料一旦删除将不可恢复!", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
switch (result)
{
case DialogResult.Yes:
for (int i = this.mainView.SelectedRows.Count; i > 0; i--)
{
string p_no = Convert.ToString(mainView.SelectedRows[i - 1].Cells[0].Value);
//string name = Convert.ToString(mainView.SelectedRows[i - 1].Cells[1].Value);
mainView.Rows.RemoveAt(mainView.SelectedRows[i - 1].Index);
//使用获得的p_no删除数据库的数据
string SQL =string.Format( "delete from Rperson where p_no='{0}'", p_no);
int s = Convert.ToInt32(Execute(SQL)); //Execute()是类中的一个方法
if (s != 0)
{
MessageBox.Show("成功删除选中行数据!员工【" + name + "】资料已被移除!", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
ConnectToDatabase();//删除后刷新datagridview
}
break;
case DialogResult.No:
break;
}
}
<asp:Button ID="btnDelete" runat="server" CausesValidation="false" Text="删除" CommandName="Delete"
CommandArgument='<%# DataBinder.Eval(Container.DataItem, "ID").ToString()%>'
OnClientClick="return closeme()" />
之后在后台的uxGrid_RowCommand事件中
protected void uxGrid_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName != "Page")
{
if (e.CommandName == "Delete")
{
//需要删除的操作
ScriptHelper.MsgBox(this.Page, "删除成功!");
this.BindGridData(ID);
}
}
}
就是这么简单