Chart not showing

Hi 
I have a serious problem here. I can show a chart on a webpage but when I change the sql select then chart is not showing. The sql select works in Query Analyzer. 
The code below works  fine and show a chart on my page. But when I change the string strCommandText = “ Select to:
SELECT count (gkode) as antal, datepart(MM, anmdato) as month1, datepart (yyyy, anmdato) as year1  into #test from T_Sa2013 Where datepart(yyyy, anmdato) = 2013 and gkode IN (100, 200, 300) group by datepart(MM, anmdato), datepart(yyyy, anmdato) select A.[month1]from #test A group by A.[month1] select (select sum(antal) from #test B where B.[month1]< = A.[month1] ) as [Cum antal], A.[month1], A.[Year1] from #test A group by A.[month1],A.[Year1]
It does not show any chart on my website. The code works in the SQL Query Analyzer. I need to show a chart accumulated based on the strCommandText.
Any help would be greatly appreciated.
&nb ...