这几个是数据库控件的相应的设置。
qry.connection := ac1;
ds.DataSet := qry;
dxDBGrid1.DataSource := ds;
我是用TADOConnection连接的access数据库。unit Unit1;interfaceuses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, dxExEdtr, dxCntner, dxTL, dxDBCtrl, dxDBGrid, DB, ADODB;type
TForm1 = class(TForm)
AC1: TADOConnection;
qry: TADOQuery;
ds: TDataSource;
dxDBGrid1: TdxDBGrid;
procedure FormCreate(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;
function OpenQuery(query:TADOQuery;SqlStr:string;ShowMsg:boolean=true):boolean;overload;
var
Form1: TForm1;implementation{$R *.dfm}function OpenQuery(query:TADOQuery;SqlStr:string;ShowMsg:boolean=true):boolean;
begin
query.close;
query.Filter := '';
query.Filtered := false;
query.sql.clear;
query.sql.add(sqlstr);
try
query.open;
except
if ShowMsg then ShowMessage('打开'+query.name+'出错,sql语句为:'+sqlstr);
result := false;
exit;
end;
result := true;
end;procedure TForm1.FormCreate(Sender: TObject);
var
str :string;
a2 : TdxDBGridColumn;
begin
str := 'select * from address ';
with qry do
begin
a2.BandIndex := 0;
if not OpenQuery(qry,str) then exit;
a2:=TdxDBGridColumn(dxDBGrid1.CreateColumn(TdxDBGridColumn));
a2.Caption := '成绩';
a2.MinWidth := 120;
a2.Width := 120;
end;
end;
end.我应该怎样才能把表中的成绩一列显示在dxdbgrid1中,
麻烦大家指出应该在代码中修改,还是属性设置错误
还有就是TdxDBGridColumn的 FieldName有什么用,大家给一些dxDBGrid与dxDBTreelist的简单例子
qry.connection := ac1;
ds.DataSet := qry;
dxDBGrid1.DataSource := ds;
我是用TADOConnection连接的access数据库。unit Unit1;interfaceuses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, dxExEdtr, dxCntner, dxTL, dxDBCtrl, dxDBGrid, DB, ADODB;type
TForm1 = class(TForm)
AC1: TADOConnection;
qry: TADOQuery;
ds: TDataSource;
dxDBGrid1: TdxDBGrid;
procedure FormCreate(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;
function OpenQuery(query:TADOQuery;SqlStr:string;ShowMsg:boolean=true):boolean;overload;
var
Form1: TForm1;implementation{$R *.dfm}function OpenQuery(query:TADOQuery;SqlStr:string;ShowMsg:boolean=true):boolean;
begin
query.close;
query.Filter := '';
query.Filtered := false;
query.sql.clear;
query.sql.add(sqlstr);
try
query.open;
except
if ShowMsg then ShowMessage('打开'+query.name+'出错,sql语句为:'+sqlstr);
result := false;
exit;
end;
result := true;
end;procedure TForm1.FormCreate(Sender: TObject);
var
str :string;
a2 : TdxDBGridColumn;
begin
str := 'select * from address ';
with qry do
begin
a2.BandIndex := 0;
if not OpenQuery(qry,str) then exit;
a2:=TdxDBGridColumn(dxDBGrid1.CreateColumn(TdxDBGridColumn));
a2.Caption := '成绩';
a2.MinWidth := 120;
a2.Width := 120;
end;
end;
end.我应该怎样才能把表中的成绩一列显示在dxdbgrid1中,
麻烦大家指出应该在代码中修改,还是属性设置错误
还有就是TdxDBGridColumn的 FieldName有什么用,大家给一些dxDBGrid与dxDBTreelist的简单例子
解决方案 »
- 求一个teechart for delphi7.0!
- 关于advstringgrid中combobox的ID或标志的问题!
- DEIPHI在存储图片到ORACLE数据库中为什么ADO好用而BDE不好用呢?
- 如何用rave实现这样的打印?
- 一个专科生的烦恼
- 为什么我的程序运行大概几个小时后就会出现 OS FAILED
- 为什么我的程序(delphi+ado+mssqlserver)在win2000,XP下可以运行,而在WIN98下却不可以运行
- 想找限制edit输入字符 的有关贴子,在搜索中该填写什么关键字,给EDIT的输入增加输入限制
- 怎么让新打开的窗口自己居中?怎么去掉菜单缺省的快捷键?(946)
- 有关标题栏
- DbExpress(老枪)进来有问题请教
- 关于数据模型
也不行,是不是哪里还没有设置
a2.FieldName = '成绩';
procedure showGrid();
> begin
>
> egrid := TdxDBGrid.Create(self);
> egrid.Left := 456;
> egrid.Top := 108;
> egrid.height := 108;
> egrid.Width := 205;
> egrid.DataSource := dsCust;
> egrid.LookAndFeel := lfUltraFlat;
> egrid.DefaultFields := true;
> egrid.BeginUpdate;
> try
> egrid.KeyField := 'custno';
> egrid.OptionsDB := egrid.OptionsDB + [edgoLoadAllRecords];
> egrid.OptionsBehavior := egrid.OptionsBehavior + [edgoAutoSort];
> egrid.Filter.Active := True;
>
> // create a couple of columns...
> with egrid.CreateColumn(TdxDBGridColumn) do
> begin
> FieldName := 'custno';
> Caption := 'ticket';
> Visible := true;
> Width := 50;
> end;
>
> with egrid.CreateColumn(TdxDBGridColumn) do
> begin
> FieldName := 'company';
> Caption := 'Customer';
> Visible := true;
> Width := 170;
> end;
>
> finally
> egrid.EndUpdate;
> end;
>
> egrid.Visible := true;
>
如果123726969(铁棒磨成针,不是白痴是傻瓜) 解答了你的问题,请把分加给我;那是我另外一个号,我不打算升它。
上面那段代码的网址:
http://coding.derkeiler.com/Archive/Delphi/borland.public.delphi.thirdpartytools.general/2003-11/0537.html.