返回首页

删除从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());

            }

        }

回答

评论会员: 时间:2
p