我想用TAdoConnection的OpenSchema方法查看特定表字段详细信息,把它要求的参数全部传递进去,运行的时候会出错,大概的意思是说参数值有问题。哪位高手有现成的代码借鉴一下?不胜感激。
解决方案 »
- 如何解析二进制文件(无符号长整型)具体请参见!急!(xzwsun)
- 新手提问---多线程断点续传ftp软件--急急急!
- 一个小问题,可能有点难
- 大家好!请问怎样让DBGrid同时显示两个数据表的内容啊??
- 关于图像算法和MOVE函数问题????????????????????????????
- indy的demos,chat的client会死,怎么回事?
- 我一兄弟刚出去,在外很不爽,又上不了CSDN,特在此散分!希望大家都过得爽!!
- 一个关于combobox的简单问题.(解决就给分)
- 请大家帮忙!如何用程序获得dbgrid1--Columns[2]的焦点.....
- 请问论坛里面的帖子说怎么只有4页,以前的老帖子呢?
- 哪里有类似迅雷里的,树形 ListView 控件?我正在寻找中。
- 跪求!如何实现ReportBuilder代码控制页边距!!!!!!!!!!
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, DB, ADODB, Grids, DBGrids;type
TForm1 = class(TForm)
ADOConnection1: TADOConnection;
ADODataSet1: TADODataSet;
DataSource1: TDataSource;
DBGrid1: TDBGrid;
procedure FormCreate(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;var
Form1: TForm1;implementation{$R *.dfm}procedure TForm1.FormCreate(Sender: TObject);
begin
ADOConnection1.OpenSchema(siTables,EmptyParam,EmptyParam,ADODataSet1);
end;end.
Left = 192
Top = 107
Width = 696
Height = 480
Caption = 'Form1'
Color = clBtnFace
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -11
Font.Name = 'MS Sans Serif'
Font.Style = []
OldCreateOrder = False
OnCreate = FormCreate
PixelsPerInch = 96
TextHeight = 13
object DBGrid1: TDBGrid
Left = 64
Top = 128
Width = 320
Height = 120
DataSource = DataSource1
TabOrder = 0
TitleFont.Charset = DEFAULT_CHARSET
TitleFont.Color = clWindowText
TitleFont.Height = -11
TitleFont.Name = 'MS Sans Serif'
TitleFont.Style = []
end
object ADOConnection1: TADOConnection
ConnectionString =
'Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initi' +
'al Catalog=pubs;Data Source=.\sql2000'
Provider = 'SQLOLEDB.1'
Left = 176
Top = 200
end
object ADODataSet1: TADODataSet
Parameters = <>
Left = 144
Top = 48
end
object DataSource1: TDataSource
DataSet = ADODataSet1
Left = 88
Top = 40
end
end
EmptyParam,ADODataSet1);
Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
Db, ADODB, StdCtrls;type
TForm1 = class(TForm)
ADOConnection1: TADOConnection;
Button1: TButton;
ADODataSet1: TADODataSet;
procedure Button1Click(Sender: TObject);
private
{ Private declarations }
public
{ Public declarations }
end;var
Form1: TForm1;implementation{$R *.DFM}procedure TForm1.Button1Click(Sender: TObject);
var i:integer;
begin
adoconnection1.Connected := true;
adodataset1.Active := true;
adoconnection1.OpenSchema(sicolumns,vararrayof([Null,Null,'交易申请表']),EmptyParam,adodataset1);
//for i:= 0 to adodataset1.Recordset.Fields.count-1 do
while not adodataset1.eof do
begin
showmessage(adodataset1.Recordset.Fields.Item[i].Name);
adodataset1.Next;
end;
adodataset1.Active := false;
end;end.