private void btnNotice_Click(object sender, EventArgs e) { using (NarrativeMemoForm nmf = new NarrativeMemoForm(user_id)) { this.Dispose(); nmf.ShowDialog(); } }
private void forNoticetoExplain() { using (NarrativeMemoForm nmf = new NarrativeMemoForm(empid)) { MySqlDataReader _reader = csm.sqlCommand("Select *,YEAR(nte.date_reported)as _year, Day(nte.date_reported)as _day, Month(nte.date_reported)as _mon, date_format(date_created, '%m/%d/%Y')as'datecreated' from noticetoexplain nte inner join record r on nte.memo_no = r.memo_no where nte.memo_no = '" + tblDraft.CurrentRow.Cells[0].Value.ToString() + "'").ExecuteReader(); while (_reader.Read()) { nmf.lblGenRecNo.Text = _reader.GetString("memo_no"); nmf.txtDateNow.Text = _reader.GetString("datecreated"); nmf.dtReported.Value = new DateTime(int.Parse(_reader.GetString("_year")), int.Parse(_reader.GetString("_mon")), int.Parse(_reader.GetString("_day"))); nmf.txtSubject.Text = _reader.GetString("title"); nmf.txtFinding.Text = _reader.GetString("findings"); nmf.txtMngComm.Text = _reader.GetString("commentary"); nmf.ShowDialog(); } csm.closeSql(); } }