private void button3_Click(object sender, EventArgs e) { checkGrid = "Due"; dueDate DD = new dueDate(); DD.ShowDialog(); GlobalClass GC = new GlobalClass(); DateTime vdateFrom = GC.getDueDateFrom(); DateTime vdateTo = GC.getDueDateTo(); string getAllData = "Select P_Id,P_Password,Format(Treat_Due_Date,\"'dd/MM/yyyy'\") As DueDate,P_Name,P_City,medicineTaker from patient_Details,Treatment_Details Where patient_Details.P_ID = Treatment_Details.Treat_P_ID AND Treat_Due_Date >= #" + vdateFrom.ToString("dd/MM/yyyy") + "# AND Treat_Due_Date <= #" + vdateTo.ToString("dd/MM/yyyy") + "#"; bindGrid(getAllData); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)