liupeipei1234的专栏

首先在.aspx页面的gridview里写下      ' />   然后再后台.cs的gridviewd的RowCommand事件里写下：         //点击确认头像按钮         protected void GridView2_RowCommand(object sender, GridViewCommandEventArgs e)         {

首先sql语句先这样写：   SELECT *,case when Status='0' and UpTime>'" + DateTime.Now + "' then '未执勤' when Status='1' then '正在执勤' when Status='2'   then '已执勤' else '脱岗' end as state FROM 表名 ORDER BY ID desc