在GridView中用Filter统计SELECT (SELECT COUNT(*) FROM qqyy WHERE gh LIKE 'E%') AS '正式工', (SELECT COUNT(*) FROM qqyy WHERE gh NOT LIKE 'E%') AS '临时工'
如果在seclect还需要查询出绑定在gridview上的xm,gh,banbie,banci呢? string strSQL = "select xm,banbie,banci,gh,sum(case when left(gh,1)='E' then 1 else 0 end) as 正式工,sum(case when left(gh,1)='A' or left(gh,1)='B' then 1 else 0 end) as 派遣工 from qqyy"; 这样就会出错了
(SELECT COUNT(*) FROM qqyy WHERE gh NOT LIKE 'E%') AS '临时工'
这样就会出错了
比如还需要绑定xm,gh等信息.
恩,之前不是给你写过代码的嘛?你没看啊???http://topic.csdn.net/u/20110903/13/b6a5eb92-830a-48e6-b6d2-7a8375a18beb.html支持