public void cboSeason_SelectedIndexChanged(object sender, EventArgs e) { using (TBL_SCHEDULE_DATA_ACCESS sda = new TBL_SCHEDULE_DATA_ACCESS()) { dataGridViewGenerate.DataSource = sda.DisplayToGenerate(Convert.ToInt32(cboSeason.SelectedValue)); } }
private void ControlWork_Load(object sender, EventArgs e) { cboSeason.SelectedIndexChanged -= new EventHandler(cboSeason_SelectedIndexChanged); TBL_SCHEDULE_DATA_ACCESS sda = new TBL_SCHEDULE_DATA_ACCESS(); TBL_SEASON_DATA_ACCESS seda = new TBL_SEASON_DATA_ACCESS(); cboSeason.DataSource = seda.ShowSeason(); cboSeason.DisplayMember = "SEASON_NAME"; cboSeason.ValueMember = "SEASON_ID"; dataGridViewGenerate.DataSource = sda.DisplayToGenerate(Convert.ToInt32(cboSeason.SelectedValue)); cboSeason.SelectedIndexChanged += new EventHandler(cboSeason_SelectedIndexChanged); }
private void btnGenerate_Click(object sender, EventArgs e) { btnGenerate.UseSelectable = false; try { SEASON_ID = 0; REMAIN_LICENSE = ""; foreach (DataGridViewRow row in dataGridViewGenerate.SelectedRows) { REMAIN_LICENSE = row.Cells[5].Value.ToString(); RESULT = Regex.Match(REMAIN_LICENSE, @"\d+").Value; SEASON_ID = Convert.ToInt32(row.Cells[0].Value); } if (Int32.Parse(RESULT) == 0) { var result = MetroMessageBox.Show(this, "សូមអភ័យទោសចំនួនអាជា្ញប័ណ្ឌដែលត្រូវចេញអស់ហើយ ! ", "ពត៏មាន", MessageBoxButtons.OK); if (result == System.Windows.Forms.DialogResult.OK) { } } else { FormGenerateLicense generate = new FormGenerateLicense(); generate.ShowDialog(this); GC.Collect(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { using (TBL_SCHEDULE_DATA_ACCESS sda = new TBL_SCHEDULE_DATA_ACCESS()) { dataGridViewGenerate.DataSource = sda.DisplayToGenerate(Convert.ToInt32(cboSeason.SelectedValue)); } } }