Date ---------- Name 01/03/2020 ---- mr.x 05/03/2020 ---- my.y 01/04/2020 ---- mr.z
string DataLoad = "select month(Date) as Months, count(Name)as Count from customer GROUP BY month(Date) ";
data show like this Months -- Count 03 ---- 2 04 ---- 1
Month/Year -- Count 03/2020 ---- 2 04/2020 ---- 1
string DataLoad = "SELECT Format([Date], \"mm/yyyy\") AS \"Month/Year\", Count([Name]) AS \"Count\" FROM [customer] GROUP BY Format([Date], \"mm/yyyy\")";
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)