SqlDataAdapter da = new SqlDataAdapter(“select username,userid,reported_status,(case auditcode when ‘2’ then ‘等待上报’ when ‘3’ then ‘成功上报’ when ‘4’ then ‘上报失败!’ when ‘0’ then ‘学员修改中’ when ‘1’ then ‘学员修改中’ end) as auditcode from base_user where ” + ac, con);
这其实完全是sql语句控制的,哈哈,Nice~