private void listViewProviders_SelectedIndexChanged(object sender, EventArgs e) { buttonApply.Enabled = true; buttonDelete.Enabled = true; textBoxEduYears.Enabled = true; bNew = false; if (listViewEduYears.FocusedItem == null) { return; } int k = queueEduYears.Count; for (int i = 0; i < k; i++) { m_EduYears = (_EduYears)queueEduYears.Dequeue(); if (m_EduYears.id.ToString() == (string)listViewEduYears.Items[listViewEduYears.FocusedItem.Index].Tag) { textBoxEduYears.Text = m_EduYears.name; queueEduYears.Enqueue(m_EduYears); break; } ; queueEduYears.Enqueue(m_EduYears); } }
public void refreshEduYears() { string edu_years_id = ""; if (comboBoxEduYear.SelectedIndex != -1) { edu_years_id = m_edu_year.id.ToString(); } comboBoxEduYear.Items.Clear(); queueEduYears.Clear(); try { mainWin.m_dbConnector.Lock(); MySqlConnection conn = mainWin.m_dbConnector.getMySqlConnection(); string sql = "SELECT `id`, `name` FROM `tbl_edu_years` ORDER BY `name`"; MySqlDataAdapter myAdapter = new MySqlDataAdapter(); myAdapter.SelectCommand = new MySqlCommand(sql, conn); DataSet dataSet = new DataSet(); myAdapter.Fill(dataSet); DataTable dataTable = dataSet.Tables[0]; _EduYears c = new _EduYears(); foreach (DataRow dataRow in dataTable.Rows) { c.id = int.Parse(dataRow["id"].ToString()); c.name = dataRow["name"].ToString().Trim(); comboBoxEduYear.Items.Add(c); if (edu_years_id != "" && edu_years_id == c.id.ToString()) { comboBoxEduYear.SelectedItem = c; } queueEduYears.Enqueue(c); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { mainWin.m_dbConnector.Unlock(); } }
public void refreshEduYears() { listViewEduYears.Items.Clear(); queueEduYears.Clear(); try { mainWin.m_dbConnector.Lock(); MySqlConnection conn = mainWin.m_dbConnector.getMySqlConnection(); string sql = "SELECT `id`, `name` FROM `tbl_edu_years` ORDER BY `name`"; MySqlDataAdapter myAdapter = new MySqlDataAdapter(); myAdapter.SelectCommand = new MySqlCommand(sql, conn); DataSet dataSet = new DataSet(); myAdapter.Fill(dataSet); DataTable dataTable = dataSet.Tables[0]; listViewEduYears.Items.Clear(); queueEduYears.Clear(); _EduYears p = new _EduYears(); foreach (DataRow dataRow in dataTable.Rows) { ListViewItem item1 = new ListViewItem(dataRow["id"].ToString().Trim(), 0); p.id = int.Parse(dataRow["id"].ToString()); item1.SubItems.Add(dataRow["name"].ToString().Trim()); p.name = dataRow["name"].ToString().Trim(); listViewEduYears.Items.Add(item1); listViewEduYears.Items[listViewEduYears.Items.Count - 1].Tag = dataRow["id"].ToString(); queueEduYears.Enqueue(p); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { mainWin.m_dbConnector.Unlock(); } }
private void listViewProviders_SelectedIndexChanged(object sender, EventArgs e) { buttonApply.Enabled = true; buttonDelete.Enabled = true; textBoxEduYears.Enabled = true; bNew = false; if (listViewEduYears.FocusedItem == null) return; int k = queueEduYears.Count; for (int i = 0; i < k; i++) { m_EduYears = (_EduYears)queueEduYears.Dequeue(); if (m_EduYears.id.ToString() == (string)listViewEduYears.Items[listViewEduYears.FocusedItem.Index].Tag) { textBoxEduYears.Text = m_EduYears.name; queueEduYears.Enqueue(m_EduYears); break; }; queueEduYears.Enqueue(m_EduYears); } }