public void TestDeleteNotAllowed() { DataView TestView = new DataView(dataTable); TestView.AllowDelete = false; TestView.Delete(0); }
public void RowStateFilter_2() { DataSet dataset = new DataSet("new"); DataTable dt = new DataTable("table1"); dataset.Tables.Add(dt); dt.Columns.Add("col1"); dt.Columns.Add("col2"); dt.Rows.Add(new object [] { 1, 1 }); dt.Rows.Add(new object [] { 1, 2 }); dt.Rows.Add(new object [] { 1, 3 }); dataset.AcceptChanges(); DataView dataView = new DataView(dataset.Tables [0]); // 'new' table in this sample contains 6 records dataView.AllowEdit = true; dataView.AllowDelete = true; string v; // Editing the row dataView [0] ["col1"] = -1; dataView.RowStateFilter = DataViewRowState.ModifiedOriginal; v = dataView [0] [0].ToString(); AssertEquals("ModifiedOriginal.Count", 1, dataView.Count); AssertEquals("ModifiedOriginal.Value", "1", v); // Deleting the row dataView.Delete(0); dataView.RowStateFilter = DataViewRowState.Deleted; v = dataView [0] [0].ToString(); AssertEquals("Deleted.Count", 1, dataView.Count); AssertEquals("Deleted.Value", "1", v); }
public void TestDeleteOutOfBounds() { Assert.Throws <IndexOutOfRangeException>(() => { DataView TestView = new DataView(_dataTable); TestView.Delete(100); }); }
private void удалеиеЗаписиToolStripMenuItem_Click(object sender, EventArgs e) { if (MessageBox.Show("Вы действительно хотите удалить набор " + (currentRow + 1) + "?", "Удаление", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.Yes) { isChangesSaved = false; dv1.Delete(currentRow); } }
/// <summary> /// Deletes a record from the movie table by a composite primary key. /// </summary> public void Delete(string id) { _dataView.RowFilter = $"Id='{id}'"; _dataView.Sort = "Id"; _dataView.Delete(0); _dataView.RowFilter = ""; Save(); }
private void MN_SIL_Click(object sender, EventArgs e) { int[] GETROW = GRDW_HAKLARI.GetSelectedRows(); for (int i = GETROW.Length - 1; i >= 0; i--) { dv_DAHIL_KULLANICILAR.Delete(Convert.ToUInt16(GETROW[i])); } }
private void удалитьЗаписьToolStripMenuItem_Click(object sender, EventArgs e) { if (MessageBox.Show("Вы действительно хотите удалить информацию этого автора?", "Удаление данных", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.Yes) { isChangesSaved = false; dv1.Delete(currentRow); } }
/// <summary> /// Deletes a record from the Category table by a composite primary key. /// </summary> public static void Delete(string id) { dv.RowFilter = "id='" + id + "'"; //dv.Sort = "id"; dv.Delete(0); dv.RowFilter = ""; save(); }
/// <summary> /// Deletes a record from the Category table by a composite primary key. /// </summary> public static void Delete(Guid guid) { dv.RowFilter = "guid='" + guid + "'"; dv.Sort = "guid"; dv.Delete(0); dv.RowFilter = ""; Save(); }
private void InitializeManualCode() { var SecurityPermissionRequired = new List <string>(); SecurityPermissionRequired.Add(TSecurityChecks.SECURITYPERMISSION_FINANCEREPORTING); FPetraUtilsObject.ApplySecurity(SecurityPermissionRequired); // remove from the combobox all ledger numbers which the user does not have permission to access DataView cmbLedgerDataView = (DataView)cmbLedger.cmbCombobox.DataSource; for (int i = 0; i < cmbLedgerDataView.Count; i++) { string LedgerNumberStr; // postgresql if (cmbLedgerDataView[i].Row[0].GetType().Equals(typeof(int))) { LedgerNumberStr = ((int)cmbLedgerDataView[i].Row[0]).ToString("0000"); } else // sqlite { LedgerNumberStr = ((Int64)cmbLedgerDataView[i].Row[0]).ToString("0000"); } if (!UserInfo.GUserInfo.IsInModule("LEDGER" + LedgerNumberStr)) { cmbLedgerDataView.Delete(i); i--; } } FPetraUtilsObject.SetStatusBarText(grdDetails, Catalog.GetString("Use the mouse or navigation keys to select a data row to view")); // set the currency code to be blank initially txtGiftTotal.CurrencyCode = String.Empty; txtGiftTotal.NumberValueDecimal = 0.0m; lblRecordCounter.Text = ""; pnlPostedOnlyNote.Top = 0; // correct the tab indexes int TabOrder = dtpDateFrom.TabIndex; dtpDateFrom.TabIndex = txtRecipient.TabIndex; txtRecipient.TabIndex = TabOrder; cmbMotivationGroup.RemoveDescriptionLabel(); cmbMotivationDetail.RemoveDescriptionLabel(); // catch enter on all controls, to trigger search this.KeyDown += new System.Windows.Forms.KeyEventHandler(this.CatchEnterKey); // catch enter on grid to view the selected transaction this.grdDetails.EnterKeyPressed += new Ict.Common.Controls.TKeyPressedEventHandler(this.ViewTransaction); // focus on txtDonor this.ActiveControl = txtDonor; }
public string GetComponent(string BuildingID, string Location_Renamed) { string str = Conversions.ToString(-1); try { this.dtComponents = mdUtility.DB.GetDataTable("SELECT System_Component.[SYS_COMP_ID], RO_Component.COMP_DESC FROM RO_Component INNER JOIN (Building_System INNER JOIN System_Component ON Building_System.[BLDG_SYS_ID] = System_Component.[SYS_COMP_BLDG_SYS_ID]) ON RO_Component.[COMP_ID] = System_Component.[SYS_COMP_COMP_LINK] WHERE (((System_Component.[SYS_COMP_ID]) Not In (SELECT [SYS_COMP_ID] FROM Components_by_location WHERE Components_by_location.[Facility_ID]={" + BuildingID + "} AND SAMP_DATA_LOC={" + Strings.Replace(mdUtility.fMainForm.tvInspection.GetNodeByKey(Location_Renamed).Tag.ToString(), "'", "''", 1, -1, CompareMethod.Binary) + "})) AND ((Building_System.[BLDG_SYS_BLDG_ID])={" + BuildingID + "}) AND ((System_Component.BRED_Status)<>'D' Or (System_Component.BRED_Status) Is Null)) ORDER BY RO_Component.COMP_DESC;"); if (this.dtComponents.Rows.Count == 0) { int num = (int)Interaction.MsgBox((object)"There are no components to attach. Please switch\rto the inventory screen and add them.", MsgBoxStyle.OkOnly, (object)"Attach Components to Inspection"); str = Conversions.ToString(-1); } else { UltraTreeNode nodeByKey = mdUtility.fMainForm.tvInspection.GetNodeByKey(Location_Renamed); if (nodeByKey.Nodes.Count > 0) { UltraTreeNode ultraTreeNode = nodeByKey.Nodes[0]; int count = nodeByKey.Nodes.Count; int num = 1; while (num <= count) { if (ultraTreeNode.Tag != null) { DataView dataView = new DataView(this.dtComponents); dataView.RowFilter = "[sys_comp_id]= '" + Strings.Replace(ultraTreeNode.Tag.ToString(), "'", "''", 1, -1, CompareMethod.Binary) + "'"; while (dataView.Count > 0) { dataView.Delete(0); } ultraTreeNode = ultraTreeNode.GetSibling(NodePosition.Next); } checked { ++num; } } } this.cboComponents.DisplayMember = "COMP_DESC"; this.cboComponents.ValueMember = "SYS_COMP_ID"; this.cboComponents.DataSource = (object)this.dtComponents; if (this.cboComponents.Items.Count == 0) { int num = (int)Interaction.MsgBox((object)"There are no components to attach. Please switch\rto the inventory screen and add them.", MsgBoxStyle.OkOnly, (object)"Attach Components to Inspection"); str = Conversions.ToString(-1); } else { int num = (int)this.ShowDialog(); str = !this.m_bUserCanceled ? this.m_strComponentID : Conversions.ToString(-1); } } } catch (Exception ex) { ProjectData.SetProjectError(ex); mdUtility.Errorhandler(ex, nameof(frmAttachComponent), nameof(GetComponent)); ProjectData.ClearProjectError(); } return(str); }
public void TestDeleteClosed() { Assert.Throws <IndexOutOfRangeException>(() => { DataView TestView = new DataView(_dataTable); TestView.Dispose(); // Close the table TestView.Delete(0); // cannot access to item at 0. }); }
public void TestDelete() { DataView TestView = new DataView(dataTable); TestView.Delete(0); DataRow r = TestView.Table.Rows [0]; Assertion.Assert("Dv #1", !((string)r ["itemId"] == "item 1")); }
public void TestDeleteNotAllowed() { Assert.Throws <DataException>(() => { DataView TestView = new DataView(_dataTable); TestView.AllowDelete = false; TestView.Delete(0); }); }
/// <summary> /// Deletes a project records and decendents, Stages, Events, EventAttributes by tracing the /// Project record's children and grandchildren and deleteing from bottom to top. /// </summary> /// <param name="biz"></param> private static void DeleteAProjectRecord(Project project) { //if (project.RecordCount > 0) if (!project.IsEmpty) { int projectId = int.Parse(project[project.PrimaryKeyName].ToString()); //ProjectStage stages = new ProjectStage(); //stages.GetByParent(projectId); DataView stages = BusinessObject.GetByParentAsDataView <ProjectStage>(projectId); List <int> stageList = new List <int>(); foreach (DataRow stageRecord in stages.Table.Rows) { int stageId = int.Parse(stageRecord[ProjectStage.StageId].ToString()); //ProjectStageEvent events = new ProjectStageEvent(); //events.GetByParent(stageId); DataView events = BusinessObject.GetByParentAsDataView <ProjectStageEvent>(stageId); List <int> eventList = new List <int>(); foreach (DataRow eventRecord in events.Table.Rows) { int eventId = int.Parse(eventRecord[ProjectStageEvent.StageEventId].ToString()); //ProjectEventAttribute eventAttributes = new ProjectEventAttribute(); //eventAttributes.GetByParent(eventId); DataView eventAttributes = BusinessObject.GetByParentAsDataView <ProjectEventAttribute>(eventId); List <int> attList = new List <int>(); foreach (DataRow attRecord in eventAttributes.Table.Rows) { int attId = int.Parse(attRecord[ProjectEventAttribute.EventAttributeId].ToString()); attList.Add(attId); } foreach (int key in attList) { eventAttributes.Delete(key); } eventList.Add(eventId); //// Delete All Event Attributes //eventAttributes.Delete(); } foreach (int key in eventList) { events.Delete(key); } stageList.Add(stageId); } foreach (int key in stageList) { stages.Delete(key); } project.Delete(projectId); //// Delete Stage after its events have been deleted //stages.Delete(); } //// Finally Delete Project //project.Delete(); }
///<summary>Handle edit->delete command from menu</summary> public void OnDeleteActivated(object o, EventArgs args) { if (dataBook.NPages == 0) { return; } DataView dv = ((DataViewDisplay)dataBook.CurrentPageWidget).View; dv.Delete(); }
public void TestDelete() { Assert.Throws <DeletedRowInaccessibleException>(() => { DataView TestView = new DataView(_dataTable); TestView.Delete(0); DataRow r = TestView.Table.Rows[0]; Assert.True(!((string)r["itemId"] == "item 1")); }); }
private void removeExpiredRows(DataTable table, string expiredColumnName) { string filter = string.Format(CultureInfo.InvariantCulture, "{0} < #{1}#", expiredColumnName, DateTime.UtcNow); DataView view = new DataView(table, filter, null, DataViewRowState.CurrentRows); for (int i = view.Count - 1; i >= 0; i--) { view.Delete(i); } }
private void btnDeleteDetailColumn_Click(object sender, EventArgs e) { DataView dv = (DataView)gdDetail.DataSource; if (gridView2.GetFocusedDataSourceRowIndex() > -1) { dv.Delete(gridView2.GetFocusedDataSourceRowIndex()); gdDetail.DataSource = dv; gdDetail.RefreshDataSource(); } }
public void deleterow(DataView dataView, int currentRow) { string textofcurrentRow = dataView[currentRow]["recordName"].ToString(); if (MessageBox.Show("Would you like to delete person " + textofcurrentRow, "form closing", MessageBoxButtons.YesNo) == DialogResult.Yes) { dataView.Delete(currentRow); MyNotebook form = new MyNotebook(); form.dgv1.DataSource = dataView; } }
private void OdstranitStylZTabulky(string sID) { DataView dv = new DataView(mdtStyly); dv.AllowDelete = true; dv.RowFilter = String.Format("StylID = '{0}'", sID); if (dv.Count == 1) { dv.Delete(0); } }
/// <summary> /// 刪除檢視表中所有的資料列。 /// </summary> /// <param name="dataView">檢視表。</param> /// <param name="isAcceptChanges">是否同意變更。</param> public static void DeleteRows(DataView dataView, bool isAcceptChanges) { for (int N1 = dataView.Count - 1; N1 >= 0; N1 += -1) { dataView.Delete(N1); } if (isAcceptChanges) { dataView.Table.AcceptChanges(); } }
public static void Delete(string categoryID) { dv.RowFilter = "SrNo='" + categoryID + "'"; dv.Sort = "SrNo"; dv.Delete(0); dv.RowFilter = ""; save(); }
/// <summary> /// Delete rows from database with specified filter; /// </summary> /// <param name="filter">string</param> /// <returns>bool</returns> public bool Delete(string filter) { DataView dataView = new DataView(table); dataView.RowFilter = filter; dataView.AllowDelete = true; while (dataView.Count > 0) { dataView.Delete(0); } return(true); }
/// <summary> /// 取选择变化后的对应表 /// </summary> /// <param name="p_dtDef">关联表</param> /// <param name="p_strFilter">关联表的过滤字段</param> /// <param name="p_intFilterValue">关联表过滤的值</param> /// <param name="p_strKeyName">对应的关键字段</param> public void GetChange(ref DataTable p_dtDef, string p_strFilter, object p_objFilterValue, string p_strKeyName) { if (p_dtDef.Columns[p_strKeyName].DataType == typeof(String)) { GetChange2(ref p_dtDef, p_strFilter, p_objFilterValue, p_strKeyName); return; } DataTable dt = (gdLeft.DataSource as DataView).Table; dt.AcceptChanges(); string sf = p_dtDef.Columns[p_strFilter].DataType == typeof(String) ? "{0}='{1}'" : "{0}={1}"; DataRow[] drs = p_dtDef.Select(string.Format(sf, p_strFilter, p_objFilterValue)); var q1 = from def in drs select def.Field <decimal>(p_strKeyName); var q2 = from s in dt.AsEnumerable() select s.Field <decimal>(p_strKeyName); //新增的 var add = q2.Except(q1); foreach (decimal d in add) { DataRow r = p_dtDef.NewRow(); if (p_dtDef.Columns[p_strFilter].DataType == typeof(String)) { r[p_strFilter] = Convert.ToString(p_objFilterValue); } else { r[p_strFilter] = weCare.Core.Utils.Function.Dec(p_objFilterValue); } r[p_strKeyName] = d; p_dtDef.Rows.Add(r); } //删除的 var dele = q1.Except(q2); DataView dv = p_dtDef.DefaultView; dv.RowFilter = string.Format(sf, p_strFilter, p_objFilterValue); dv.Sort = p_strKeyName; foreach (decimal d in dele) { int r = dv.Find(d); if (r != -1) { dv.Delete(r); } } }
public void delImportCar(string sSimNum) { DataView view = new DataView(this.m_dtImportCar, string.Format("SimNum='{0}'", sSimNum), "", DataViewRowState.CurrentRows); if (view.Count > 0) { if (this.lbImportCar.SelectedValue.ToString() == sSimNum) ///ToString { this.setTrackingCar(); } view.Delete(0); } }
private void CleanDS() { DataRow row = null; for (int i = 0; i < exportDS.Table.Rows.Count; i++) { row = exportDS.Table.Rows[i]; if (row[0].ToString() == "__SubHeading") { exportDS.Delete(i); } } }
private void Delete_PaymentDetails(string sClaimRefNo, string sRegNo, InterestReimbursement oIR) { DataView dv = oIR.DtIntePaymentDetails.DefaultView; dv.RowFilter = "ClaimRefNo='" + sClaimRefNo.Trim() + "' And RegNo='" + sRegNo.Trim() + "'"; for (int i = 0; i < dv.Count; i++) { dv.Delete(0); } oIR.DtIntePaymentDetails.AcceptChanges(); dv.RowFilter = null; }
[Test] public void AllowDelete() { DataTable dt = DataProvider.CreateParentDataTable(); DataView dv = new DataView(dt); // AllowDelete - default value Assert.AreEqual(true, dv.AllowDelete, "DV6"); // AllowDelete - true dv.AllowDelete = true; Assert.AreEqual(true, dv.AllowDelete, "DV7"); // AllowDelete - false dv.AllowDelete = false; Assert.AreEqual(false, dv.AllowDelete, "DV8"); dv.AllowDelete = false; // AllowDelete false- Exception try { dv.Delete(0); Assert.Fail("DV9: Delete Failed to throw DataException"); } catch (DataException) {} catch (AssertionException exc) { throw exc; } catch (Exception exc) { Assert.Fail("DV10: Delete. Wrong exception type. Got:" + exc); } dv.AllowDelete = true; int RowsCount = dv.Count; // AllowDelete true- Exception dv.Delete(0); Assert.AreEqual(RowsCount - 1, dv.Count, "DV11"); }
public static void Delete(string categoryID) { SelectAll(); dv.RowFilter = "id='" + categoryID + "'"; if (dv.Count == 0) { MessageBox.Show("Record was not found,please check the XML"); dv.RowFilter = ""; return; } dv.Sort = "id"; dv.Delete(0); dv.RowFilter = ""; save(); }
public void AllowDelete() { DataTable dt = DataProvider.CreateParentDataTable(); DataView dv = new DataView(dt); // AllowDelete - default value Assert.Equal(true, dv.AllowDelete); // AllowDelete - true dv.AllowDelete = true; Assert.Equal(true, dv.AllowDelete); // AllowDelete - false dv.AllowDelete = false; Assert.Equal(false, dv.AllowDelete); dv.AllowDelete = false; // AllowDelete false- Exception Assert.Throws<DataException>(() => { dv.Delete(0); }); dv.AllowDelete = true; int RowsCount = dv.Count; // AllowDelete true- Exception dv.Delete(0); Assert.Equal(RowsCount - 1, dv.Count); }
public void RowStateFilter_2() { DataSet dataset = new DataSet("new"); DataTable dt = new DataTable("table1"); dataset.Tables.Add(dt); dt.Columns.Add("col1"); dt.Columns.Add("col2"); dt.Rows.Add(new object[] { 1, 1 }); dt.Rows.Add(new object[] { 1, 2 }); dt.Rows.Add(new object[] { 1, 3 }); dataset.AcceptChanges(); DataView dataView = new DataView(dataset.Tables[0]); // 'new' table in this sample contains 6 records dataView.AllowEdit = true; dataView.AllowDelete = true; string v; // Editing the row dataView[0]["col1"] = -1; dataView.RowStateFilter = DataViewRowState.ModifiedOriginal; v = dataView[0][0].ToString(); Assert.Equal(1, dataView.Count); Assert.Equal("1", v); // Deleting the row dataView.Delete(0); dataView.RowStateFilter = DataViewRowState.Deleted; v = dataView[0][0].ToString(); Assert.Equal(1, dataView.Count); Assert.Equal("1", v); }
public void TestDelete() { Assert.Throws<DeletedRowInaccessibleException>(() => { DataView TestView = new DataView(_dataTable); TestView.Delete(0); DataRow r = TestView.Table.Rows[0]; Assert.True(!((string)r["itemId"] == "item 1")); }); }
public void TestDeleteOutOfBounds() { Assert.Throws<IndexOutOfRangeException>(() => { DataView TestView = new DataView(_dataTable); TestView.Delete(100); }); }
public void TestDeleteNotAllowed() { Assert.Throws<DataException>(() => { DataView TestView = new DataView(_dataTable); TestView.AllowDelete = false; TestView.Delete(0); }); }
public void TestDeleteClosed() { Assert.Throws<IndexOutOfRangeException>(() => { DataView TestView = new DataView(_dataTable); TestView.Dispose(); // Close the table TestView.Delete(0); // cannot access to item at 0. }); }
public void TestDeleteAndCount() { DataSet dataset = new DataSet("new"); DataTable dt = new DataTable("table1"); dataset.Tables.Add(dt); dt.Columns.Add("col1"); dt.Columns.Add("col2"); dt.Rows.Add(new object[] { 1, 1 }); dt.Rows.Add(new object[] { 1, 2 }); dt.Rows.Add(new object[] { 1, 3 }); DataView dataView = new DataView(dataset.Tables[0]); Assert.Equal(3, dataView.Count); dataView.AllowDelete = true; // Deleting the first row dataView.Delete(0); Assert.Equal(2, dataView.Count); }
public void Delete() { //create the source datatable DataTable dt = DataProvider.CreateChildDataTable(); //create the dataview for the table DataView dv = new DataView(dt); int CountView = dv.Count; int CountTable = dt.Rows.Count; DataRowView drv = dv[0]; // Delete - DataView Row Count dv.Delete(0); Assert.Equal(dv.Count, CountView - 1); // Delete - Table Row Count Assert.Equal(dt.Rows.Count, CountTable); // Delete - check table Assert.Equal(dt, drv.Row.Table); }