private void dataGridView1_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { int res; if (e.ColumnIndex == 4) { if (e.FormattedValue.ToString() == string.Empty) { return; } else if (!int.TryParse(e.FormattedValue.ToString(), out res) || e.FormattedValue.ToString().Length > 10) { dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = 1; MessageBox.Show("Потрібно ввести числове значення"); e.Cancel = true; return; } } }
private void JSCDataGrid1CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { try { switch (e.ColumnIndex) { case 2: if (e.FormattedValue.ToString() == "" || e.FormattedValue.ToString() == "0") { jscDataGrid1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = 1; } break; } } catch (Exception) { MessageBox.Show(@"خطا در حال اعتبارسنجی سلول", @"سامانه مدیریت سوپر مارکت"); return; } }
private void sverPDataGrid_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { try { try { FunctionUse.sverPDataGrid_CellValidating(sverPDataGrid, e, load); } catch (Exception ex) { MessageBox.Show(ex.Message); MessageBox.Show(ex.StackTrace); } } catch (Exception ex) { MessageBox.Show(ex.Message); MessageBox.Show(ex.StackTrace); } }
private void grid_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { if (e.ColumnIndex != 0) { return; } for (int i = 0; i < grid.Rows.Count; ++i) { if (i != e.RowIndex && string.Compare(Convert.ToString(grid.Rows[i].Cells[0].Value).Trim(), Convert.ToString(e.FormattedValue).Trim()) == 0) { e.Cancel = true; lblMessages.Text = "Another command is registered with the name \"" + e.FormattedValue + "\""; Console.Beep(); break; } } }
private void OnCellValidating(object sender, DataGridViewCellValidatingEventArgs e) { if (e.ColumnIndex == cbType.Index) { switch ((CellTypeEnum)((ComboBox)dataGridView1.EditingControl).SelectedValue) { case CellTypeEnum.TextBox: dataGridView1[tbValue.Index, e.RowIndex] = new DataGridViewTextBoxCell(); break; case CellTypeEnum.ComboBox: dataGridView1[tbValue.Index, e.RowIndex] = new DataGridViewComboBoxCell(); break; case CellTypeEnum.Flag: dataGridView1[tbValue.Index, e.RowIndex] = new DataGridViewCheckBoxCell(); break; } } }
private void TablaIngreso_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { if (e.ColumnIndex == tablaIngreso.Columns["Cantidad"].Index) { tablaIngreso.Rows[e.RowIndex].ErrorText = ""; int newInteger; if (tablaIngreso.Rows[e.RowIndex].IsNewRow) { return; } if (!int.TryParse(e.FormattedValue.ToString(), out newInteger) || newInteger <= 0) { SystemSounds.Beep.Play(); e.Cancel = true; tablaIngreso.Rows[e.RowIndex].ErrorText = "El valor debe ser un entero positivo distinto de 0."; } } }
//couldn't use base.dataGridView_CellValidating as the values have to be validated per column individually protected override void dataGridView_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { if (dataGridView.ReadOnly) return; if (Content == null) return; if (Content.Rows == 0 || Content.Columns == 0) return; string errorMessage; if (!String.IsNullOrEmpty(e.FormattedValue.ToString())) { if (dataGridView.IsCurrentCellInEditMode && Content.PreprocessingData.IsFiltered) { errorMessage = "A filter is active, you cannot modify data. Press ESC to exit edit mode."; } else { Content.Validate(e.FormattedValue.ToString(), out errorMessage, e.ColumnIndex); } if (!String.IsNullOrEmpty(errorMessage)) { e.Cancel = true; dataGridView.Rows[e.RowIndex].ErrorText = errorMessage; } } }
/// <summary> /// 单元格校验 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dgv_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { if (e.ColumnIndex == 2) // 校验条文列 { string currentCellValue = e.FormattedValue.ToString(); if (!string.IsNullOrEmpty(currentCellValue)) { List <string> list = currentCellValue.Split(ItemSplitStyles, StringSplitOptions.RemoveEmptyEntries).Select(s => s.Trim()).ToList(); string errorItem = string.Empty; if (!IsValidedItems(list, out errorItem)) { MessageBox.Show("条文【" + errorItem + "】格式错误,请修改为正确格式", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error); e.Cancel = true; return; } } } }
private void grdAttributes_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { if (0 <= e.ColumnIndex && e.ColumnIndex < grdAttributes.Columns.Count && 0 <= e.RowIndex && e.RowIndex < grdAttributes.Rows.Count) { var col = grdAttributes.Columns[e.ColumnIndex]; var row = grdAttributes.Rows[e.RowIndex]; if (col.Name == "attValue") { var type = (string)row.Cells[3].Value; var value = (string)e.FormattedValue; string format = null; if (!ValidateValue(type, value, out format)) { row.ErrorText = string.Format("'{0}' is not a valid value for the type {1}. Expected format: '{2}'", value, type, format); e.Cancel = true; } } } }
private void enumDataGridView_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { void SetErrorText(string text) { enumDataGridView.Rows[e.RowIndex].Cells[e.ColumnIndex].ErrorText = text; } SetErrorText(null); var formattedValue = Convert.ToString(e.FormattedValue); if (e.ColumnIndex == 0 && !long.TryParse(formattedValue, out _)) { SetErrorText($"'{formattedValue}' is not a valid value."); } else if (e.ColumnIndex == 1 && string.IsNullOrWhiteSpace(formattedValue)) { SetErrorText("Empty names are not allowed."); } }
private void dataGridViewRouteSystems_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { if (e.ColumnIndex == 0) { string sysname = e.FormattedValue.ToString(); var row = dataGridViewExplore.Rows[e.RowIndex]; var cell = dataGridViewExplore[e.ColumnIndex, e.RowIndex]; ISystem sys = SystemClassDB.GetSystem(sysname); if (sysname != "" && sys == null && !edsm.IsKnownSystem(sysname)) { row.ErrorText = "System not known to EDSM"; } else { row.ErrorText = ""; } } }
/// <summary> /// Handles the CellValidating event of the dataGridView_ProjCritProdFulf control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="DataGridViewCellValidatingEventArgs"/> instance containing the event data.</param> /// Erstellt von Veit Berg, am 27.01.16 private void dataGridView_ProjCritProdFulf_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { try{ if (e.ColumnIndex == 5) { dataGridView_ProjCritProdFulf.Rows[e.RowIndex].ErrorText = ""; if (CommonMethods.CheckIfForbiddenDelimiterInDb(e.FormattedValue.ToString())) { MessageBox.Show(CommonMethods.MessageForbiddenDelimiterWasFoundInText()); } { } } } catch (Exception x) { MessageBox.Show(x.Message); } }
private void InventoryItemGrid_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { if (InventoryItemGrid.CurrentCell.ColumnIndex == InventoryItemGrid.Columns[InventoryItemGrid_ActualQuantity.Name].Index) { if (InventoryItemGrid.CurrentCell.EditedFormattedValue.ToString().AsInt() == null) { SaveInventoryItemButton.Enabled = false; e.Cancel = true; } else { InventoryItemGrid.CurrentCell.ErrorText = string.Empty; if (InventoryItemGrid.CurrentCell.Value.ToString() != InventoryItemGrid.CurrentCell.EditedFormattedValue.ToString()) { InventoryItemGrid.CurrentCell.Style.ForeColor = Color.Red; IsInventoryItemChanged |= true; } } } }
private void Grid_SplitSettings_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { if (e.ColumnIndex == COLUMNINDEX_DELAY) { if (string.IsNullOrWhiteSpace(e.FormattedValue.ToString())) { return; } try { TimeSpanParser.Parse(e.FormattedValue.ToString()); } catch { e.Cancel = true; grid_SplitSettings.Rows[e.RowIndex].ErrorText = "Invalid Time"; } } }
private void DG_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { //if (e.ColumnIndex == 0) // 1 should be your column index //{ // int i; // double dblFormAmnt = 0, dblToAmnt = 0; // if (DG[1, e.RowIndex].Value != null) // { // dblFormAmnt = Convert.ToDouble(Utility.Val(DG[0, e.RowIndex].Value.ToString())); // } // if (DG[1, e.RowIndex].Value != null) // { // dblToAmnt = Convert.ToDouble(Utility.Val(DG[1, e.RowIndex].Value.ToString())); // } // if (dblFormAmnt > dblToAmnt) // { // MessageBox.Show("f"); // } // if (dblToAmnt > dblFormAmnt) // { // MessageBox.Show("c"); // } //} //if (e.ColumnIndex == 1) // 1 should be your column index //{ // int i; // if (!int.TryParse(Convert.ToString(e.FormattedValue), out i)) // { // e.Cancel = true; // MessageBox.Show("please enter numeric"); // } // else // { // // the input is numeric // } //} }
private void dgvUrunler_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { Urun urun = (Urun)dgvUrunler.Rows[e.RowIndex].DataBoundItem; string mevcutDeger = dgvUrunler.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString(); // Mevcut hücrede değişiklik yapılmadıysa ya da yapıldıysa ancak değer aynı kaldıysa if (!dgvUrunler.IsCurrentCellDirty || e.FormattedValue.ToString() == mevcutDeger) { return; } if (e.ColumnIndex == 0) { if (e.FormattedValue.ToString() == "") { MessageBox.Show("Ürün adı boş geçilemez."); e.Cancel = true; } if (BaskaUrunVarMi(e.FormattedValue.ToString(), urun)) { ; } { MessageBox.Show("Ürün zaten mevcut."); e.Cancel = true; } } else if (e.ColumnIndex == 1) { decimal birimFiyat; bool gecerliMi = decimal.TryParse(e.FormattedValue.ToString(), out birimFiyat); if (!gecerliMi || birimFiyat < 0) { MessageBox.Show("Geçersiz fiyat."); e.Cancel = true; } } }
private void dataGridView1_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { int newInteger; string header = dataGridView1.Columns[dataGridView1.CurrentCellAddress.X].HeaderText; for (int i = 0; i < Design.Properties[dataGridView1.CurrentCellAddress.X].CheckCons.Count; i++) { if (Design.Properties[dataGridView1.CurrentCellAddress.X].CheckCons[i] != "") { string str = Design.Properties[dataGridView1.CurrentCellAddress.X].CheckCons[i].Remove(0, header.Count() + 1); // check the value that written in cell if (e.FormattedValue.ToString() != "") { if (str[0] == '>') { if (!int.TryParse(e.FormattedValue.ToString(), out newInteger) || newInteger < int.Parse(str.Substring(2, str.Count() - 2))) { dataGridView1.Rows[e.RowIndex].ErrorText = "no it's smaller than the cons"; e.Cancel = true; } } else if (str[0] == '<') { if (!int.TryParse(e.FormattedValue.ToString(), out newInteger) || newInteger > int.Parse(str.Substring(2, str.Count() - 2))) { dataGridView1.Rows[e.RowIndex].ErrorText = "no it's greater than the cons"; e.Cancel = true; } } else if (str[0] == '!') { if (!int.TryParse(e.FormattedValue.ToString(), out newInteger) || newInteger == int.Parse(str.Substring(3, str.Count() - 3))) { dataGridView1.Rows[e.RowIndex].ErrorText = "no it's equal"; e.Cancel = true; } } } } } }
private void Grid_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { CheckDataGridView(); var grid = (DataGridView)sender; try { if (grid.Columns[e.ColumnIndex].Name == "_txtValue") { var comboBoxCellOperator = (DataGridViewComboBoxCell)FilterGrid["_cboOperator", e.RowIndex]; if (!_operatorsWithNoValue.Contains(comboBoxCellOperator.Value)) { grid.CurrentCell.ErrorText = ""; grid.Rows[e.RowIndex].ErrorText = ""; var value = (string)e.FormattedValue; var index = -1; var comboBoxCellColumn = (DataGridViewComboBoxCell)FilterGrid["_cboColumn", e.RowIndex]; if (comboBoxCellColumn.Value != null) { index = comboBoxCellColumn.Items.IndexOf(comboBoxCellColumn.Value); } var errorText = CheckValue(index, value); if (!string.IsNullOrEmpty(errorText)) { errorText = " " + errorText; // add 5 spaces for visibility grid.CurrentCell.ErrorText = errorText; grid.Rows[e.RowIndex].ErrorText = errorText; e.Cancel = true; } } } } catch { grid.CurrentCell.ErrorText = "Something is wrong!"; e.Cancel = true; } }
private void gridAdmissionFeeType_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { if (e.ColumnIndex == gridAdmissionFeeType.Columns["colAmount"].Index || e.ColumnIndex == gridAdmissionFeeType.Columns["colMonthNo"].Index) { TextBox cellText = ((TextBox)gridAdmissionFeeType.EditingControl); if (cellText != null) { string cellValue = cellText.Text; if (e.ColumnIndex == 3) { if (string.IsNullOrEmpty(cellValue)) { MessageBox.Show("Amount is required."); e.Cancel = true; } } if (e.ColumnIndex == 4) { if (string.IsNullOrEmpty(cellValue)) { MessageBox.Show("Month is required."); e.Cancel = true; } else if (Convert.ToInt32(cellValue) > 12 || Convert.ToInt32(cellValue) < 1) { MessageBox.Show("Month should be between 1 to 12."); e.Cancel = true; } } } } //e.FormattedValue.ToString() // gridAdmissionFeeType.ClearSelection(); //gridAdmissionFeeType.Rows[e.RowIndex].Cells[e.ColumnIndex].Selected = true; //gridAdmissionFeeType.CurrentCell = gridAdmissionFeeType["colAmount", e.RowIndex]; // cellText.Focus(); }
private void resCellValidating(object sender, DataGridViewCellValidatingEventArgs e) { if (e.RowIndex < this.mResources.Length) { uint val32; ulong val64; DataGridViewRow row = this.resDGV.Rows[e.RowIndex]; row.ErrorText = ""; string str = e.FormattedValue.ToString(); switch ((ColumnName)e.ColumnIndex) { case ColumnName.TID: if (!RK.TryParseUInt32(str, out val32)) { e.Cancel = true; row.ErrorText = "Type ID " + "must be a 32-bit unsigned integer"; } break; case ColumnName.GID: if (!RK.TryParseUInt32(str, out val32)) { e.Cancel = true; row.ErrorText = "Group ID " + "must be a 32-bit unsigned integer"; } break; case ColumnName.IID: if (!RK.TryParseUInt64(str, out val64)) { e.Cancel = true; row.ErrorText = "Type ID " + "must be a 64-bit unsigned integer"; } break; } } }
private void dataGridView1_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { string colText = dataGridView1.Columns[e.ColumnIndex].HeaderText; bool DOBError = false; bool widgetError = false; if (colText == "DOB") { DateTime temp; if (!DateTime.TryParse(e.FormattedValue.ToString(), out temp)) { dataGridView1.Rows[e.RowIndex].ErrorText = "The string entered is not a valid date."; e.Cancel = true; label1.ForeColor = Color.Red; label1.Text = "The string entered is not a valid date."; DOBError = true; } } if (colText == "NumberOfWidgets") { int testInt; if (!int.TryParse(e.FormattedValue.ToString(), out testInt)) { dataGridView1.Rows[e.RowIndex].ErrorText = "Content must be numeric"; e.Cancel = true; label1.ForeColor = Color.Red; label1.Text = "Content must be numeric"; widgetError = true; } } if (widgetError || DOBError) { dataError = true; } else { dataError = false; } }
private void dataGridView1_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { var selectedCells = (sender as DataGridView).SelectedCells; if (selectedCells.Count > 0) { try { if (e.ColumnIndex == 0) { productTableAdapter.UpdateQuery(e.FormattedValue.ToString(), selectedCells[1].Value.ToString(), Convert.ToDecimal(selectedCells[3].Value), selectedCells[4].Value.ToString(), selectedCells[0].Value.ToString()); } else if (e.ColumnIndex == 1) { productTableAdapter.UpdateQuery(selectedCells[0].Value.ToString(), e.FormattedValue.ToString(), Convert.ToDecimal(selectedCells[3].Value), selectedCells[4].Value.ToString(), selectedCells[0].Value.ToString()); } else if (e.ColumnIndex == 3) { productTableAdapter.UpdateQuery(selectedCells[0].Value.ToString(), selectedCells[1].Value.ToString(), Convert.ToDecimal(e.FormattedValue), selectedCells[4].Value.ToString(), selectedCells[0].Value.ToString()); } else if (e.ColumnIndex == 4) { productTableAdapter.UpdateQuery(selectedCells[0].Value.ToString(), selectedCells[1].Value.ToString(), Convert.ToDecimal(selectedCells[3].Value), e.FormattedValue.ToString(), selectedCells[0].Value.ToString()); } else if (e.ColumnIndex == 2) { productInStockTableAdapter.UpdateQuery(selectedCells[0].Value.ToString(), Convert.ToDouble(e.FormattedValue), Convert.ToInt32(selectedCells[5].Value), selectedCells[0].Value.ToString(), Convert.ToInt32(selectedCells[5].Value)); } else if (e.ColumnIndex == 5) { productInStockTableAdapter.UpdateQuery(selectedCells[0].Value.ToString(), Convert.ToDouble(selectedCells[2].Value), Convert.ToInt32(e.FormattedValue), selectedCells[0].Value.ToString(), Convert.ToInt32(selectedCells[5].Value)); } } catch { } productInStockTableAdapter.Fill(databaseForLabDataSet.ProductInStock); productTableAdapter.Fill(databaseForLabDataSet.Product); dataGridView1.DataSource = databaseForLabDataSet.View2; view2TableAdapter.Fill(databaseForLabDataSet.View2); dataGridView1.DataSource = databaseForLabDataSet.View2.Select(expression); } }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void tanitsuDataGridView_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { DataGridView dgv = (DataGridView)sender; //新しい行のセルでなく、セルの内容が変更されている時だけ検証する if (e.RowIndex == dgv.NewRowIndex || !dgv.IsCurrentCellDirty) { return; } if (dgv.Columns[e.ColumnIndex].Name == "butsuri_name" && string.IsNullOrWhiteSpace(e.FormattedValue.ToString())) { dgv.Rows[e.RowIndex].Cells["butsuri_name"].ErrorText = "値が入力されていません。"; } if (dgv.Columns[e.ColumnIndex].Name == "butsuri_name" && !string.IsNullOrWhiteSpace(e.FormattedValue.ToString())) { dgv.Rows[e.RowIndex].Cells["butsuri_name"].ErrorText = ""; } if (dgv.Columns[e.ColumnIndex].Name == "data_type" && string.IsNullOrWhiteSpace(e.FormattedValue.ToString())) { dgv.Rows[e.RowIndex].Cells["data_type"].ErrorText = "値が入力されていません。"; } if (dgv.Columns[e.ColumnIndex].Name == "data_type" && !string.IsNullOrWhiteSpace(e.FormattedValue.ToString())) { dgv.Rows[e.RowIndex].Cells["data_type"].ErrorText = ""; } if (dgv.Columns[e.ColumnIndex].Name == "data_type" && !this.isCorrectDataType(e.FormattedValue.ToString())) { dgv.Rows[e.RowIndex].Cells["data_type"].ErrorText = "データ型が不正です。"; } if (dgv.Columns[e.ColumnIndex].Name == "data_type" && this.isCorrectDataType(e.FormattedValue.ToString())) { dgv.Rows[e.RowIndex].Cells["data_type"].ErrorText = ""; } }
//private void dtgvDs_CellClick(object sender, DataGridViewCellEventArgs e) //{ // if (dtgvDs.SelectedRows.Count == 1) // { // txtMaso.Text = dtgvDs.SelectedRows[0].Cells[0].Value.ToString(); // txtHoTen.Text = dtgvDs.SelectedRows[0].Cells[1].Value.ToString(); // } //} private void dtgvDs_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { float text; if (GlobalVariable.GVMaSo != 0) { try { text = Convert.ToInt32(e.FormattedValue); if (text > 10) { dtgvDs.Rows[e.RowIndex].ErrorText = "Điểm không thể lớn hơn 10"; e.Cancel = true; } } catch { } } }
/// <summary> /// Validate the cells in Inventory. /// Edit is cancelled if any field is empty or color for car /// has already been allocated to another car /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public void DataGridViewFlowers_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { DataGridView gridView = sender as DataGridView; DataGridViewRow row = gridView.Rows[e.RowIndex]; string columnName = gridView.Columns[e.ColumnIndex].DataPropertyName; string cellValue = e.FormattedValue.ToString().Trim(); // only validate if we are editing if (row.Cells[e.ColumnIndex].IsInEditMode == false && cellValue.Length > 0) { return; } if (cellValue.Length == 0) { MessageBox.Show("Inventory field [" + columnName + "] is missing"); CellCancelNew(gridView, e); return; } }
private void dgvArgs_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { this.dgvArgs.Rows[e.RowIndex].ErrorText = ""; if (e.ColumnIndex == this.clnArgs.DisplayIndex) { if ((e.FormattedValue == null) || (e.FormattedValue.ToString() == "")) { this.dgvArgs.Rows[e.RowIndex].ErrorText = "请设置参数值"; e.Cancel = true; } else if (e.FormattedValue.ToString() != "|空值|") { BaseCondition tag = this.dgvArgs.Rows[e.RowIndex].Tag as BaseCondition; if ((tag != null) && this.method_1(e.FormattedValue.ToString(), tag.ValueType)) { this.dgvArgs.Rows[e.RowIndex].ErrorText = "设置参数值无效"; e.Cancel = true; } } } }
private void dgvMappings_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { Guid dummy; string column = dgvMappings.Columns[e.ColumnIndex].Name; // Abort validation if cell is not in the CompanyName column. if (column.Equals("clEntity")) { if (e.FormattedValue == null) { dgvMappings.Rows[e.RowIndex].ErrorText = "Entity must not be empty"; e.Cancel = true; } } else if (!Guid.TryParse(e.FormattedValue.ToString(), out dummy)) { // Check on valid GUID dgvMappings.Rows[e.RowIndex].ErrorText = string.Format("{0} is not a valid GUID", dgvMappings.Columns[e.ColumnIndex].HeaderText); e.Cancel = true; } }
private void cyclesGridView_CellValidating_1(object sender, DataGridViewCellValidatingEventArgs e) { if (e.ColumnIndex > 0) { string text = e.FormattedValue.ToString(); if (!string.IsNullOrEmpty(text)) { Format.WTF q = Format.ToUInt64(ref text, low: 0, high: 100000000001); if (q == Format.WTF.NonNumeric) { cyclesGridView.Rows[e.RowIndex].ErrorText = "Entry must be a non-negative integer"; e.Cancel = true; } else if (q == Format.WTF.Range) { cyclesGridView.Rows[e.RowIndex].ErrorText = "Entry must be >= " + 0.ToString() + " and <= " + 100000000000.ToString(); e.Cancel = true; } } } }
private void ValuesDV_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { try { if (this.Visible && e.ColumnIndex == 3) { DataRowView source = ValuesDV.Rows[e.RowIndex].DataBoundItem as DataRowView; AccessInfo info = (AccessInfo)source.Row[0]; if (IsSimpleValue(info)) { TypeInfo.Cast(e.FormattedValue, info.TypeInfo.BuiltInType); } } } catch (Exception exception) { ClientUtils.HandleException(this.Text, exception); e.Cancel = true; } }
private void dgvLine_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { double newInteger; if (e.ColumnIndex == 0) { if (!double.TryParse(e.FormattedValue.ToString(), out newInteger) || newInteger < 0) { MessageBox.Show("Invalid input number.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); e.Cancel = true; } double receivedQty = newInteger; double onhandQty = dgvLine[17, e.RowIndex].Value.AsDouble(); if (newInteger > onhandQty) { MessageBox.Show("Issue qty. must less than or equal Balance Qty.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); e.Cancel = true; } } }