删除从DataGridView选定行:
嗨,任何人都可以从DataGridView中删除选定的行(多选)ahare代码片段。我要检查是否已登录的用户添加的项目将被删除之前删除
提前感谢
private void btnDelete_Click(object sender, EventArgs e)
{
dgDtParameters.AllowUserToDeleteRows = true;
System.Data.DataTable objDt = new System.Data.DataTable();
DataRow objdrDelete;
DataSet dsAdmin = new DataSet();
try
{
objConnection = new DBAccess();
SqlParameter[] sqlparamAdmin = {
new SqlParameter("@accountID",iaccountID),
new SqlParameter("@projectID",iprojectID),
new SqlParameter("@componentID",icomponentID),
new SqlParameter("@createdBy",CCommonInfo.iUserID),
};
dsAdmin = objConnection.GetDataSet("prcDisplayAdmindataTemplate", sqlparamAdmin);
if (iRoleID == 1 || iRoleID == 2 || iRoleID == 3)
{
if (MessageBox.Show(CompCreatorMsg.Msg_DPDelete, CompCreatorMsg.Title_DPDelete, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
objDt = dsobbtemp.Tables[0];
objdrDelete = objDt.NewRow();
//if (objDt != null)
{
for (int i = 0; i < objDt.Rows.Count; i++)
{
objdrDelete["objectRevisedName"] = objDt.Rows[i]["objectRevisedName"].ToString();
srowFilter = "objectRevisedName = '" + objdr["objectRevisedName"].ToString() + "'";
if (dsAdmin.Tables[0].Select(srowFilter).Length == 0)
{
SqlParameter[] sqlparam = {
new SqlParameter("@objectID",Convert.ToString(objDt.Rows[i]["objectID"]))
};
iResults = objConnection.ExecuteCommand("prcDeleteDataTemplate", sqlparam);
}
}
}
objDt.Clear();
objDt.Dispose();
}
}
}
catch (Exception exGeneral)
{
MessageBox.Show(exGeneral.Message + exGeneral.StackTrace.ToString());
}
}