unit22.pas

教学管理系统源码

unit Unit22;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, ExtDlgs, DBCtrls, DB, ADODB, StdCtrls, Grids, DBGrids, ExtCtrls,
  Mask, Buttons;

type
  TForm22 = class(TForm)
    Label1: TLabel;
    Bevel1: TBevel;
    Label2: TLabel;
    Bevel2: TBevel;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    DBGrid1: TDBGrid;
    ComboBox1: TComboBox;
    Label13: TLabel;
    ComboBox2: TComboBox;
    ComboBox3: TComboBox;
    ADOQuery1: TADOQuery;
    DataSource1: TDataSource;
    Label14: TLabel;
    Label15: TLabel;
    Bevel3: TBevel;
    DBEdit1: TDBEdit;
    DBEdit2: TDBEdit;
    DBEdit3: TDBEdit;
    DBEdit4: TDBEdit;
    DBEdit5: TDBEdit;
    DBEdit6: TDBEdit;
    DBEdit7: TDBEdit;
    DBEdit8: TDBEdit;
    DBEdit9: TDBEdit;
    DBEdit10: TDBEdit;
    DBEdit11: TDBEdit;
    DBEdit12: TDBEdit;
    BitBtn1: TBitBtn;
    procedure ComboBox1Change(Sender: TObject);
    procedure ComboBox2Change(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form22: TForm22;
  
implementation

uses Unit1;

{$R *.dfm}

procedure TForm22.ComboBox1Change(Sender: TObject);
begin

      ADOQuery1.Close;
      ADOQuery1.SQL.Clear;
      ADOQuery1.SQL.Add('SELECT * FROM 教师基本档案 WHERE 教师姓名= '''+ComboBox1.Text+''' ');
      ADOQuery1.Open;
      Bitbtn1.Glyph.LoadFromFile(adoquery1.FieldByName('照片').Value);
      //DBImage1.Picture.LoadFromFile(ADOQuery1.FieldValues['照片']);
end;

procedure TForm22.ComboBox2Change(Sender: TObject);
begin

      ADOQuery1.Close;
      ADOQuery1.SQL.Clear;
      ADOQuery1.SQL.Add('SELECT * FROM 教师基本档案 WHERE 教师编号= '''+ComboBox2.Text+''' ');

      ADOQuery1.Open;
     Bitbtn1.Glyph.LoadFromFile(adoquery1.FieldByName('照片').Value);

end;



end.