我写了一个统计的存储过程 如下:
CREATE PROCEDURE usp_Statistic_HseScoreStat (@startTime DateTime ,@endTime DateTime)as select count(distinct hse_import.batchId) as scoreCount,
sum (case when ScoreType='管理岗' and Score='合格' then 1 else 0 end) as manageSuccess,
sum (case when ScoreType='管理岗' and Score='不合格' then 1 else 0 end) as manageFail,
sum (case when ScoreType='操作岗' and Score='合格' then 1 else 0 end)as operateSuccess ,sum (case when ScoreType='操作岗' and Score='不合格' then 1 else 0 end) as operateFail
from hse_import,hse_score where
hse_import.batchId=hse_score.batchId and hse_import.createdTime between @startTime and @endTime
怎么绑定到Gridview 一般的绑定字段<asp:BoundField HeaderText="总数" DataField ="id" />
但是我这个怎么弄啊
在线等
CREATE PROCEDURE usp_Statistic_HseScoreStat (@startTime DateTime ,@endTime DateTime)as select count(distinct hse_import.batchId) as scoreCount,
sum (case when ScoreType='管理岗' and Score='合格' then 1 else 0 end) as manageSuccess,
sum (case when ScoreType='管理岗' and Score='不合格' then 1 else 0 end) as manageFail,
sum (case when ScoreType='操作岗' and Score='合格' then 1 else 0 end)as operateSuccess ,sum (case when ScoreType='操作岗' and Score='不合格' then 1 else 0 end) as operateFail
from hse_import,hse_score where
hse_import.batchId=hse_score.batchId and hse_import.createdTime between @startTime and @endTime
怎么绑定到Gridview 一般的绑定字段<asp:BoundField HeaderText="总数" DataField ="id" />
但是我这个怎么弄啊
在线等
解决方案 »
- 跪求Transfer-Encoding: chunked的解析代码!!
- 弱弱地一下关于正则表达存入string类的问题
- c#神奇啊 。。。。。怎么回事???
- 如何选择tabPage控件中的子空间pictureBox?
- 请问,GridView上的 如何删除该行数据,行ID已经选定 不知道用什么函数
- ***********《设计模式》作者之一John Vlissides逝世,表示悲哀的进来顶一下,并说说你的心里话************
- DOM操作XML的数据结果存在疑惑
- winform的内存问题
- 水晶报表点击打击按钮,出现“RPC服务器不可用”提示,无法完成打印???
- C#启动问题
- DataGridView 样式,谁有漂亮点发出来大家共享吧
- 【送全分】请教Dev带图片的报表导出Excel后中无法复制粘贴的问题
<asp:BoundField HeaderText="总数" DataField ="scoreCount" />
<ItemTemplate>
<asp:Label ID="lblryjs" runat="server" Text='<%# Eval("scoreCount") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>