Difference between revisions of "TDataSet"

From Lazarus wiki
Jump to navigationJump to search
 
(4 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 +
{{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.   
 
'''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>
+
<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>
 
</syntaxhighlight>
  
A dataset (for example a query restult) can be edited:
+
A dataset (for example a query result) can be edited:
<syntaxhighlight>
+
 
 +
<syntaxhighlight lang=pascal>
 
   ds.Edit();
 
   ds.Edit();
 
   ds.FieldByName('NAME').AsString := 'Edited name';
 
   ds.FieldByName('NAME').AsString := 'Edited name';
   dd.Post();
+
   ds.Post();
 
   ds.UpdateMode := upWhereAll;
 
   ds.UpdateMode := upWhereAll;
 
   ds.ApplyUpdates();
 
   ds.ApplyUpdates();
 
</syntaxhighlight>
 
</syntaxhighlight>
  
== non-abstract descendants ==
+
== Non-abstract descendants ==
 +
 
 
* [[TBufDataset]] -
 
* [[TBufDataset]] -
 
* [[TMemDataset]] -
 
* [[TMemDataset]] -
Line 23: Line 27:
 
* [[TFixedFormatDataSet]]
 
* [[TFixedFormatDataSet]]
 
* [[TDbf]] - connect to dBase  
 
* [[TDbf]] - connect to dBase  
* [[TParadox]] - connect to Paradox/BDE
+
* [[TParadox]] - connect to Paradox/BDE (needs dlls, less features, read/write)
* [[TParadoxDataSet]] - connect to Paradox/BDE
+
* [[TParadoxDataSet]] - connect to Paradox/BDE (more features, read-only)
 
* [[TFPCodeGenerator]]
 
* [[TFPCodeGenerator]]
 
* [[TSQLQuery]] - connect to results of a SQL-query
 
* [[TSQLQuery]] - connect to results of a SQL-query
  
 
== See also ==
 
== See also ==
 +
 
* [[doc:fcl/db/tdataset.html|TDataSet doc]]
 
* [[doc:fcl/db/tdataset.html|TDataSet doc]]
 
* [[TBufDataset]]
 
* [[TBufDataset]]
Line 34: Line 39:
  
 
{{LCL Components}}
 
{{LCL Components}}
 
[[category:Databases]]
 

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