.net framework chart组件关联access database中一个query数据 无法显示IIF函数生成的字段
Access database中query groupbyweek的SQL代码如下:SELECT DISTINCTROW Format$([Incidents].[Open Time],'ww') AS Week,
SUM(IIF(Incidents.[Brief Description] Like 'GM_P*',1,0)) AS sys_incidents,
Sum(IIF(Incidents.[Brief Description] Not Like 'GM_P*',1,0)) AS service_requests,
Count(*) AS total_tickets
FROM Incidents
GROUP BY Format$([Incidents].[Open Time],'ww');
在vb.net中用chart组件创建图表.
ConnStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\My Files\Documents\Incidents.accdb"
conn = New OleDbConnection(ConnStr)
SQLStr = "SELECT * FROM groupbyweek"
Dim comm As OleDbCommand = New OleDbCommand(SQLStr, conn)
comm.Connection.Open()
Dim reader As OleDbDataReader = comm.ExecuteReader(CommandBehavior.CloseConnection)
ChartMain.DataBindTable(reader, "week")
问题在于在图表中week, total_ticket字段都能正常显示, 但sys_incidents字段值总为0, 而service_requests则与total_tickets相同.
请各位大虾不吝赐教. 谢谢! --------------------编程问答-------------------- 你把你的sql语句在SQL Server中执行看下,, --------------------编程问答-------------------- 这是Access Database. query 在Access database能正常显示数据
补充:.NET技术 , 图表区