private void dgvLinkData_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { // Validate the values input into the fields // From Node must be a positive integer if (dgvLinkData.Columns[e.ColumnIndex].Name == "FromNode") { if (!ValidateData.IsUInt16(e.FormattedValue.ToString())) //value is not a positive integer { dgvLinkData.Rows[e.RowIndex].Cells[e.ColumnIndex].Style.ForeColor = Color.Red; dgvLinkData.Rows[e.RowIndex].Cells[e.ColumnIndex].Style.BackColor = Color.Yellow; CellDataError = true; } else { CellDataError = false; } } // To Node must be a positive integer if (dgvLinkData.Columns[e.ColumnIndex].Name == "ToNode") { if (!ValidateData.IsUInt16(e.FormattedValue.ToString())) //value is not a positive integer { dgvLinkData.Rows[e.RowIndex].Cells[e.ColumnIndex].Style.ForeColor = Color.Red; dgvLinkData.Rows[e.RowIndex].Cells[e.ColumnIndex].Style.BackColor = Color.Yellow; CellDataError = true; } else { CellDataError = false; } } // Length must be a numeric value if (dgvLinkData.Columns[e.ColumnIndex].Name == "Length") { if (!ValidateData.IsNumeric(e.FormattedValue.ToString())) //value is not numeric { dgvLinkData.Rows[e.RowIndex].Cells[e.ColumnIndex].Style.ForeColor = Color.Red; dgvLinkData.Rows[e.RowIndex].Cells[e.ColumnIndex].Style.BackColor = Color.Yellow; CellDataError = true; } else { CellDataError = false; } } // Capacity must be a positive integer if (dgvLinkData.Columns[e.ColumnIndex].Name == "Capacity") { if (!ValidateData.IsUInt16(e.FormattedValue.ToString())) //value is not a positive integer { dgvLinkData.Rows[e.RowIndex].Cells[e.ColumnIndex].Style.ForeColor = Color.Red; dgvLinkData.Rows[e.RowIndex].Cells[e.ColumnIndex].Style.BackColor = Color.Yellow; CellDataError = true; } else { CellDataError = false; } } // Free flow speed must be a positive integer if (dgvLinkData.Columns[e.ColumnIndex].Name == "FFS") { if (!ValidateData.IsUInt16(e.FormattedValue.ToString())) //value is not a positive integer { dgvLinkData.Rows[e.RowIndex].Cells[e.ColumnIndex].Style.ForeColor = Color.Red; dgvLinkData.Rows[e.RowIndex].Cells[e.ColumnIndex].Style.BackColor = Color.Yellow; CellDataError = true; } else { CellDataError = false; } } // Do not allow description entry to be empty if (dgvLinkData.Columns[e.ColumnIndex].Name == "Descrip") { if (String.IsNullOrEmpty(e.FormattedValue.ToString())) { dgvLinkData.Rows[e.RowIndex].Cells[e.ColumnIndex].Style.ForeColor = Color.Red; dgvLinkData.Rows[e.RowIndex].Cells[e.ColumnIndex].Style.BackColor = Color.Yellow; CellDataError = true; } else { CellDataError = false; } } }