unit Unit13;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs,unit7,unit1, StdCtrls, Grids, DBGrids, ExtCtrls;

type
  TForm13 = class(TForm)
    Panel1: TPanel;
    Label2: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    ComboBox3: TComboBox;
    ComboBox4: TComboBox;
    ComboBox5: TComboBox;
    ComboBox6: TComboBox;
    ComboBox7: TComboBox;
    Button1: TButton;
    Button2: TButton;
    Edit1: TEdit;
    procedure ComboBox4Change(Sender: TObject);
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form13: TForm13;

implementation

uses Unit6;

{$R *.dfm}

procedure TForm13.ComboBox4Change(Sender: TObject);
var
search:string;
begin
    search:=trim(combobox4.Text);
    datamodule7.ADOQuery1.Close;
    datamodule7.ADOQuery1.SQL.Clear;
    datamodule7.ADOQuery1.SQL.Add('select 系名 from sys where 院名='''+search+'''');
    datamodule7.ADOQuery1.Prepared;
    datamodule7.ADOQuery1.Open;
    while not datamodule7.ADOQuery1.Eof do
    begin
        search:=datamodule7.ADOQuery1.FieldValues['系名'];
        combobox5.Items.Add(search);     //注意！1！！！！！！！！！！！
        datamodule7.ADOQuery1.Next;
    end
end;

procedure TForm13.Button1Click(Sender: TObject);
var
  str: String;
begin
try
datamodule7.ADOConnection1.BeginTrans;
datamodule7.ADOQuery1.Close;
datamodule7.ADOQuery1.SQL.Clear;
str := 'update student set 學生名 = ''' + Edit1.Text + ''',班級='''+combobox3.text+''',系別='''+combobox4.text+''',專業='''+combobox5.text+''',學年='''+combobox6.text+''',學生類別='''+combobox7.text+'''' + ' where 學生號 = ''' + Form1.Edit1.Text +'''';
//showmessage(str);
datamodule7.ADOQuery1.SQL.Add(str);
//datamodule7.ADOQuery1.Parameters.ParamByName('教師名').Value := edit1.Text;
datamodule7.ADOQuery1.ExecSQL;
showmessage('修改成功!');
datamodule7.ADOConnection1.CommitTrans;
except
showmessage('修改失敗!');
datamodule7.ADOConnection1.RollbackTrans;
end;
edit1.Text:='';

end;

procedure TForm13.Button2Click(Sender: TObject);
begin
form6.show;
form13.Close;
end;

end.