private void equipmentTypeBox_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { string eqID = DBManager.selectIdTag(equipmentTypeBox.SelectedValue.ToString()).Rows[0][2].ToString() + "-" + DBManager.countEquipments(equipmentTypeBox.SelectedValue.ToString()).ToString("D6"); int i = 0; while (DBManager.countDuplicateEquipments(eqID) != 0) { i = i + 1; eqID = DBManager.selectIdTag(equipmentTypeBox.SelectedValue.ToString()).Rows[0][2].ToString() + "-" + (DBManager.countEquipments(equipmentTypeBox.SelectedValue.ToString()) + i).ToString("D6"); } equipmentIdBox.Text = eqID; } catch { } }