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();
}
}
}
