public void execute() { // save lai data data = ((DataRowView)binding.Current).Row.ItemArray; // thuc thi delet binding.RemoveCurrent(); // delete }
private void btHuy_Click(object sender, EventArgs e) { if (bsMain.Current == null) { return; } _data.Cancel(drCurrent["MT62ID"].ToString()); bsMain.RemoveCurrent(); }
private void button3_Click(object sender, EventArgs e) { if (MessageBox.Show("هل تريد الحذف", "تحذير", MessageBoxButtons.YesNo) == DialogResult.Yes) { OleDbCommandBuilder cb = new OleDbCommandBuilder(da); bs.RemoveCurrent(); da.DeleteCommand = cb.GetDeleteCommand(); da.Update(ds, "mor"); } }
/// <summary> /// When moving to the next/previous item, check if there are changes, save them and then move to the next record /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void StudyDetails_MouseWheel(object sender, MouseEventArgs e) { bs.EndEdit(); if (IsEmptyRecord(CurrentStudy)) { bs.RemoveCurrent(); return; } if (SaveRecord() == 1) { MessageBox.Show("Unable to save current record. Ensure all fields are filled."); return; } if (e.Delta == -120) { MoveRecord(1); } else if (e.Delta == 120) { MoveRecord(-1); } }
private void ClearData() { int addedRow = gvOrderDetail.DataRowCount; for (int i = 0; i < addedRow; i++) { _bdsCTDDH.RemoveCurrent(); } txtOrderId.EditValue = null; lkeDepot.EditValue = null; cboNCC.SelectedIndex = -1; }
private void supprimerToolStripMenuItem_Click(object sender, EventArgs e) { if (srcb.Current != null) { if (MessageBox.Show("Voulez-vous supprimer cette fonction?", "Cofirmation de suppression", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { try { DataRowView drv = (DataRowView)srcb.Current; string res = CLIENT_APP_PARAM.gcws.DELETE_FONCTION(drv["CODE_FONCTION"].ToString()); if (res == "OK") { srcb.RemoveCurrent(); dt.AcceptChanges(); } else { MessageBox.Show(res, "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception er) { MessageBox.Show(er.Message, "Connexion serveur", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
// TODO finish private void DeleteQuestion() { if (MessageBox.Show(CurrentQuestion.VarName + " will be deleted from " + CurrentSurvey.SurveyCode + ". \r\n Do you want to proceed?", "Confirm Delete", MessageBoxButtons.YesNo) == DialogResult.Yes) { int nextID = bs.Position; // backup comments DBAction.BackupComments(CurrentQuestion.ID); // delete question from database DBAction.DeleteQuestion(CurrentQuestion.VarName.FullVarName, CurrentQuestion.SurveyCode); // remove question from the list CurrentSurvey.Questions.Remove(CurrentQuestion); // remove current item from bindingsource bs.RemoveCurrent(); // refresh comments // delete varname if no more uses Renumber = true; } else { return; } if (MessageBox.Show("Do you want to document this deletion? (Click 'No' if you already have)", "Document", MessageBoxButtons.YesNo) == DialogResult.Yes) { } else { } }
/// <summary> /// Remove the current row /// </summary> /// <param name="sender"></param> /// <param name="e"></param> /// <remarks></remarks> private void RemoveCurrentCustomerButton_Click(object sender, EventArgs e) { if (_bsCustomers.DataSource == null) { MessageBox.Show("Please select some data"); return; } if (Question("Remove " + _bsCustomers.CurrentRow().CompanyName())) { if (!_dataOperations.RemoveCustomer(_bsCustomers.CurrentRow().Identifier())) { if (!_dataOperations.IsSuccessFul) { MessageBox.Show($"Failed to remove customer{Environment.NewLine}{_dataOperations.LastExceptionMessage}"); } } else { // // Only remove row if removed successfully from the database table // _bsCustomers.RemoveCurrent(); } } }
private void removeSourceButton_Click(object sender, EventArgs e) { if (pathBindingSource.Current != null) { DialogResult result = MessageBox.Show("This will remove from Moving Pictures all movies retrieved from this import path, are you sure?", "Warning!", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { // stop the importer MovingPicturesCore.Importer.Stop();; // remove the import path ((DBImportPath)pathBindingSource.Current).Delete(); pathBindingSource.RemoveCurrent(); // clean the database of the old movies using our progress bar popup ProgressPopup progressPopup = new ProgressPopup(new WorkerDelegate(DatabaseMaintenanceManager.RemoveInvalidFiles)); DatabaseMaintenanceManager.MaintenanceProgress += new ProgressDelegate(progressPopup.Progress); progressPopup.Owner = ParentForm; progressPopup.Text = "Removing related movies..."; progressPopup.ShowDialog(); // restart the importer MovingPicturesCore.Importer.RestartScanner(); } } }
void grid_KeyDown(object sender, KeyEventArgs e) { DataGridView grid = (DataGridView)sender; if (e.Control && e.KeyCode.Equals(Keys.Enter)) { if (openDetailEvent != null) { openDetailEvent(); } } else if (e.Control && e.KeyCode.Equals(Keys.Delete)) { BindingSource bs = (BindingSource)grid.DataSource; if (bs.Current != null) { //TODO if (MessageBox.Show("Are you sure to delete " + bs.Current.ToString(), "Delete", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { bs.RemoveCurrent(); } } } }
private void supprimerToolStripMenuItem_Click(object sender, EventArgs e) { if (srcb_fournisseur.Current != null) { if (MessageBox.Show("Voulez vous confirmer la suppression?", "Suppression", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { Application.DoEvents(); DataRowView drv = (DataRowView)srcb_fournisseur.Current; //string res = CLIENT_APP_PARAM.GEST.P_FOURNISSEUR.DELETE_FOURNISSEUR(drv["CODE_FOURNISSEUR"].ToString()); string res = CLIENT_APP_PARAM.gcws.DELETE_FOURNISSEUR(drv["CODE_FOURNISSEUR"].ToString()); if (res == "OK") { MessageBox.Show("La suppression du fournisseur à été effectuée avec succes.", "Suppression du fournisseur" + drv["CODE_FOURNISSEUR"].ToString(), MessageBoxButtons.OK, MessageBoxIcon.Information); srcb_fournisseur.RemoveCurrent(); tab_fournisseur.AcceptChanges(); } else { MessageBox.Show(res, "Suppression du fournisseur" + drv["CODE_FOURNISSEUR"].ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception er) { MessageBox.Show(er.Message, "Connexion serveur", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
private void TsbRuleDeleteClick(object sender, EventArgs e) { using (DeleteControlForm deleteControlForm = new DeleteControlForm()) { deleteControlForm.Message = "Deseja apagar a regra selecionada?"; if (deleteControlForm.ShowDialog() == DialogResult.OK) { DataRowView currentRule = _bsRule.Current as DataRowView; _bsRule.RemoveCurrent(); _bsRule.EndEdit(); if (deleteControlForm.checkBox1.Checked) { DataRow currentRl = _dsSecurity.Tables["Rule"].Rows.Find(currentRule["Name"]); currentRl.Delete(); _dsSecurity.Tables["Rule"].AcceptChanges(); } else { DataRow currentGrpRl = _dsSecurity.Tables["GrpRl"].Rows.Find(new object[] { currentRule["GroupName"], currentRule["Name"] }); currentGrpRl.Delete(); _dsSecurity.Tables["GrpRl"].AcceptChanges(); } } } }
private void TsbGroupDeleteClick(object sender, EventArgs e) { using (DeleteControlForm deleteControlForm = new DeleteControlForm()) { deleteControlForm.Message = "Deseja apagar o grupo selecionado?"; if (deleteControlForm.ShowDialog() == DialogResult.OK) { DataRowView currentGroup = _bsGroup.Current as DataRowView; _bsGroup.RemoveCurrent(); _bsGroup.EndEdit(); if (deleteControlForm.checkBox1.Checked) { DataRow currentGrp = _dsSecurity.Tables["Group"].Rows.Find(currentGroup["Name"]); currentGrp.Delete(); _dsSecurity.Tables["Group"].AcceptChanges(); } else { DataRow currentUsrGrp = _dsSecurity.Tables["UsrGrp"].Rows.Find(new object[] { currentGroup["UserName"], currentGroup["Name"] }); currentUsrGrp.Delete(); _dsSecurity.Tables["UsrGrp"].AcceptChanges(); } } } }
private void ButtonDeleteRowClick(object sender, EventArgs e) { if (_bindingSource.Current != null && _bindingSource.AllowRemove) { _bindingSource.RemoveCurrent(); } }
public static bool Delete(IDbDataAdapter adapter, DataSet ds, BindingSource bds) { try { if (Mensagem.Pergunta(null, "Deseja realmente deletar o registro corrente?", DialogResult.No)) { return(false); } bds.RemoveCurrent(); bds.EndEdit(); adapter.Update(ds); ds.Clear(); adapter.Fill(ds); bds.DataSource = ds; bds.DataMember = ds.Tables[0].TableName; Commit(); return(true); } catch (Exception ex) { Mensagem.Excecao(null, "Erro ao deletar o registro corrente.", ex); RefreshData(adapter, ds, bds); return(false); } }
public static void RemoveSelected(this BindingSource bindingSource) { if (bindingSource.HasValue()) { bindingSource.RemoveCurrent(); } }
private void gridView1_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e) { if (e.Column.Name == "colSuppr" && bsPaiement.Current != null) { bsPaiement.RemoveCurrent(); } }
private void btnSupp_Click(object sender, EventArgs e) { if (MessageBox.Show("Voulez-vous Supprimer?", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { bs.RemoveCurrent(); } }
private void btnDelete_Click(object sender, EventArgs e) { if (MessageBox.Show("คุณต้องการลบหรือไม่?", "ยืนยันการลบ", MessageBoxButtons.YesNo) == DialogResult.Yes) { bs.RemoveCurrent(); //ds.Tables["ProductAreana"].Rows[num].Delete(); if (num < ds.Tables["Custormer"].Rows.Count - 1) { num++; } else { if (num != 0) { num--; } else { clearFrom(); } } String sql; conn.Open(); sql = "DELETE FROM Custormer WHERE ID_Customer = '" + txtID.Text + "'"; comm.CommandText = sql; comm.ExecuteNonQuery(); conn.Close(); } }
private void btnXoaDong_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (bds.Count > 0) { bds.RemoveCurrent(); } else { return; } //Console.WriteLine(bds.Count); //Console.WriteLine(dt.Rows.Count); //Console.WriteLine(gv_SINHVIENTHEM.DataRowCount); //for (int i = 0; i < gv_SINHVIENTHEM.DataRowCount; i++) //{ // DataRow row = dt.NewRow(); // foreach (GridColumn column in gv_SINHVIENTHEM.VisibleColumns) // { // row[column.FieldName] = gv_SINHVIENTHEM.GetRowCellValue(i, column); // if (column.FieldName.Equals("PHAITHEM") && row[column.FieldName].ToString().Equals("") || // column.FieldName.Equals("NGHIHOCTHEM") && row[column.FieldName].ToString().Equals("")) // { // row[column.FieldName] = false; // } // gv_SINHVIENTHEM.FocusedColumn = gv_SINHVIENTHEM.VisibleColumns[9]; // Console.WriteLine(row[column.FieldName]); // } //} }
public override void MergeID() { if (bdsDoiTuong.Count <= 0) { return; } drCurrent = ((DataRowView)bdsDoiTuong.Current).Row; string strOldValue = (string)drCurrent["Ma_Dt"]; frmMergeID frm = new frmMergeID(); frm.Load("LIDOITUONG", "Ma_Dt", "Ten_Dt", strOldValue, "DoiTuong"); if (frm.isAccept) { string strNewValue = frm.strNewValue; string strMsg = Element.sysLanguage == enuLanguageType.English ? "Are you sure to merge " + strOldValue + " to " + strNewValue + " ?" : "Bạn có muốn gộp mã " + strOldValue + " sang " + strNewValue + " không ?"; if (!Common.MsgYes_No(strMsg)) { return; } if (DataTool.SQLMergeID("Ma_Dt", "LIDOITUONG", strOldValue, strNewValue)) { bdsDoiTuong.RemoveCurrent(); bdsDoiTuong.Position = bdsDoiTuong.Find("MA_DT", strNewValue); } } }
private void BTN_SUPPRIMER_Click(object sender, EventArgs e) { if (bs.Current != null) { if (MessageBox.Show("Etes vous sûres de supprimer cet article?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { //CHM_GESTION_COMERCIALE.RESULT_QUERY res; CHMGC.RESULT_QUERY res; try { DataRowView drv = (DataRowView)bs.Current; Application.DoEvents(); //res = CLIENT_APP_PARAM.GEST.P_ARTICLE.DELETE_ARTICLE(drv["CODE_ARTICLE"].ToString()); res = CLIENT_APP_PARAM.gcws.DELETE_ARTICLE(drv["CODE_ARTICLE"].ToString()); if (res.OK) { bs.RemoveCurrent(); dt.AcceptChanges(); } else { MessageBox.Show(res.MESSAGE, "Attention", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception er) { MessageBox.Show(er.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
void gridControl1_KeyUp(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.F8) { bs.RemoveCurrent(); } }
//【二、当系统读取到条形码开始将商品加入购物车】 //1.如果购物车中没有该商品,在购物车中新建一栏加入 //2.如果购物车中该商品已经存在了,直接改变购物车中该商品的数量 private void TxtProductId_KeyDown(object sender, KeyEventArgs e) { //在键盘按下事件中,必须要判断按下的功能键是什么 //【1】按下回车进行商品编号的录入,进入商品添加功能 if (e.KeyCode == Keys.Enter) { BindProduct(); } //【2】按上移动 else if (e.KeyCode == Keys.Up) { if (dgvProductList.RowCount == 0 || dgvProductList.RowCount == 1) { return; } bs.MovePrevious(); } //【3】按下移动 else if (e.KeyCode == Keys.Down) { if (dgvProductList.RowCount == 0 || dgvProductList.RowCount == 1) { return; } bs.MoveNext(); } //【4】按下Del键移除 else if (e.KeyCode == Keys.Delete) { if (dgvProductList.RowCount == 0) { return; } bs.RemoveCurrent(); //问题:1.数据表要刷新 //问题:2.更新序号 dgvProductList.DataSource = null; dgvProductList.DataSource = bs; } //【5】按下的是A键开始结算 else if (e.KeyCode == Keys.A) { if (dgvProductList.RowCount == 0) { return; } else { Balance(); } } //【6】按下的是退出系统按键 else if (e.KeyCode == Keys.Escape) { if (MessageBox.Show("是否确认关闭系统", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { this.Close(); } } }
private void tsRemove_Click(object sender, EventArgs e) { if (bs.Count > 0) { bs.RemoveCurrent(); } }
public override void MergeID() { if (bdsViTri.Count <= 0) { return; } drCurrent = ((DataRowView)bdsViTri.Current).Row; string strOldValue = (string)drCurrent["MA_VITRI"]; Epoint.Lists.frmMergeID frm = new Epoint.Lists.frmMergeID(); frm.Load("HRVITRI", "MA_VITRI", "Ten_Km", strOldValue, "ViTri"); if (frm.isAccept) { string strNewValue = frm.strNewValue; string strMsg = Element.sysLanguage == enuLanguageType.English ? "Do you want to merge " + strOldValue + " to " + strNewValue + " ?" : "Bạn có muốn gộp mã " + strOldValue + " sang " + strNewValue + " không ?"; if (!Common.MsgYes_No(strMsg)) { return; } if (DataTool.SQLMergeID("MA_VITRI", "HRVITRI", strOldValue, strNewValue)) { bdsViTri.RemoveCurrent(); bdsViTri.Position = bdsViTri.Find("MA_VITRI", strNewValue); } } }
private void toolStripMenuItem1_Click(object sender, EventArgs e) { if (bs.Current != null) { if (MessageBox.Show("Voulez vous confirmer la supression ?", "Supression", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { //CHM_GESTION_COMERCIALE.RESULT_QUERY res; CHMGC.RESULT_QUERY res; try { DataRowView drv = (DataRowView)bs.Current; Application.DoEvents(); //res = CLIENT_APP_PARAM.GEST.P_MAGAZIN.DELETE_MAGAZIN(drv["CODE_MAG"].ToString()); res = CLIENT_APP_PARAM.gcws.DELETE_MAGAZIN(drv["CODE_MAG"].ToString()); if (res.OK) { bs.RemoveCurrent(); dt.AcceptChanges(); } else { MessageBox.Show(res.MESSAGE, "Attention", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception er) { MessageBox.Show(er.Message, "Connexion serveur", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
private void TsbDeleteClick(object sender, EventArgs e) { if (MessageBox.Show("Confirma?", "Atenção", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { _bsTagList.RemoveCurrent(); } }
public override void MergeID() { if (bdsEmployee.Count <= 0) { return; } drCurrent = ((DataRowView)bdsEmployee.Current).Row; string strOldValue = (string)drCurrent["Ma_CbNv"]; frmMergeID frm = new frmMergeID(); frm.Load("LINHANVIEN", "Ma_CbNv", "Ten_CbNv", strOldValue, "DMCBNV"); if (frm.isAccept) { string strNewValue = frm.strNewValue; string strMsg = Element.sysLanguage == enuLanguageType.English ? "Do you want to merge " + strOldValue + " to " + strNewValue + " ?" : "Bạn có muốn gộp mã " + strOldValue + " sang " + strNewValue + " không ?"; if (!Common.MsgYes_No(strMsg)) { return; } if (DataTool.SQLMergeID("Ma_CbNv", "LINHANVIEN", strOldValue, strNewValue)) { bdsEmployee.RemoveCurrent(); bdsEmployee.Position = bdsEmployee.Find("Ma_CbNv", strNewValue); } } }
private void btnDelete_Click(object sender, EventArgs e) { if (dataBindingSource.Current != null) { dataBindingSource.RemoveCurrent(); } }