Question

如何在gridcontrol中删除焦点所在的行

若以下回答无法解决问题，邀请你更新回答

Answer 1

//删除单条记录
private void btnDelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
DialogResult dialogResult = MessageBox.Show("是否删除该记录？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (dialogResult==DialogResult.OK)
{
string taskNum = gvTask.GetFocusedRowCellValue("任务编号").ToString();
string connectionString = "Integrated Security=False;User ID=sa;Password=2630989;Initial Catalog=RDSS3;Server=.";
SqlConnection con = new SqlConnection(connectionString);
string deleteString = "delete from dbo.ExpTask where TaskNum='" + taskNum + "'";
SqlCommand cmd = new SqlCommand(deleteString, con);
con.Open();
cmd.ExecuteNonQuery();
gvTask.DeleteRow(gvTask.FocusedRowHandle);
}
else
{
return;
}

}