unit1.~pas

sql server 2005书中11到16章的全部代码

unit Unit1;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, TeEngine, Series, DB, ExtCtrls, TeeProcs, Chart,
  DbChart, Grids, DBGrids, ADODB;

type
  TForm1 = class(TForm)
    ADOQuery1: TADOQuery;
    DBGrid1: TDBGrid;
    DBChart1: TDBChart;
    DataSource1: TDataSource;
    Series1: TBarSeries;
    Button1: TButton;
    Label1: TLabel;
    DBChart2: TDBChart;
    Series2: TBarSeries;
    DBChart3: TDBChart;
    Series3: TBarSeries;
    Label2: TLabel;
    ComboBox1: TComboBox;
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.Button1Click(Sender: TObject);
begin
adoquery1.Close ;
adoquery1.SQL.Clear ;
adoquery1.SQL.Add('select * from stu order by ' +combobox1.Text )  ;
adoquery1.Open ;

end;

end.