怎样根据不同的条件为SQL查询的某个字段加入不同的颜色???
比如:SELECT WorkAttendence_DaySetting.datetime, CONVERT(varchar(10),
WorkAttendance_Data.OnDuty, 108) AS OnDuty , CONVERT(varchar(10),
WorkAttendance_Data.OffDuty, 108) AS OffDuty, WorkAttendance_Data.User_ID,
WorkAttendence_Memo_1.Memo AS OffDuty_Memo,WorkAttendence_Memo_2.Memo AS OnDuty_Memo
FROM WorkAttendance_Data LEFT OUTER JOIN
WorkAttendence_Memo WorkAttendence_Memo_1 ON WorkAttendance_Data.OffDuty_MemoID = WorkAttendence_Memo_1.ID LEFT OUTER JOIN
WorkAttendence_Memo WorkAttendence_Memo_2 ON WorkAttendance_Data.OnDuty_MemoID = WorkAttendence_Memo_2.ID RIGHT OUTER JOIN
WorkAttendence_DaySetting ON WorkAttendance_Data.WorkDate = WorkAttendence_DaySetting.datetime
WHERE (WorkAttendence_DaySetting.datetime BETWEEN '2006-3-1' AND '2006-3-31') AND (WorkAttendance_Data.User_ID = '39')得到如下的结果:
datatime OnDuty OffDuty User_id OnDuty_Status OffDuty_Status
2006-3-21 8:40 14:30 1 1 0
2006-3-22 8:30 15:40 39 0 1
而我想要的结果是这样的:
根据条件:如果OnDuty_Status=1,那么OnDuty的数据以红色显示,如果OffDuty_Status=1,那么OffDuty的数据以红色显示:
datatime OnDuty OffDuty User_id OnDuty_Status OffDuty_Status
2006-3-21 8:40(红) 14:30 1 1 0
2006-3-22 8:30 15:40(红) 39 0 1愿尝试各种方法。还请大家多多帮助小弟呀。
比如:SELECT WorkAttendence_DaySetting.datetime, CONVERT(varchar(10),
WorkAttendance_Data.OnDuty, 108) AS OnDuty , CONVERT(varchar(10),
WorkAttendance_Data.OffDuty, 108) AS OffDuty, WorkAttendance_Data.User_ID,
WorkAttendence_Memo_1.Memo AS OffDuty_Memo,WorkAttendence_Memo_2.Memo AS OnDuty_Memo
FROM WorkAttendance_Data LEFT OUTER JOIN
WorkAttendence_Memo WorkAttendence_Memo_1 ON WorkAttendance_Data.OffDuty_MemoID = WorkAttendence_Memo_1.ID LEFT OUTER JOIN
WorkAttendence_Memo WorkAttendence_Memo_2 ON WorkAttendance_Data.OnDuty_MemoID = WorkAttendence_Memo_2.ID RIGHT OUTER JOIN
WorkAttendence_DaySetting ON WorkAttendance_Data.WorkDate = WorkAttendence_DaySetting.datetime
WHERE (WorkAttendence_DaySetting.datetime BETWEEN '2006-3-1' AND '2006-3-31') AND (WorkAttendance_Data.User_ID = '39')得到如下的结果:
datatime OnDuty OffDuty User_id OnDuty_Status OffDuty_Status
2006-3-21 8:40 14:30 1 1 0
2006-3-22 8:30 15:40 39 0 1
而我想要的结果是这样的:
根据条件:如果OnDuty_Status=1,那么OnDuty的数据以红色显示,如果OffDuty_Status=1,那么OffDuty的数据以红色显示:
datatime OnDuty OffDuty User_id OnDuty_Status OffDuty_Status
2006-3-21 8:40(红) 14:30 1 1 0
2006-3-22 8:30 15:40(红) 39 0 1愿尝试各种方法。还请大家多多帮助小弟呀。
解决方案 »
- 求助:编写C#程序从SQL Server数据库读取表中数据,显示格式无法对齐
- C# File和FileInfo怎样读取和修改文件的属性?
- c# 如何控制父窗体(winform)让他在子窗体的用户控件的指令没运行完时不能关闭
- 帮忙看下这几行代码!
- 在C#中怎样在客户端给gridview添加一行,不加入数据库,不刷新页面! ~急!~ 在线等~
- using(connection)能不能自动关闭连接
- DataTable中删除行的记录问题。
- C#连接ACCESS数据库出现如下错误:数据库没设置密码连接正常,如果设置了密码,并在连接时提供了密码,出现信息文件丢失或文件正被其他用
- gridview checkbox 分页 删除,不要DataGrid的例子。
- MySQL数据库问题
- "未将对象引用设置到对象的实例"怎么解决?谢谢...
- 为什么我打印时不能让标题居中?
根据什么条件加啊。
使用
select case field when '' then ''
when '2' then 's'
end
from table
的值把OnDuty对应的Cell的Text前后加个"<font color=red>"+cell.text+"</font>"不就行了。
{
e.items.cell[1].text="<font color=red>"+cell.text+"</font>"
}