有关Microsoft图表控件中的SQL语句的问题 [英] Problem about SQL statement in microsoft chart control

问题描述

我尝试从数据库中选择2个数据.
第一个数据是能源的价值
第二个数据是日期值

我在ASP页中使用了Microsoft图表控件.
当我为Chart配置数据源时

这是我要显示在图表上的数据

 ------------------------------------------ --
X轴我想要有关能量数据的数据
Y轴，我想要日期，但按月分组
-------------------------------------------- 

我已经使用了声明

  SELECT  SUM(ENERGY) AS  EXPR1，datepart(MONTH，dateTimeShow)  AS  EXPR2
 FROM  TableEnergy
组  BY  datepart(MONTH，dateTimeShow) AS  EXPR2 

执行时出现错误
:没有为一个或多个必需参数给出值

我不知道如果不使用datepart函数为什么会出现此错误，一切都很好

希望任何人都可以解决我的问题.如果我英语说错了，我感到非常抱歉.我也是英语和Asp.net的新手.

  SELECT  SUM(ENERGY) AS  EXPR1，MONTH(dateTimeShow) AS  EXPR2
 FROM  TableEnergy
组  BY  MONTH(dateTimeShow)

如果YEAR(dateTimeShow)相同，则上面的查询是正确的...因此，我建议您将查询替换为:

  SELECT  SUM(ENERGY) AS  EXPR1，MONTH(dateTimeShow) AS  EXPR2，YEAR(dateTimeShow) AS  EXPR3
 FROM  TableEnergy
组  BY  MONTH(dateTimeShow)，YEAR(dateTimeShow)
订单  BY  MONTH(dateTimeShow)，YEAR(dateTimeShow)

谢谢您的回答

现在我已经解决了我的问题

我已经修复了dateTimeShow
的格式

  SELECT  SUM(ENERGY) AS  EXPR1，格式(dateTimeShow，" ) AS  EXPR2
 FROM  TableEnergy
组  BY  Format(dateTimeShow，"  MM/yyyy")

当我执行结果是按月分组时

谢谢您的每一个回答

I''ve try to select 2 data from my database.
first data is value of energy
second data is value of date

I''ve use microsoft chart control in my ASP page
when i configure my datasource for Chart

This is data that i want to show on my chart

--------------------------------------------
X-axis i want data about enegy data
Y-axis i want date but group by month
--------------------------------------------

I''ve use statement

SELECT SUM(ENERGY) AS EXPR1 , datepart(MONTH,dateTimeShow) AS EXPR2
FROM TableEnergy
GROUP BY  datepart(MONTH,dateTimeShow) AS EXPR2

WHEN I''ve Execute I''ve got an error
: No value given for one or more required parameter

I''ve no idea why i''ve got this Error if i don''t use datepart funtion, everything is ok

Hope anyone to fix my problem. I''m so sorry if i''ve wrong in english. I''m newbies in english and Asp.net too

解决方案

Just remove AS EXPR2 from GROUP BY line:

SELECT SUM(ENERGY) AS EXPR1 , MONTH(dateTimeShow) AS EXPR2
FROM TableEnergy
GROUP BY  MONTH(dateTimeShow)

The above query is correct if YEAR(dateTimeShow) is the same... so i recommend you to replace your query with:

SELECT SUM(ENERGY) AS EXPR1 , MONTH(dateTimeShow) AS EXPR2, YEAR(dateTimeShow) AS EXPR3
FROM TableEnergy
GROUP BY  MONTH(dateTimeShow), YEAR(dateTimeShow)
ORDER BY  MONTH(dateTimeShow), YEAR(dateTimeShow)

Thank you for any answer

Now i was fix my problem already

I''ve fix my format of dateTimeShow

SELECT SUM(ENERGY) AS EXPR1 ,  Format(dateTimeShow,"MM/yyyy ") AS EXPR2
FROM TableEnergy
GROUP BY  Format(dateTimeShow,"MM/yyyy ")

when i ''ve execute the result was group by month already

Thank you for every answer too much

这篇关于有关Microsoft图表控件中的SQL语句的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！