If Thing.SelectedItem.Value <> "-1 " Then
Select Case Thing.SelectedItem.Text
Case "迟到 "
sql = "select ClassName as 班级,Stu_name as 姓名, Times as 迟到 from KQRecord ,Class,Profession,Department ,Affair where KQRecord.ClassID=Class.ClassID and Class.ProfessionID=Profession.ProfessionID and Profession.DepartmentID=Department.DepartmentID and Affair.AffairID=KQRecord.AffairID and Riqi > ' " & Sdate.Value & " ' and Riqi < ' " & Edate.Value & " ' and AffairName= '迟到 ' "
Case "早退 "
sql = "select ClassName as 班级,Stu_name as 姓名, Times as 早退 from KQRecord ,Class,Profession,Department ,Affair where KQRecord.ClassID=Class.ClassID and Class.ProfessionID=Profession.ProfessionID and Profession.DepartmentID=Department.DepartmentID and Affair.AffairID=KQRecord.AffairID and Riqi > ' " & Sdate.Value & " ' and Riqi < ' " & Edate.Value & " 'and AffairName= '早退 ' "
End Select
End If 这样我查询出班级、姓名、早退或者迟到的次数。
If Thing.SelectedItem.Value = "-1 " Then
sql = " "
End If 这里我想要查询出班级、姓名、迟到（次数）、早退（次数）、旷课（次数）这条语句怎么写啊`，还是要让 GridView动态的产生几列呢？如果要动态产生几列又是怎么弄啊`？（数据库中Affair表包括AffairID字段、AffairName字段，KQRecord表中也有AffairID字段）谢谢了``
------解决方案--------------------------------------------------------
帮顶,一起期待高手解决!!!!!!!!!!!
------解决方案--------------------------------------------------------
select ClassName as 班级,Stu_name as 姓名,迟到次数=sum (case AffairName when '迟到 ' then 1 else 0 end),早退次数=sum (case AffairName when '早退 ' then 1 else 0 end) from KQRecord ,Class,Profession,Department ,Affair where KQRecord.ClassID=Class.ClassID and Class.ProfessionID=Profession.ProfessionID and Profession.DepartmentID=Department.DepartmentID and Affair.AffairID=KQRecord.AffairID and Riqi > ' " & Sdate.Value & " ' and Riqi < ' " & Edate.Value & " ' " GROUP BY Stu_ID, Stu_Name, ClassName,AffairName
----------------我只写了迟到和早退，其他的自己照着写吧
------解决方案--------------------------------------------------------
SELECT CLASSNAME AS 班级,
STU_NAME AS 姓名,