Dbgrid обновление - Delphi БД - Ответ 6100597

unit Unit1;
 
interface
 
uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, DB, ADODB, ExtCtrls, DBCtrls, Grids, DBGrids, StdCtrls;
 
type
  TForm1 = class(TForm)
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    DBNavigator1: TDBNavigator;
    ADOConnection1: TADOConnection;
    ADOTable1: TADOTable;
    Label1: TLabel;
    Label2: TLabel;
    Button1: TButton;
    Button2: TButton;
    Edit1: TEdit;
    Edit2: TEdit;
    Label3: TLabel;
    Label4: TLabel;
    ADOQuery1: TADOQuery;
    ADODataSet1: TADODataSet;
    Label5: TLabel;
 
    
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure DBGrid1TitleClick(Column: TColumn);
 
  private
    { Private declarations }
  public
    { Public declarations }
  end;
 
var
  Form1: TForm1;
      QuerySQL:string;
implementation
 
{$R *.dfm}
 
 
 
 
procedure  TForm1.Button1Click(Sender: TObject);
 
begin
           ADOQuery1.Active:=True;
     if ADOQuery1.Locate('Òîâàð',edit1.text,[loCaseInsensitive,loPartialKey])=True then
    begin
     ShowMessage('Òîâàð íàéäåí');
    end
    else
    begin
     ShowMessage('Òîâàð íå íàéäåí');
    end;
 
end;
procedure TForm1.Button2Click(Sender: TObject);
begin
     ADOQuery1.SQL.Clear;
   ADOQuery1.SQL.Add('SELECT * FROM Shop WHERE Òîâàð LIKE ''edit2.text''');
   ADOQuery1.Active:=True;
   ADOQuery1.Open; 
end;
 
 
 
procedure TForm1.DBGrid1TitleClick(Column: TColumn);
begin
QuerySQL := 'SELECT * FROM Shop';
  with ADOQuery1 do
  begin 
    DisableControls; 
    Close;
    SQL.Clear;
    SQL.Add(QuerySQL);
    SQL.Add('ORDER BY ' + Column.FieldName +' ASC');
 
    Open;
    
    
    DBGrid1.Columns.RestoreDefaults;
    Column.Title.Font.Color := clBlue; 
    EnableControls; 
  end;
 
end;
 
end.