unit2.pas

用delphi编写的学生学籍管理系统

unit Unit2;

interface

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

type
  TForm2 = class(TForm)
    DS_student: TDataSource;
    Label1: TLabel;
    DBGrid1: TDBGrid;
    DBNavigator1: TDBNavigator;
    T_student: TADOTable;
    procedure FormCreate(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form2: TForm2;

implementation

{$R *.dfm}
procedure TForm2.FormCreate(Sender: TObject);
begin
T_student.ConnectionString:='Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=mydb';
T_student.Open;										//打开数据表
DBGrid1.Columns[0].Width:=64;							//设置列宽
DBGrid1.Columns[1].Width:=64;
DBGrid1.Columns[2].Width:=64;
DBGrid1.Columns[3].Width:=64;
DBGrid1.Columns[4].Width:=30;
DBGrid1.Columns[5].Width:=100;
end;

procedure TForm2.FormClose(Sender: TObject; var Action: TCloseAction);
begin
  T_student.close;
  T_student.ConnectionString:='';
end;

end.