R
Ravi Kumar12233
Guest
hello all ,
I have a winform app connected to access database as data source ,
but in access i was using this below SQL to generate a query table called trend:
TRANSFORM Count(Complaint_Number) AS [Total Numbers]
SELECT Nature_of_problem, Count(Complaint_Number) AS [Total Numbers of Issues]
FROM master_table
GROUP BY Nature_of_problem
PIVOT Format(Complaint_Received_On,"mmm") In ("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");
But i do not know how execute this & populate the same in datagrid box , please help me.
Continue reading...
I have a winform app connected to access database as data source ,
but in access i was using this below SQL to generate a query table called trend:
TRANSFORM Count(Complaint_Number) AS [Total Numbers]
SELECT Nature_of_problem, Count(Complaint_Number) AS [Total Numbers of Issues]
FROM master_table
GROUP BY Nature_of_problem
PIVOT Format(Complaint_Received_On,"mmm") In ("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");
But i do not know how execute this & populate the same in datagrid box , please help me.
Continue reading...