关于DBGRIDEH的行、列顺序号 delphi中的DBGridEh的行、列值是否可以向execl中的行显示1\2\3\4,列A\B\C\D这样显示 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 view.Columns[0].Caption := '';view.Columns[1].Caption := 'A';view.Columns[2].Caption := 'B';再把 DataSet 建一个字段,指向 Columns[0],第一个字段的值写1,2,3,4,5啥的~~~ 自己代码写出来吧,列的标头都是可以自己设置的,如果是自动生成,可以在sql中把字段拼出来,比如select fiel1 as A from tableA unit Unit1;interfaceusesWindows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,Dialogs, DB, ADODB, Grids, DBGrids;typeTForm1 = class(TForm)DataSource1: TDataSource;DBGrid1: TDBGrid;ADOConnection1: TADOConnection;ADOTable1: TADOTable;procedure DataSource1StateChange(Sender: TObject);procedure DBGrid1DrawColumnCell(Sender: TObject; const Rect: TRect;DataCol: Integer; Column: TColumn; State: TGridDrawState);private{ Private declarations }FirstRecNo: integer;public{ Public declarations }end;TDataSetEx= class(TDataSet);varForm1: TForm1;implementation{$R *.dfm}procedure TForm1.DataSource1StateChange(Sender: TObject);beginwith TDataSource(Sender) dobeginFirstRecNo := DataSet.RecordCount - TDataSetEx(DataSet).ActiveRecord; 字串8end;end;procedure TForm1.DBGrid1DrawColumnCell(Sender: TObject; const Rect: TRect;DataCol: Integer; Column: TColumn; State: TGridDrawState);vari: integer;beginInherited;with TDBGrid(sender) dobeginif (DataCol =0) thenbeginif DataSource.State <> DsInsert theni:= DataSource.DataSet.RecNoelsei:= FirstRecNo + Rect.Top div 19;Canvas.TextRect(rect,Rect.Left+2, Rect.Top+2, inttostr(i));end;end;end;end. 局域网文件传输问题 Delphi 存储过程 Execproc Stack overflow 一个简单的问题! 关于水表自动过圈的问题~~ 为什么这个程序会不停的从0到40000执行,怎么不会停止呢? 现金购买,网上冲引客户端,要求2周内完成 storedproc的问题。 请教……还是进来看看看吧! 知者不难 WebBrowser操作问题Seclect,找了几天也没有找到解决方法,所以来此求助! 我想学数据库,各位建议一下哪些书好啊 如何使一个等待中的定时器得到信号? 在pagecontrol控件的不同页面连接不同的数据表的问题
view.Columns[1].Caption := 'A';
view.Columns[2].Caption := 'B';再把 DataSet 建一个字段,指向 Columns[0],第一个字段的值写1,2,3,4,5啥的~~~
select fiel1 as A from tableA
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, DB, ADODB, Grids, DBGrids;type
TForm1 = class(TForm)
DataSource1: TDataSource;
DBGrid1: TDBGrid;
ADOConnection1: TADOConnection;
ADOTable1: TADOTable;
procedure DataSource1StateChange(Sender: TObject);
procedure DBGrid1DrawColumnCell(Sender: TObject; const Rect: TRect;
DataCol: Integer; Column: TColumn; State: TGridDrawState);
private
{ Private declarations }
FirstRecNo: integer;
public
{ Public declarations }
end;TDataSetEx= class(TDataSet);var
Form1: TForm1;implementation{$R *.dfm}procedure TForm1.DataSource1StateChange(Sender: TObject);
begin
with TDataSource(Sender) do
begin
FirstRecNo := DataSet.RecordCount - TDataSetEx(DataSet).ActiveRecord; 字串8end;
end;procedure TForm1.DBGrid1DrawColumnCell(Sender: TObject; const Rect: TRect;
DataCol: Integer; Column: TColumn; State: TGridDrawState);
var
i: integer;
begin
Inherited;
with TDBGrid(sender) do
begin
if (DataCol =0) then
begin
if DataSource.State <> DsInsert then
i:= DataSource.DataSet.RecNo
else
i:= FirstRecNo + Rect.Top div 19;
Canvas.TextRect(rect,Rect.Left+2, Rect.Top+2, inttostr(i));
end;
end;
end;end.