protected void loadData() { GlobalClass GC = new GlobalClass(); PatientID = GC.getPatientID(); string gQuery1 = "Select Treat_ID,Treat_Med_No,Treat_Due_Date,Treat_Issue_Date from Treatment_Details where Treat_P_ID = " + PatientID; Gbind1(gQuery1); string GetData = "Select P_Id,P_Name,P_Password,P_City,MedicineTaker, Treat_ID, Treat_Med_No,Format(Treat_Issue_Date, \"dd/mm/yyyy\") AS Treat_Issue_Date,Treat_Qty,Format(Treat_Due_Date, \"dd/mm/yyyy\") AS Treat_Due_Date,Treat_P_ID From patient_Details,Treatment_Details Where patient_Details.P_Id = Treatment_Details.Treat_P_ID AND patient_Details.P_Id = " + PatientID; DBTrac DBT = new DBTrac(); DataSet dsData = DBT.returnDataset(GetData); DataView dv = dsData.Tables[0].DefaultView; dv.RowFilter = "Treat_ID >= MAX(Treat_ID)"; label1.Text = dv[0]["P_Name"].ToString(); label2.Text = dv[0]["MedicineTaker"].ToString(); label4.Text = dv[0]["P_City"].ToString(); label8.Text = dv[0]["Treat_Issue_Date"].ToString(); label11.Text = dv[0]["Treat_Due_Date"].ToString(); label14.Text = dv[0]["Treat_Qty"].ToString(); }
DataSet dsData = DBT.returnDataset(GetData); if(dsdata!=null && dsdata.Tables.Count>0) { DataView dv = dsData.Tables[0].DefaultView; dv.RowFilter = "Treat_ID >= MAX(Treat_ID)"; if(dv!=null && dv.Table.Rows.Count>0) { label1.Text = dv[0]["P_Name"].ToString(); label2.Text = dv[0]["MedicineTaker"].ToString(); label4.Text = dv[0]["P_City"].ToString(); label8.Text = dv[0]["Treat_Issue_Date"].ToString(); label11.Text = dv[0]["Treat_Due_Date"].ToString(); label14.Text = dv[0]["Treat_Qty"].ToString(); } }
PatientID = GC.getPatientID();
PatientID
patientDetails PD = new patientDetails();PD.Show();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)