在SQL Server中可以用以下SQL语句SELECT Name AS 姓名, CASE sex WHEN 1 THEN '男' WHEN 2 THEN '女' END AS 性别 FROM TABLE1
SELECT Name AS 姓名, CASE sex WHEN trye THEN '男' WHEN false THEN '女' END AS 性别 FROM TABLE1
呵呵, 又弄错了, 是下面的 SELECT Name AS 姓名, CASE sex WHEN true THEN '男' WHEN false THEN '女' END AS 性别 FROM TABLE1
也可以在DBGRID的事件中实现啊,不过,楼上的方法好些。 procedure TfrmBetterCust.DBGrid1DrawColumnCell(Sender: TObject; const Rect: TRect; DataCol: Integer; Column: TColumn; State: TGridDrawState); var str:Boolean; begin if Column.FieldName='性别' then begin str:=Column.Field.AsBoolean ; if str then begin DBGrid1.Canvas.Font.Color:=clRed; DBGrid1.Canvas.TextOut(Rect.Left+1,Rect.Top+2,'男'); end else begin DBGrid1.Canvas.Font.Color:=clBlue; DBGrid1.Canvas.TextOut(Rect.Left+1,Rect.Top+2,'女'); end; end else DBGrid1.DefaultDrawDataCell(Rect,Column.Field,state); end;
需要将全部字段显示出来不止是姓名,性别。SQL该怎样写,谢谢!
SELECT Name AS 姓名, CASE sex WHEN true THEN '男' WHEN false THEN '女' END AS 性别, Age as 年龄, ...........//需要什么就可以添加什么 FROM TABLE1
CASE sex WHEN 1 THEN '男' WHEN 2 THEN '女' END AS 性别
FROM TABLE1
CASE sex WHEN trye THEN '男' WHEN false THEN '女' END AS 性别
FROM TABLE1
SELECT Name AS 姓名,
CASE sex WHEN true THEN '男' WHEN false THEN '女' END AS 性别
FROM TABLE1
procedure TfrmBetterCust.DBGrid1DrawColumnCell(Sender: TObject;
const Rect: TRect; DataCol: Integer; Column: TColumn;
State: TGridDrawState);
var
str:Boolean;
begin
if Column.FieldName='性别' then
begin
str:=Column.Field.AsBoolean ;
if str then
begin
DBGrid1.Canvas.Font.Color:=clRed;
DBGrid1.Canvas.TextOut(Rect.Left+1,Rect.Top+2,'男');
end
else
begin
DBGrid1.Canvas.Font.Color:=clBlue;
DBGrid1.Canvas.TextOut(Rect.Left+1,Rect.Top+2,'女');
end;
end
else
DBGrid1.DefaultDrawDataCell(Rect,Column.Field,state);
end;
CASE sex WHEN true THEN '男' WHEN false THEN '女' END AS 性别,
Age as 年龄,
...........//需要什么就可以添加什么
FROM TABLE1