Difference between revisions of "TDataSet"

From Lazarus wiki
Jump to navigationJump to search
m (→‎Freepascal Documentation: Fixed hyperlink)
 
(18 intermediate revisions by 3 users not shown)
Line 1: Line 1:
<tt>'''TDataSet'''</tt> is the main link to the actual data in a database. A TDataSet acts like a cursor on a table or query-result. 
+
{{TDataSet}}
  
 +
'''TDataSet''' is the main link to the actual data in a database. A TDataSet descendant acts like a cursor on a table or query-result. 
 +
 +
<syntaxhighlight lang=pascal highlight=3>
 
   SQLTransaction1.Database := SQLConnection1;
 
   SQLTransaction1.Database := SQLConnection1;
 
   SQLQuery1.Transaction := SQLTransaction1;
 
   SQLQuery1.Transaction := SQLTransaction1;
   DataSource1.'''DataSet''' := SQLQuery1;
+
   DataSource1.DataSet := SQLQuery1;
   DBGrid1.DataSource := '''DataSource1''';
+
   DBGrid1.DataSource := DataSource1;
 +
</syntaxhighlight>
 +
 
 +
A dataset (for example a query result) can be edited:
 +
 
 +
<syntaxhighlight lang=pascal>
 +
  ds.Edit();
 +
  ds.FieldByName('NAME').AsString := 'Edited name';
 +
  ds.Post();
 +
  ds.UpdateMode := upWhereAll;
 +
  ds.ApplyUpdates();
 +
</syntaxhighlight>
 +
 
 +
== Non-abstract descendants ==
 +
 
 +
* [[TBufDataset]] -
 +
* [[TMemDataset]] -
 +
* [[TSdfDataSet]] -
 +
* [[TFixedFormatDataSet]]
 +
* [[TDbf]] - connect to dBase
 +
* [[TParadox]] - connect to Paradox/BDE (needs dlls, less features, read/write)
 +
* [[TParadoxDataSet]] - connect to Paradox/BDE (more features, read-only)
 +
* [[TFPCodeGenerator]]
 +
* [[TSQLQuery]] - connect to results of a SQL-query
 +
 
 +
== See also ==
  
== Freepascal Documentation ==
+
* [[doc:fcl/db/tdataset.html|TDataSet doc]]
* http://www.freepascal.org/docs-html/fcl/db/tdataset.html
+
* [[TBufDataset]]
 +
* [[TMemDataset]]
  
[[category:Databases]]
+
{{LCL Components}}

Latest revision as of 09:22, 11 August 2021

English (en) français (fr) 日本語 (ja) polski (pl) русский (ru)

TDataSet is the main link to the actual data in a database. A TDataSet descendant acts like a cursor on a table or query-result.

  SQLTransaction1.Database := SQLConnection1;
  SQLQuery1.Transaction := SQLTransaction1;
  DataSource1.DataSet := SQLQuery1;
  DBGrid1.DataSource := DataSource1;

A dataset (for example a query result) can be edited:

  ds.Edit();
  ds.FieldByName('NAME').AsString := 'Edited name';
  ds.Post();
  ds.UpdateMode := upWhereAll;
  ds.ApplyUpdates();

Non-abstract descendants

See also


LCL Components
Component Tab Components
Standard TMainMenu • TPopupMenu • TButton • TLabel • TEdit • TMemo • TToggleBox • TCheckBox • TRadioButton • TListBox • TComboBox • TScrollBar • TGroupBox • TRadioGroup • TCheckGroup • TPanel • TFrame • TActionList
Additional TBitBtn • TSpeedButton • TStaticText • TImage • TShape • TBevel • TPaintBox • TNotebook • TLabeledEdit • TSplitter • TTrayIcon • TControlBar • TFlowPanel • TMaskEdit • TCheckListBox • TScrollBox • TApplicationProperties • TStringGrid • TDrawGrid • TPairSplitter • TColorBox • TColorListBox • TValueListEditor
Common Controls TTrackBar • TProgressBar • TTreeView • TListView • TStatusBar • TToolBar • TCoolBar • TUpDown • TPageControl • TTabControl • THeaderControl • TImageList • TPopupNotifier • TDateTimePicker
Dialogs TOpenDialog • TSaveDialog • TSelectDirectoryDialog • TColorDialog • TFontDialog • TFindDialog • TReplaceDialog • TTaskDialog • TOpenPictureDialog • TSavePictureDialog • TCalendarDialog • TCalculatorDialog • TPrinterSetupDialog • TPrintDialog • TPageSetupDialog
Data Controls TDBNavigator • TDBText • TDBEdit • TDBMemo • TDBImage • TDBListBox • TDBLookupListBox • TDBComboBox • TDBLookupComboBox • TDBCheckBox • TDBRadioGroup • TDBCalendar • TDBGroupBox • TDBGrid • TDBDateTimePicker
Data Access TDataSource • TCSVDataSet • TSdfDataSet • TBufDataset • TFixedFormatDataSet • TDbf • TMemDataset
System TTimer • TIdleTimer • TLazComponentQueue • THTMLHelpDatabase • THTMLBrowserHelpViewer • TAsyncProcess • TProcessUTF8 • TProcess • TSimpleIPCClient • TSimpleIPCServer • TXMLConfig • TEventLog • TServiceManager • TCHMHelpDatabase • TLHelpConnector
Misc TColorButton • TSpinEdit • TFloatSpinEdit • TArrow • TCalendar • TEditButton • TFileNameEdit • TDirectoryEdit • TDateEdit • TTimeEdit • TCalcEdit • TFileListBox • TFilterComboBox • TComboBoxEx • TCheckComboBox • TButtonPanel • TShellTreeView • TShellListView • TXMLPropStorage • TINIPropStorage • TJSONPropStorage • TIDEDialogLayoutStorage • TMRUManager • TStrHolder
LazControls TCheckBoxThemed • TDividerBevel • TExtendedNotebook • TListFilterEdit • TListViewFilterEdit • TLvlGraphControl • TShortPathEdit • TSpinEditEx • TFloatSpinEditEx • TTreeFilterEdit • TExtendedTabControl •
RTTI TTIEdit • TTIComboBox • TTIButton • TTICheckBox • TTILabel • TTIGroupBox • TTIRadioGroup • TTICheckGroup • TTICheckListBox • TTIListBox • TTIMemo • TTICalendar • TTIImage • TTIFloatSpinEdit • TTISpinEdit • TTITrackBar • TTIProgressBar • TTIMaskEdit • TTIColorButton • TMultiPropertyLink • TTIPropertyGrid • TTIGrid
SQLdb TSQLQuery • TSQLTransaction • TSQLScript • TSQLConnector • TMSSQLConnection • TSybaseConnection • TPQConnection • TPQTEventMonitor • TOracleConnection • TODBCConnection • TMySQL40Connection • TMySQL41Connection • TMySQL50Connection • TMySQL51Connection • TMySQL55Connection • TMySQL56Connection • TMySQL57Connection • TSQLite3Connection • TIBConnection • TFBAdmin • TFBEventMonitor • TSQLDBLibraryLoader
Pascal Script TPSScript • TPSScriptDebugger • TPSDllPlugin • TPSImport_Classes • TPSImport_DateUtils • TPSImport_ComObj • TPSImport_DB • TPSImport_Forms • TPSImport_Controls • TPSImport_StdCtrls • TPSCustomPlugin
SynEdit TSynEdit • TSynCompletion • TSynAutoComplete • TSynMacroRecorder • TSynExporterHTML • TSynPluginSyncroEdit • TSynPasSyn • TSynFreePascalSyn • TSynCppSyn • TSynJavaSyn • TSynPerlSyn • TSynHTMLSyn • TSynXMLSyn • TSynLFMSyn • TSynDiffSyn • TSynUNIXShellScriptSyn • TSynCssSyn • TSynPHPSyn • TSynTeXSyn • TSynSQLSyn • TSynPythonSyn • TSynVBSyn • TSynAnySyn • TSynMultiSyn • TSynBatSyn • TSynIniSyn • TSynPoSyn
Chart TChart • TListChartSource • TRandomChartSource • TUserDefinedChartSource • TCalculatedChartSource • TDbChartSource • TChartToolset • TChartAxisTransformations • TChartStyles • TChartLegendPanel • TChartNavScrollBar • TChartNavPanel • TIntervalChartSource • TDateTimeIntervalChartSource • TChartListBox • TChartExtentLink • TChartImageList
IPro TIpFileDataProvider • TIpHtmlDataProvider • TIpHttpDataProvider • TIpHtmlPanel
Virtual Controls TVirtualDrawTree • TVirtualStringTree • TVTHeaderPopupMenu