wwdbgrid如何显示行号

[Novelty]

wwdbgrid如何显示行号

[常遇道]

在SQL语句里想办法呗
SELECT rowno =
(SELECT count(row)
FROM (SELECT 1 AS row, *
FROM aa) AS a
WHERE a.name<= aa.name), *
FROM aa
ORDER BY name

[Novelty]

数据还未保存到数据库.

[ypnet]

ding

[summersky204608]

学习！

[angle097113]

对数据集增加一个字段，然后在这个字段的ongettext事件来完成，
在该事件中text := 数据集.recno 当然需要转化为字符串，在需要格外处理的就是如果为－1那么修改为1就OK

[angle097113]

或者

procedure TFrmLog.DBGridDrawColumnCell(Sender: TObject; const Rect: TRect;
DataCol: Integer; Column: TColumnEh; State: TGridDrawState);
begin
with DBGrid.DataSource.DataSet do
begin
if DataCol = 0 then
DBGrid.Canvas.TextRect(Rect, Rect.Left + 2, Rect.Top + 2, IntToStr(RecNo));
end;
end;