backpage.pas

delphi+sql server 我是delphi的初学者

unit backpage;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, Buttons, ExtCtrls, ComCtrls;

type
  Tfrmbackpage = class(TForm)
    Panel1: TPanel;
    Panel2: TPanel;
    Button1: TButton;
    Button2: TButton;
    DateTimePicker1: TDateTimePicker;
    DateTimePicker2: TDateTimePicker;
    CDD: TComboBox;
    Label1: TLabel;
    Label2: TLabel;
    Label3: TLabel;
    procedure Button2Click(Sender: TObject);
    procedure FormShow(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  frmbackpage: Tfrmbackpage;

implementation
uses UDM;
{$R *.dfm}

procedure Tfrmbackpage.Button2Click(Sender: TObject);
begin
  close;
end;

procedure Tfrmbackpage.FormShow(Sender: TObject);
begin
  CDD.Text:='';
 with dm.qrytemp do
  begin
    close;
    sql.Clear;
    sql.Add('select * from ly_place');
    prepared;
    open;
  end;
  Cdd.Items.Clear;
  while not dm.qrytemp.Eof do
  begin
    Cdd.Items.Append(dm.qrytemp.Fields[2].asstring);
    dm.qrytemp.Next;
  end;
  DateTimePicker1.Date:=Date;
  DateTimePicker2.Date:=Date;

end;

end.