private void txtCariDiagnosa_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { DataGridViewRow row = (DataGridViewRow)dgvDiagnosa.Rows[0].Clone(); var dh = new dataset.yakkumdbTableAdapters.ICD10_2019_CodesTableAdapter(); var dh2 = new fa_rx_diagnosaTableAdapter(); dh.Fill(yakkumdb.ICD10_2019_Codes, txtCariDiagnosa.Text); DataTable dt = dh.GetData(txtCariDiagnosa.Text); if (dt.Rows.Count > 0) { foreach (DataRow r in dt.Rows) { dh2.InsertQuery(_noreg, r["vc_codes"].ToString(), r["vc_desc_title"].ToString(), null, null, DateTime.Now); //row.Cells[1].Value = r["vc_codes"].ToString(); //row.Cells[2].Value = r["vc_desc_title"].ToString(); } } else { dh2.InsertQuery(_noreg, "-", txtCariDiagnosa.Text.ToString(), null, null, DateTime.Now); //row.Cells[1].Value = "-"; //row.Cells[2].Value = txtCariDiagnosa.Text.ToString(); } //dgvDiagnosa.Rows.Add(row); this.view_diagnosaTableAdapter.FillbyNoReg(yakkumdb.view_diagnosa, _noreg); this.dgvDiagnosa.Update(); this.dgvDiagnosa.Refresh(); txtCariDiagnosa.Clear(); } }
private void txtCariDiagnosa_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { var _dh = new dataset.yakkumdbTableAdapters.ICD10_2019_CodesTableAdapter(); _dh.Fill(yakkumdb.ICD10_2019_Codes, txtCariDiagnosa.Text); DataTable dt = _dh.GetData(txtCariDiagnosa.Text); foreach (DataRow r in dt.Rows) { DataGridViewRow row = (DataGridViewRow)dgvDiagnosa.Rows[0].Clone(); row.Cells[1].Value = r["vc_codes"].ToString(); row.Cells[2].Value = r["vc_desc_title"].ToString(); dgvDiagnosa.Rows.Add(row); txtCariDiagnosa.Clear(); } } }