Bind 2 SQL DataSource to a single chart from code behind
I would like to display the results of these two queries into one Pie Chart in asp.net:
SELECT COUNT(Code) AS 'Total Monthly Employee Medicals Completed'
FROM tblMedicalNextDueDate
WHERE Month(GETDATE()) = Month(LastFullMedical )
AND Year(GETDATE()) = Year(LastFullMedical )
SELECT COUNT(Code) AS 'Total Monthly Employee Medicals Not Completed'
FROM tblMedicalNextDueDate
WHERE Month(GETDATE()) = Month(NextFullMedical)
AND Year(GETDATE()) = Year(NextFullMedical)