如何在asp.net Gridview中计算行数 [英] How to count row wise in asp.net Gridview

问题描述

亲爱的朋友，



正在使用c＃和SqlServer 2005在asp.net Gridview上工作。



我的网页上有一个gridview，我在数据库中有大量的数据。我想在gridview中显示行数计数



Department TotalNoofRecs

-------- ------ -------

IT 30

工程36

电信22

建筑46




我希望在gridview中显示，这些记录已经输入数据库了。

只是我想根据部门显示行。



请帮助我谢谢。

Dear frnds,

am working on asp.net Gridview, using c# and SqlServer 2005.

I have a gridview on my webpage, I have huge amount of data in database. I want to display row wise count in gridview as

Department TotalNoofRecs
-------- -------------
IT 30
Engineering 36
Telecom 22
Construction 46


Same as it is i want to display in gridview, these records are already entered in database.
Just i want to display row wise according to department.

Please can you help me thanks.

推荐答案

更改您的查询以获得分组结果。

例如选择dept，count *）来自table1 group by dept

Change your query to get group wise results.
For e.g. select dept, count*) from table1 group by dept

这篇关于如何在asp.net Gridview中计算行数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！