AccessDBCase.pas 978 B

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849
  1. unit AccessDBCase;
  2. interface
  3. uses
  4. Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  5. Dialogs, ADODB, Grids, DBGrids, DB;
  6. type
  7. TForm7 = class(TForm)
  8. con1: TADOConnection;
  9. ds1: TADODataSet;
  10. ds2: TDataSource;
  11. dbgrd1: TDBGrid;
  12. procedure FormCreate(Sender: TObject);
  13. procedure FormDestroy(Sender: TObject);
  14. private
  15. { Private declarations }
  16. public
  17. { Public declarations }
  18. end;
  19. var
  20. Form7: TForm7;
  21. implementation
  22. {$R *.dfm}
  23. procedure TForm7.FormCreate(Sender: TObject);
  24. begin
  25. con1.ConnectionString := 'Provider=Microsoft.Jet.OLEDB.4.0; Data Source=MessageHistory.DAT;';
  26. // ShowMessage('1');
  27. con1.Connected := True;
  28. // ShowMessage('2');
  29. ds1.CommandText := 'SELECT TOP 8 * FROM MESSAGES';
  30. // ShowMessage('3');
  31. ds1.Open;
  32. // ShowMessage('4');
  33. end;
  34. procedure TForm7.FormDestroy(Sender: TObject);
  35. begin
  36. ds1.Close;
  37. con1.Connected := False;
  38. end;
  39. end.