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