unit savecomponent1;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
  StdCtrls, Db, DBTables;

type
  TForm1 = class(TForm)
    Button1: TButton;
    Query1: TQuery;
    ListBox1: TListBox;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    Label1: TLabel;
    Query2: TQuery;
    Button5: TButton;
    Edit1: TEdit;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
    procedure Button5Click(Sender: TObject);
    procedure Edit1KeyPress(Sender: TObject; var Key: Char);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.DFM}

procedure TForm1.Button1Click(Sender: TObject);
var
  F:TMemoryStream;
  Path:string;
  Filename:string;
begin
  Path:=ExtractFilePath(application.ExeName);
  FileName:=Path+'ListBox.ini';
  F:=TMemorystream.Create ;
  F.WriteComponent(Listbox1);
  F.SaveToFile(Filename);
  F.Free;
  listbox1.Free;
end;

procedure TForm1.Button2Click(Sender: TObject);
var
  F:TMemoryStream;
  Path:string;
  Filename:string;
  xx:Tlistbox;
begin
  xx:=Tlistbox.create(self);
  xx.parent:=self;
  Path:=ExtractFilePath(application.ExeName);
  FileName:=Path+'ListBox.ini';
  F:=TMemorystream.Create ;
  F.LoadFromFile(Filename);
  xx:=TListBox(F.ReadComponent(xx));
  F.Free;
end;

procedure TForm1.Button3Click(Sender: TObject);
var
  Path:string;
  Filename:string;
begin
  Path:=ExtractFilePath(application.ExeName);
  FileName:=Path+'ListBox.ini';
  with query1 do
    begin
      close;requestlive:=true;sql.clear;databasename:='OILREP44444';
      SQL.Add('select * from zy_query');
      open;insert;
      fieldbyname('qry_id').asinteger:=strtoint(edit1.text);
      TBlobfield(Fieldbyname('sql_blob')).loadfromfile(Filename);
      try
        post;
      except
        close;
      end;
    end;
end;

procedure TForm1.Button4Click(Sender: TObject);
var
  Path:string;
  Filename:string;
begin
  Path:=ExtractFilePath(application.ExeName);
  FileName:=Path+'ListBox.ini';
  with query1 do
    begin
      close;sql.clear;databasename:='OILREP44444';
      SQL.Add('select * from zy_query where qry_id=:qq');
      params[0].AsInteger:=strtoint(edit1.text);
      try
        open;
        TBlobfield(Fieldbyname('sql_blob')).savetofile(Filename);
      except
        close;
      end;
    end;
end;

procedure TForm1.Button5Click(Sender: TObject);
begin
listbox1.Free;
end;