unit1.pas

来自「这是delphi 的入门代码是我们为了一次考试而准备的」· PAS 代码 · 共 42 行

unit Unit1;

interface

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

type
  TForm1 = class(TForm)
    ADOConnection1: TADOConnection;
    ADODataSet1: TADODataSet;
    ADOTable1: TADOTable;
    DataSource1: TDataSource;
    DataSource2: TDataSource;
    DBGrid1: TDBGrid;
    DBGrid2: TDBGrid;
    procedure DBGrid1DblClick(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.dfm}

procedure TForm1.DBGrid1DblClick(Sender: TObject);
begin
  self.ADODataSet1.Close;
  //self.ADODataSet1.CommandText:='select * from selcourse where sno='+#39+self.ADOTable1.FieldByName('sno').AsString+#39;
  self.ADODataSet1.CommandText:='select * from selcourse where sno='+#39+self.DBGrid1.Fields[0].AsString+#39;
  self.ADODataSet1.Open;

end;

end.