unit Unit8;

interface

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

type
  TForm8 = class(TForm)
    Panel1: TPanel;
    GroupBox2: TGroupBox;
    Label2: TLabel;
    Label3: TLabel;
    banjibox: TComboBox;
    xueqibox: TComboBox;
    Memo: TMemo;
    BitBtn4: TBitBtn;
    BitBtn5: TBitBtn;
    BitBtn6: TBitBtn;
    Label1: TLabel;
    Label4: TLabel;
    procedure FormCreate(Sender: TObject);
    procedure banjiboxChange(Sender: TObject);
    procedure BitBtn5Click(Sender: TObject);
    procedure BitBtn6Click(Sender: TObject);
    procedure BitBtn4Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form8: TForm8;

implementation

uses Unit1;

{$R *.dfm}

procedure TForm8.FormCreate(Sender: TObject);
var
my_adoquery:Tadoquery;
sqlstring:string;
str:string;
data_path:string;
begin
  data_path:=application.GetNamePath+'user/'+form1.user+'/班級.mdb';
  my_adoquery:=Tadoquery.Create(self);
  my_adoquery.connectionstring:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+data_path+';';
  sqlstring:='select * from 班級表';
  with my_adoquery do
    begin
      close;
      sql.Clear;
      sql.Add(sqlstring);
      open;
       first;
       while not eof do
         begin
           banjibox.Items.Add(fieldbyname('名稱').asstring);
           //xueqibox.Items.Add(fieldbyname('學制').asstring);
           next;
         end;
      end;
end;

procedure TForm8.banjiboxChange(Sender: TObject);
var
my_adoquery:Tadoquery;
sqlstring:string;
str:string;
data_path:string;
i,xuezhi:integer;
begin
  data_path:=application.GetNamePath+'user/'+form1.user+'/班級.mdb';
  my_adoquery:=Tadoquery.Create(self);
  my_adoquery.connectionstring:='Provider=Microsoft.Jet.OLEDB.4.0;Data Source='+data_path+';';
  sqlstring:='select * from 班級表 where 名稱=:mc';
  xueqibox.Clear;
  with my_adoquery do
    begin
      close;
      sql.Clear;
      sql.Add(sqlstring);
      Parameters.ParamByName('mc').Value:=trim(banjibox.Text);
      open;
      xuezhi:=fieldbyname('學制').AsInteger;
       end;
    for i:=1 to xuezhi*2 do
     xueqibox.Items.Add(inttostr(i));

    end;

procedure TForm8.BitBtn5Click(Sender: TObject);
var
str:string;
i:integer;
data_path:string;
begin
if (banjibox.Text='') or (xueqibox.Text='') or (memo.Text='') then
begin
showmessage('請輸入完整信息！');
exit;
end;
data_path:=application.GetNamePath+'user/'+form1.user+'/'+trim(banjibox.text)+'.mdb';
str:='create table 第'+xueqibox.text+'學期成績表(編號 COUNTER PRIMARY KEY,學號 char(20),姓名 char(10),';
for i:=1 to memo.Lines.Count-1 do
begin
str:=str+memo.Lines.Strings[i]+' float,';
end;
str:=str+'總分 float,平均分 float)';
//showmessage(str);
form1.createdatasheet(data_path,str);
showmessage('設置成功!')
end;

procedure TForm8.BitBtn6Click(Sender: TObject);
begin
close;
end;

procedure TForm8.BitBtn4Click(Sender: TObject);
begin
memo.Clear;
end;

end.