private void txtCariProsedur_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { DataGridViewRow row = (DataGridViewRow)dgvProcedure.Rows[0].Clone(); var dh = new dataset.yakkumdbTableAdapters.ICD9_CM_2011_Procedure_CodesTableAdapter(); var dh2 = new fa_rx_prosedurTableAdapter(); dh.Fill(yakkumdb.ICD9_CM_2011_Procedure_Codes, txtCariProsedur.Text); DataTable dt = dh.GetData(txtCariProsedur.Text); if (dt.Rows.Count > 0) { foreach (DataRow r in dt.Rows) { dh2.InsertQuery(_noreg, r["vc_code_sp"].ToString(), r["vc_long_description"].ToString(), null, DateTime.Now); //row.Cells[1].Value = r["vc_code_sp"].ToString(); //row.Cells[2].Value = r["vc_long_description"].ToString(); } } else { dh2.InsertQuery(_noreg, "-", txtCariProsedur.Text.ToString(), null, DateTime.Now); //row.Cells[1].Value = "-"; //row.Cells[2].Value = txtCariProsedur.Text.ToString(); } this.view_ProcedureTableAdapter.FillNoReg(yakkumdb.view_Procedure, _noreg); this.dgvProcedure.Update(); //dgvProcedure.Rows.Add(row); txtCariProsedur.Clear(); } }
private void txtCariProsedur_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Enter) { var _dh = new dataset.yakkumdbTableAdapters.ICD9_CM_2011_Procedure_CodesTableAdapter(); _dh.Fill(yakkumdb.ICD9_CM_2011_Procedure_Codes, txtCariProsedur.Text); DataTable dt = _dh.GetData(txtCariProsedur.Text); foreach (DataRow r in dt.Rows) { DataGridViewRow row = (DataGridViewRow)dgvProcedure.Rows[0].Clone(); row.Cells[1].Value = r["vc_code_sp"].ToString(); row.Cells[2].Value = r["vc_long_description"].ToString(); dgvProcedure.Rows.Add(row); txtCariProsedur.Clear(); } } }