unit Unit3;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, DB, ADODB, Grids, DBGrids;

type
  TCouseListForm = class(TForm)
    DBGrid1: TDBGrid;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    procedure FormCreate(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  CouseListForm: TCouseListForm;

implementation
 uses Unit1;
{$R *.dfm}

procedure TCouseListForm.FormCreate(Sender: TObject); //顯示課程總表
begin
  ADOQuery1.Close;
  ADOQuery1.SQL.Clear;
  ADOQuery1.SQL.Add('select cno,cname,teacher,class,kind,credit from course order by cno') ;
  ADOQuery1.Open;
end;

end.