Retrieve multi-result set with ADO (Delphi)

unit Unit1;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, DB, ADODB, Grids, DBGrids, FMTBcd, DBXpress,
  DBClient, ComObj;

type
  TForm1 = class(TForm)
    Button1: TButton;
    Memo1: TMemo;
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

uses Unit2;

{$R *.dfm}

procedure TForm1.Button1Click(Sender: TObject);
var
  AQry: TADOQuery;
  ADS: TCustomADODataSet;
  RowAffected, Seq: Integer;
begin
  AQry := TADOQuery.Create(Self);
  ADS := TCustomADODataSet.Create(Self);
  AQry.ConnectionString :=
    'Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=pubs;Data Source=.';
  AQry.SQL.Text := 'select * from jobs' + #13#10 + ' select * from employee';

  Seq := 1;

  try
    AQry.Open;
    ADS.Recordset := AQry.Recordset;

    while ADS.Recordset <> nil do
    begin
      TfrmData.CreateDataForm(Self, ADS.Recordset, Seq).Show;
      Inc(Seq);
      ADS.Recordset := AQry.NextRecordSet(RowAffected);
    end;
  finally
    FreeAndNil(AQry);
    FreeAndNil(ADS);   
  end;

  Button1.Enabled := false;
end;

end.
 
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值