unit MainProject;

interface

uses
  Winapi.Windows, Winapi.Messages, System.SysUtils, System.Variants, System.Classes, Vcl.Graphics,
  Vcl.Controls, Vcl.Forms, Vcl.Dialogs, Vcl.Grids, Vcl.DBGrids, Data.DB,
  Vcl.OleCtrls, SHDocVw, Data.Win.ADODB, Vcl.StdCtrls;

type
  TForm1 = class(TForm)
    WebBrowser1: TWebBrowser;
    DataSource1: TDataSource;
    DataSource2: TDataSource;
    DBGrid1: TDBGrid;
    DBGrid2: TDBGrid;
    ADOConnection1: TADOConnection;
    ADOQuery1: TADOQuery;
    ADOQuery2: TADOQuery;
    Button2: TButton;
    procedure FormCreate(Sender: TObject);
    procedure DBGrid1CellClick(Column: TColumn);
    procedure DBGrid2CellClick(Column: TColumn);
    procedure Button2Click(Sender: TObject);
    procedure ADOConnection1BeforeConnect(Sender: TObject);
  private
    Statement: String;
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation
uses SettingsUnit;
{$R *.dfm}

procedure TForm1.ADOConnection1BeforeConnect(Sender: TObject);
begin
ADOConnection1.ConnectionString:= 'Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data Source='+ ExtractFilePath(Application.ExeName)+ 'DB.mdb;Mode=ReadWrite;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Reg'+'istry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Databas'+'e Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don''t Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False'
end;



procedure TForm1.Button2Click(Sender: TObject);
begin
Form2.ShowModal;
end;

procedure TForm1.DBGrid1CellClick(Column: TColumn);
begin
ADOQuery2.SQL.Text:= Statement + ' WHERE Type = "' + DBGrid1.Fields[0].Value + '"';
ADOQuery2.Active:=true;
end;

procedure TForm1.DBGrid2CellClick(Column: TColumn);
begin
WebBrowser1.Navigate('file://' + GetCurrentDir +'/'+ IntToStr(DBGrid2.Fields[1].Value) + '.html');
end;

procedure TForm1.FormCreate(Sender: TObject);
begin
Statement:= ADOQuery2.SQL.Text;
end;

end.