1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44
| procedure TfrmMenuPlat.FormCreate(Sender: TObject);
var
requette1: TQuery;
DSrequette1: TDataSource;
DBCtrlGrid1: TDBCtrlGrid;
DBText1: TDBText;
SqlQuery: String;
begin
//requette sql
requette1 := TQuery.Create(frmMenuPlat);
requette1.DatabaseName := 'rolin';
requette1.Close;
requette1.SQL.Clear;
SqlQuery := 'SELECT Code_plat, Nom FROM plats WHERE Code_catégorie = 3';
requette1.SQL.Add(SqlQuery);
requette1.ExecSQL;
requette1.Active := true;
//datasource
DSrequette1 := TDataSource.Create(frmMenuPlat);
DSrequette1.DataSet := requette1;
DBCtrlGrid1 := TDBCtrlGrid.Create(self);
DBCtrlGrid1.Parent := frmMenuPlat;
DBCtrlGrid1.Top := 80;
DBCtrlGrid1.Left := 50;
DBCtrlGrid1.RowCount := 1;
DBCtrlGrid1.ColCount := 5;
DBCtrlGrid1.Width := 800;
DBCtrlGrid1.Height := 60;
DBCtrlGrid1.DataSource := DSrequette1;
DBText1 := TDBText.Create(self);
DBText1.Parent := DBCtrlGrid1;
DBText1.Top := 5;
DBText1.Left := 5;
DBText1.Width := 140;
DBText1.Height := 60;
DBText1.DataSource := DSrequette1;
DBText1.DataField := 'Nom';
end; |
Partager