Difference between revisions of "TDBGrid"
From Lazarus wiki
Jump to navigationJump to searchLine 5: | Line 5: | ||
DataSource1.DataSet := SQLQuery1; | DataSource1.DataSet := SQLQuery1; | ||
'''DBGrid1'''.DataSource := DataSource1; | '''DBGrid1'''.DataSource := DataSource1; | ||
− | |||
SQLQuery1.SQL := 'SELECT * FROM Table1'; | SQLQuery1.SQL := 'SELECT * FROM Table1'; | ||
− | DBGrid1.Columns[0].Title.Caption := 'Col1'; | + | '''DBGrid1'''.Columns[0].Title.Caption := 'Col1'; |
− | DBGrid1.Columns[0].FieldName := 'Field1'; | + | '''DBGrid1'''.Columns[0].FieldName := 'Field1'; |
SQLQuery1.Open(); | SQLQuery1.Open(); | ||
Revision as of 23:57, 5 August 2016
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.
SQLTransaction1.Database := SQLConnection1; SQLQuery1.Transaction := SQLTransaction1; DataSource1.DataSet := SQLQuery1; DBGrid1.DataSource := DataSource1; SQLQuery1.SQL := 'SELECT * FROM Table1'; DBGrid1.Columns[0].Title.Caption := 'Col1'; DBGrid1.Columns[0].FieldName := 'Field1'; SQLQuery1.Open();
Freepascal Documentation