1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100
| unit Unit1;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, Grids, DBGrids, StdCtrls, Oracle, DB, OracleData, DBClient;
type
Tfrm_TestConnectOracleDBGrid = class(TForm)
bt_Connect: TButton;
bt_Req: TButton;
DBGrid1: TDBGrid;
bt_Quitter: TButton;
OracleSession1: TOracleSession;
OracleDataSet1: TOracleDataSet;
DataSource1: TDataSource;
bt_Deco: TButton;
OracleLogon1: TOracleLogon;
ClientDataSet: TClientDataSet;
procedure bt_QuitterClick(Sender: TObject);
procedure bt_ConnectClick(Sender: TObject);
procedure bt_ReqClick(Sender: TObject);
procedure bt_DecoClick(Sender: TObject);
private
{ Déclarations privées }
public
{ Déclarations publiques }
// procedure CopieDataSet(OracleDataSet : TOracleDataSet; ClientDataSet : TClientDataSet);
end;
var
frm_TestConnectOracleDBGrid: Tfrm_TestConnectOracleDBGrid;
username : String;
password : String;
database : String;
procedure CopieDataSet(OracleDataSet : TOracleDataSet; ClientDataSet : TClientDataSet);
implementation
{$R *.dfm}
procedure Tfrm_TestConnectOracleDBGrid.bt_QuitterClick(Sender: TObject);
begin
frm_TestConnectOracleDBGrid.Close;
end;
procedure Tfrm_TestConnectOracleDBGrid.bt_ConnectClick(Sender: TObject);
begin
OracleLogon1.Execute;
username := OracleSession1.LogonUsername;
password := OracleSession1.LogonPassword;
database := OracleSession1.LogonDatabase;
end;
procedure Tfrm_TestConnectOracleDBGrid.bt_ReqClick(Sender: TObject);
begin
if OracleSession1.Connected = True then
begin
OracleDataSet1.Open;
CopieDataSet(OracleDataSet1, ClientDataSet);
ClientDataSet.Open;
end
else
begin
OracleSession1.LogonUsername := username;
OracleSession1.LogonPassword := password;
OracleSession1.LogonDatabase := database;
OracleSession1.LogOn;
OracleDataSet1.Open;
ClientDataSet.Open;
end;
OracleSession1.LogOff;
end;
procedure Tfrm_TestConnectOracleDBGrid.bt_DecoClick(Sender: TObject);
begin
OracleSession1.LogOff;
end;
procedure CopieDataSet(OracleDataSet : TOracleDataSet; ClientDataSet : TClientDataSet);
var
i : integer;
begin
ClientDataSet.Close();
ClientDataSet.FieldDefs.Clear();
// ClientDataSet.FieldDefs.Assign(OracleDataSet.FieldDefs);
for i := 0 to OracleDataSet.FieldCount - 1 do
ClientDataSet.FieldDefs.Add(OracleDataSet.Fields[i].FieldName, OracleDataSet.Fields[i].DataType, OracleDataSet.Fields[i].Size);
ClientDataSet.CreateDataSet();
while not OracleDataSet.Eof do
begin
ClientDataSet.Append;
for i := 0 to OracleDataSet.FieldCount - 1 do
ClientDataSet.Fields[I].Value := OracleDataSet.Fields[I].Value;
ClientDataSet.Post;
OracleDataSet.Next;
end;
end;
end. |
Partager