private void textBox1_TextChanged(object sender, EventArgs e)
{
textBox1.MaxLength = 13;
dataGridView1.Rows.Clear();
dataGridView1.Refresh();
string query = ("select * from employee_ru eru, opd, privilege where eru.emp_ru_idcard = opd.emp_ru_id and opd.emp_ru_id = privilege.emp_ru_idcard and eru.emp_ru_idcard = '" + textBox1.Text + "'");
cmd = new SqlCommand(query, conn);
sda = new SqlDataAdapter(cmd);
dt = new DataTable();
sda.Fill(dt);
if (textBox1.Text == cmd.Connection.Database && textBox1.MaxLength == 13)
{
foreach (DataRow item in dt.Rows)
{
int n = dataGridView1.Rows.Add();
dataGridView1.Rows[n].Cells[0].Value = item["emp_ru_idcard"].ToString();
dataGridView1.Rows[n].Cells[1].Value = item["emp_ru_name"].ToString();
dataGridView1.Rows[n].Cells[2].Value = item["emp_ru_birthday"].ToString();
dataGridView1.Rows[n].Cells[3].Value = item["emp_ru_telmobile"].ToString();
dataGridView1.Rows[n].Cells[4].Value = item["privil_status"].ToString();
}
}
else
{
clinic_approve cliapp = new clinic_approve();
cliapp.Show();
}
}
private void conferm_Click(object sender, EventArgs e)
{
clinic_approve cliapp = new clinic_approve();
cliapp.Show();
}
