public void loadGrid()
{
string PrescriptionQuery = @"SELECT [Pers_ID] ,[Doctor_Name] ,[Date] ,[Patient_Name] ,[Age],[Blood_Pressure],[Pulse_Rate] ,[Patient_Problem]
,[Medicines]
,[Doctor_Advice]
,[Next_Date]
FROM [dbo].[Prescription]";
PrescriptionGridView1.DataSource = db.getData(PrescriptionQuery);
PrescriptionGridView1.DataBind();
string DoctorNameQuery = @"select Doctor_Name from Doctor where Doctor_ID in (select Doctor_ID from DoctorPatient)";
// string PatientNameQuery = @"SELECT [Patient_ID],[Patient_Name],[Patient_Mobile],[Patient_Address] FROM [dbo].[Patient]";
string PatientNameQuery = @"select Patient_Name from Patient where Patient_ID IN (select Patient_ID from DoctorPatient)";
string MedicineNameQuery = @"select medicine_Name from Medicine where medicine_ID IN (select medicine_ID from PatientMedicine)";
string PatientMedicineNameQuery = @"select Patient_Name from Patient where Patient_ID IN (select Patient_ID from PatientMedicine)";
// DoctorNameGridView.DataSource = db.getData(DoctorNameQuery);
// DoctorNameGridView.DataBind();
//PatientNameGridView.DataSource = db.getData(PatientNameQuery);
//PatientNameGridView.DataBind();
// MedicineNameGridView.DataSource = db.getData(MedicineNameQuery);
// MedicineNameGridView.DataBind();
//PatientMedicineNameGridView.DataSource = db.getData(PatientMedicineNameQuery);
// PatientMedicineNameGridView.DataBind();
}
public void loadGrid()
{
string PrescriptionQuery = @"SELECT [Pers_ID] ,[Doctor_Name] ,[Date] ,[Patient_Name] ,[Age],[Blood_Pressure],[Pulse_Rate] ,[Patient_Problem]
,[Medicines]
,[Doctor_Advice]
,[Next_Date]
FROM [dbo].[Prescription]";
PrescriptionGridView1.DataSource = db.getData(PrescriptionQuery);
PrescriptionGridView1.DataBind();
}
public void loadGrid()
{
string UserQuery = @"SELECT [Patient_ID],[Patient_Name],[Patient_Mobile],[Patient_Address] FROM [dbo].[Patient]";
string DoctorQuery = @"SELECT [Doctor_ID],[Doctor_Name],[Doctor_Specialist],[Patient_ID] FROM [dbo].[Doctor]";
string MediceneQuery = @"SELECT [medicine_ID],[medicine_Name],[medicine_Price], [Patient_ID] FROM [dbo].[Medicine]";
string PrescriptionQuery = @"SELECT [Pers_ID] ,[Doctor_Name] ,[Date] ,[Patient_Name] ,[Age],[Blood_Pressure],[Pulse_Rate] ,[Patient_Problem]
,[Medicines]
,[Doctor_Advice]
,[Next_Date]
FROM [dbo].[Prescription]";
PrescriptionGridView1.DataSource = db.getData(PrescriptionQuery);
PrescriptionGridView1.DataBind();
UserGridView.DataSource = db.getData(UserQuery);
UserGridView.DataBind();
DoctorGridView.DataSource = db.getData(DoctorQuery);
DoctorGridView.DataBind();
MediceneGridView.DataSource = db.getData(MediceneQuery);
MediceneGridView.DataBind();
}