private void txt_Search_TextChanged(object sender, EventArgs e) { try { con.Open(); s = " select R_Number , R.P_id , Patients.P_Name , convert(varchar,Date_Reservation,105)as , "; s = s + " DoctorTest.Doctor_Name , ExamType.Exame_Type, R.Notes "; s = s + " from ResrvationData R "; s = s + " inner join Patients on R.P_id = Patients.P_id "; s = s + " inner join DoctorTest on R.Doctor_id = DoctorTest.Doctor_id "; s = s + " inner join ExamType on R.Exame_id = ExamType.Exame_id "; s = s + " Where R_Number + R.P_id + Patients.P_Name + DoctorTest.Doctor_Name + ExamType.Exame_Type like '%" + txt_Search.Text + "%' and Date_Reservation = '" + dateTimePicker1.Text + "' and ExamType.Exame_Type = '" + textBox1.Text + "' "; sdAdapter = new SqlDataAdapter(s, con); dt = new DataTable(); sdAdapter.Fill(dt); dataGridView_ReservationList.DataSource = dt; con.Close(); } catch { return; } }
+
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)