Sign in Join
Wiki copytemporary

TDBGrid

English · Français · Русский · 日本語

TDBGrid is a visual component that displays tabular data from database contents through means of a TDataSet derivative like a TSQLQuery. The TDBGrid component is available from the Data Controls tab of the Component Palette.

pascal
    // configure connection with database
  SQLConnector1.ConnectorType := 'MySQL 5.1';
  SQLConnector1.HostName := 'MyServer';
  SQLConnector1.DatabaseName := 'MyDBName';
  SQLConnector1.UserName := 'MyName';
  SQLConnector1.Password := 'MyPass';
    // connect SQLConnector, SQLTransaction, DataSource, SQLQuery and DBGrid
  SQLTransaction1.Database := SQLConnector1;
  SQLQuery1.Transaction := SQLTransaction1;
  DataSource1.DataSet := SQLQuery1;
  DBGrid1.DataSource := DataSource1;
    // setup query to get (at least) two fields from MyTable
  SQLQuery1.SQL := 'SELECT * FROM MyTable';
    // setup grid with result from query
  DBGrid1.Columns[0].Title.Caption := 'Name';
  DBGrid1.Columns[0].FieldName := 'fieldDescription';
  DBGrid1.Columns[1].Title.Caption := 'Description';
  DBGrid1.Columns[1].FieldName := 'fieldName';
    // Open result and show in grid
  SQLQuery1.Open();

See also


From the Free Pascal wiki, page "TDBGrid", as it stood on 2023-01-04 after a change by Five, out of the wiki's dump of 2024-05-26. Copyright stays with the author who wrote it, according to the old wiki's Licensing page. If you have concerns about this material, message the admin.

Revision 1, last changed by WikiArchive .

Talk about this page

Nobody has opened a bench for this page yet. Sign in to open one.