A grid built for data that never sits still. Write rows by key from any thread, watch changed cells flash green or red, then group, filter, edit and export the same rows. A 1080p frame of a 100,000 row grid takes 3.0 ms on Win32.
MaxFPS.Twenty-three features in six groups, each linked to its help topic.
Feeds that never stop: prices, telemetry, queues and logs.
Live Data
A market feed, a sensor bus or a job queue can write straight into the grid. Every row has a key, and a worker thread updates the row of a key by field name with no Synchronize call and no locking code of your own. The grid only marks itself dirty on the writer thread and repaints on the main thread at most MaxFPS times per second.
UpdateRow sets the named fields of a key and inserts the row when the key is new; UpdateCell changes one fieldAppendRow and DeleteRow add and remove rows by key, from any threadBeginUpdate and EndUpdate turn a batch into a single notification
Live Data
Traders and operators need to see what moved without reading every number. With FlashChanges on, which is the default, a changed cell is tinted green when its value went up and red when it went down, then fades out over FlashDuration milliseconds, 800 by default. For logs and growing feeds, tail mode keeps the newest row in view and stops following as soon as the user scrolls up to read.
FlashUpColor, FlashDownColor and FlashChangedColor; a colour 0 uses the theme defaultFlashMode tints the background (fmBackground) or the text (fmText)TailMode follows the newest row, MaxRows drops the oldest rows of an endless log
Live Data
An overdue invoice, a negative balance or a failed job should stand out before anyone asks. Format rules compare a column with a value using the data type of that column: numbers numerically, dates as dates, text case insensitive. A matching rule sets the back colour, the text colour or bold on the cell or on the whole row, and it keeps working while live updates change the values underneath.
TsgcGridFormatRules evaluates its rules in collection order, a later match overriding an earlier onegfoLess, gfoBetween, gfoContains and gfoIsEmptyApplyToRow styles every cell of the row, StopOnMatch ends the evaluation for a cellOnGetCellStyle has the last wordOnGetCellFont sets the font style and size of any cellAddIconSet puts arrows, circles, flags or check marks in a column from two thresholds, and a rule can show an icon or an image of your ownLive Data
An operator screen needs one place that lists every alarm, shows which ones still wait for an acknowledge and lets the operator act on them. The alarm model keeps the alarms with the ISA-18.2 states and priorities 1 to 4, and the alarm link writes them into a grid, one row per tag, with the colour of the priority and blinking rows for the alarms not yet acknowledged. The application raises and clears the alarms from its own limits, the operator acknowledges, shelves and unshelves them from the context menu.
TsgcGridAlarmModel: RaiseAlarm, ClearAlarm, Acknowledge, AcknowledgeAll, Shelve, UnshelveFilterPriorities, FilterStates and FilterText, and export as JSON or CSVTsgcGridAlarmLink and TsgcVCLGridAlarmMenu, also for FireMonkey and, in .NET, for WinForms, WPF and AvaloniaThe model, the link and the menus are in every edition, Community included. The acknowledge log with Log and OnLog is Registered. The alarm list is part of the sgcUI HMI Pack.
Sort, filter, group and nest large row sets.
Shape the Data
Sales by region, orders by month, tickets by status: users want totals, not raw rows. GroupBy groups the grid by one or more columns, and every group row shows its member, its row count and the summaries of its rows. Users regroup on their own by dragging a header onto the group panel. Grouping is view state only, so a chart bound to the grid still sees the flat, sorted rows.
GroupBy and ClearGrouping from code, or GroupIndex per columnShowGroupPanel adds drag and drop chips; a click on a chip flips the group orderSummaryType gsuSum, gsuCount, gsuAverage, gsuMin or gsuMax, formatted with SummaryFormatGroupSummaries in every group row and ShowFooter for the grand totalsDisplayFormat of yyyy-mm groups dates by month
Shape the Data
Finding one customer among thousands should take a few keystrokes. FilterText keeps the rows whose formatted text contains the typed words in any visible column, and an OnFilterRow handler adds your own rules on top. A click on a header sorts, Ctrl and click adds a column to a multi column sort, and the sort is stable. A ticking column that is neither sorted nor filtered costs no re-sort at all.
SortOrder and SortIndex per column, OnSortChange after every changeFilterText is case insensitive and reads the text as the user sees itOnFilterRow for custom logic, InvalidateView when that logic changesSelectionMode selects rows or cells, and Ctrl+C copies them as tab separated text
Shape the Data Registered only
An org chart or a bill of materials reads best as a tree, and the orders of a customer best right under the customer. Tree rows lay out rows depth first from a key column and a parent column. Detail bands open a small grid of related rows under any master row, with its own header, scrolling and sort, filled from a TsgcGridDataStore, another grid or an event.
Tree.KeyField and Tree.ParentField switch the tree on; ExpandNode and CollapseNode work from codeDetail.MasterKeyField and Detail.DetailKeyField link a band to its source, OnGetDetailData fills it on demandNot in the .NET Community build, which keeps grouping.
Read the help topic
Shape the Data Registered only
A contact list, a product catalog or a ticket queue often reads better as cards than as a table. With ViewStyle set to gvsCard the grid draws every row as a card: an optional caption bar, an optional image and one line per visible column with its caption and value. The cards show the same rows as the table, so sorting, filters, the find panel, the selection, editing and server mode work in both views, and one property switches between them at run time.
CardOptions sets the CaptionField, the ImageField above or beside the fields, the CardWidth and the number of cards per bandThe card view does not group and draws no column header, filter row or footer. In VCL, FireMonkey, WinForms, WPF and Avalonia, not in the .NET Community build.
Read the help topic
Shape the Data
Wide grids lose their context when the symbol or the customer name scrolls away. FrozenColumns keeps the first visible columns in place while the others scroll horizontally, and the header, the footer and the group summaries follow the same split. Users resize columns by dragging the header edge, and the headless renderer uses the same setting, so exported images match the screen. The group chevrons on the left never scroll either.
FrozenColumns counts visible columns, and a one pixel line marks the frozen edgeFrozenWidth of the renderer returns the width that does not scrollMinWidth limits a resize, OnColumnResized reports the new width
Shape the Data
Users expect the funnel they know from Excel. ShowFilterButtons puts one in every column header: it opens a popup with the distinct values of the column and their row counts, a search box, and up to two typed conditions joined by And or Or. ShowFilterRow adds a row under the header that filters a column while the user types, and Ctrl+F opens the find panel, which highlights the text in every cell and jumps from match to match.
Column.Filter in code, so the three always agreeFilterRowOperator per column: equals, greater than, contains, begins with, is blank and moreFindText, FindNext and FindPrevious work from code, and FindOnlyMatches hides the rows without a matchFilterText and OnFilterRow, and OnFilterChange reports every changeFirstDayOfWeekIn the VCL, FireMonkey, WinForms, WPF and Avalonia grids, the free .NET Community build included.
Read the help topicShape the Data
A right click on a column header opens a menu that sorts, groups, fits widths, filters and opens the column chooser, a popup with one check box per column. Users drag a header to move its column, and a double click on the header edge fits the width to the caption and the cells. SaveLayoutToString and LoadLayoutFromString keep all of it as a short JSON text, so the grid opens the way the user left it.
HeaderMenu, ColumnMoving and BestFitOnDblClick are on by default, and an assigned PopupMenu still winsShowColumnChooser opens the chooser from a button or a menu item of your ownOnColumnMoved reports the moveBestFitColumn and BestFitColumns measure the header and up to 1,000 sampled rows, so a million rows cost about the same as a thousandSaveLayoutToFile and LoadLayoutFromFile use a fileAutoSaveLayout saves the layout when the grid closes and restores it on the next run, and Reset layout in the header menu brings back the design time columnsAutoFitColumns makes the columns fill the grid width, and MaxWidth caps a column when it is resized or fittedIn the VCL, FireMonkey, WinForms, WPF and Avalonia grids, the free .NET Community build included.
Read the help topic
Shape the Data
A trading screen reads better when Last, Change and Trend sit under one Price caption. Bands adds captions over groups of columns, on as many levels as you need, and each column names its band in Band. CellKind paints a cell as an image, a progress bar or a sparkline, while the cell keeps its plain value, so sorting, grouping and export still see the number.
Bands.Add takes a caption and a parent band, and the band rows stack above the column headergcdProgress uses ProgressMin and ProgressMax; gcdSparkline draws a line, area or bar chart from a list of numbersgcdTags shows several coloured chips in one cell from text such as "Urgent, Pending review", with TagColors and OnGetTagStyle for your own coloursgcdImage draws an image of CellImages, which the grid fills from any image list assigned to ImagesTrueValue and FalseValue turn a column that stores values such as "S" and "N" into check boxes, and gcdLink shows a link that raises OnLinkClickHeaderLines, RowLines and WordWrap show captions and cell text on several lines, and HeaderImageIndex and HeaderButton put an image and a button in a column headerShowTruncatedHints shows the full text of a cut cell or caption as a hint, and OnGetCellHint sets your own hint per cellSelectionMode gsmMultiRow selects any set of rows with Ctrl and Shift, gsmCellRange one range of cells, and Ctrl+A selects allRowHeader adds a strip with the record indicator, row numbers and a check box per row, and SelectionColor and SelectionTextColor set the selection coloursRowDragMode drags the selected rows to another control, and on VCL to other applications such as ExcelIn the VCL, FireMonkey, WinForms, WPF and Avalonia grids, the free .NET Community build included.
Read the help topicChange the data, sync it with your database, hand it on.
Edit and Export Registered only
Back office users expect to fix a quantity or a status right in the grid. Set ReadOnly to False and F2, Enter, a typed character or a double click opens an editor over the cell, or a combo box when the column has a PickList. Typed text is converted to the data type of the column, OnValidate can change or reject the value, and the result is written with UpdateCell, so sorting and flashing still apply.
Editable per column, and OnBeforeEdit can refuse an editStartEdit, CommitEdit and CancelEdit do the same from codeOnEditError keeps the editor open on bad input, OnEdited reports the old and the new valueNot in the .NET Community build.
Read the help topic
Edit and Export
Existing database code keeps working: a TsgcGridSource_DataSet fills the grid from a FireDAC query, a TClientDataSet or any other TDataSet. Set its Grid and DataSet, make it Active, and the rows appear. With a KeyField the grid is synchronised rather than reloaded, so changed rows update in place and flash. With LiveUpdates on, every posted Append, Edit and Delete reaches the grid with no extra code.
AutoColumns creates the columns from the dataset fieldsKeyField, new keys are appended and missing keys deletedDisableControls and its current record is restoredGridLoadFromJSONFile, GridSaveToCSVFile and the rest of sgcGrid_IOgcdImage columns, and ImagePreview shows a larger copy when the mouse rests on the cellApplyFilter makes the DataSet keep only the rows the grid shows, and OnApplySort passes the grid sort as field names for your queryEdit and Export Registered only
Accounting wants the numbers in Excel, not a screenshot. SaveToXLSX writes the grid as an Office Open XML workbook to a file or a stream with no external library. The sheet keeps what the user sees: the visible columns in display order with their widths and number formats, the frozen header, groups and tree levels as a collapsible outline, and group totals as SUBTOTAL formulas.
SaveToXLSX takes a file name or a stream and an optional sheet nameDisplayFormat becomes the cell number formatNot in the .NET Community build, which keeps JSON and CSV export.
Read the help topicEdit and Export Registered only
Sales sends a workbook and wants a quick what-if, not another round trip through Excel. With ExcelMode set to True the grid behaves like a light spreadsheet: users select a range, drag the fill handle to continue a series, type formulas that start with =, format cells and work on several sheets. LoadFromXLSX opens the workbook itself, from a file or a stream, with no external library and no Excel installation.
OnBeforeFill can veto itFormatSelection or Ctrl+B, Ctrl+I, Ctrl+U and Ctrl+5; every format change is one undo stepShowSheetTabs a tab strip adds, renames, deletes and reorders them, formulas read other sheets with references such as Orders!E1:E20 or 'Q4 Notes'!B1, and a rename rewrites those referencesSaveToXLSX writes every sheet with its name, its cell formats and its formulas as Excel formulas with the computed values cached; rows go out in store order so the references stay exactLoadFromXLSX reads every sheet of the workbook in Excel mode, or one sheet by name or index, builds the columns from the header row with inferred types and reads strings, numbers, booleans and dates, including the 1904 date systemFormula such as =C1*D1 is written for row 1 and computes every row of a read only column, on in-memory data, in virtual mode and over a DataSet source; in virtual mode the formula texts that OnGetValue returns are evaluated tooNot a full spreadsheet: no charts, no merged cells and no cell formulas over a DataSet source, where column formulas take their place. In VCL, FireMonkey, WinForms, WPF and Avalonia, not in the .NET Community build.
Read the help topic Read the cell formatting topic Read the sheets topic Read the column formulas topic
Edit and Export Registered only
With WriteBack on, a TsgcGridSource_DataSet writes every grid edit to the record of its row. It locates the record by KeyField and posts the value. When the post fails, for example in a BeforePost check, the record is cancelled and the cell keeps its old value. SyncCursor keeps the current record and the focused row together, so a TDBNavigator and TDBEdit controls on the same dataset follow the grid, and the grid follows them.
AllowInsert: Ins appends and posts a record, and OnNewRecord of the dataset fills the defaultsAllowDelete: Ctrl+Del deletes the selected rows and their records once OnBeforeDelete agreesOnEditError shows the message of the dataset; pasted values and undo use the same write pathIn the VCL, FireMonkey, WinForms, WPF and Avalonia grids; not in the .NET Community build. In .NET the source writes back to a DataTable, AddLookup adds the lookup columns, and SyncCursor is Delphi only.
Edit and Export Registered only
Each column picks the control that edits it. EditorKind chooses a date, time or date and time picker, a spin edit, a colour picker or a token edit from sgcEditors, and the default chooses from the data type of the column. Ctrl+V pastes a block copied from Excel: every value is converted and validated before anything is written, and the whole paste is one undo step. Ctrl+Z and Ctrl+Y undo and redo edits and pastes.
OnCreateEditor puts any control of your own in a cell, for example a TTrackBargedMemo edits long text on several lines, and gedLookup picks a value from a list with several columns, filled from LookupItems or a lookup fieldTrueValue or FalseValuePasteText and PasteFromClipboard work from code, and OnBeforePaste can change or refuse the textOnValidate rejects, stops the paste before anything is writtenUndoLimit keeps the last 100 steps; Undo, Redo and CanUndo work from codeIn the VCL, FireMonkey, WinForms, WPF and Avalonia grids; not in the .NET Community build.
Read the help topicMillions of rows, live feeds and plain language.
Scale and Connect
Log archives, sensor histories and query results that already live elsewhere do not need to be copied into memory. In virtual mode the grid stores no rows: VirtualRowCount says how many there are, and OnGetValue returns a value when its row scrolls into view. Only visible rows are painted, so a grid of a million rows costs as much as one of fifty. Change the count as the source grows.
Virtual and VirtualRowCount on the grid data, OnGetValue supplies the cellsOnGetValue tooMaxRows with TailMode is the keyed alternative
Scale and Connect Registered only
An order history or an audit table is far too large to load, yet users still want to sort it, filter it and group it. In server mode a provider component reads one page of rows at a time, and the data source evaluates the sort, the column filters, the filter row, the find text, the footer summaries, the grouping and the row count. A table of millions of rows opens as fast as a table of fifty, and only the pages on screen are read.
TsgcGridServerProvider_DataSet turns every request into one SQL statement for SQLite, SQL Server, PostgreSQL, MySQL, Oracle, Firebird, InterBase or a generic dialect, run by any query component: FireDAC, dbExpress, ADO, IBX, UniDAC, Zeos and othersTsgcGridServerProvider_Queryable reads any IQueryable, an Entity Framework Core set for example, and TsgcGridServerProvider_AdoNet runs the same SQL on any ADO.NET connectionTsgcGridServerProvider_Callback serves any other source, a REST service for example, from events answered at once or later from any threadPageSize through a cache; painting never waits, rows not loaded yet show placeholder bars until their page arrivesTree rows and detail bands are not available in server mode, and the filter popup shows no row counts. In VCL, FireMonkey, WinForms, WPF and Avalonia, not in the .NET Community build.
Read the help topicScale and Connect
Not every user wants to build filters. TsgcGridAI turns a question such as price greater than 100 sort by volume descending highlight change less than 0 into filters, sorts and row highlights on the grid, and the AI query bar gives users a place to type it. With no provider assigned, a rule based parser answers locally, with no network and no API key. Assign a provider and any LLM answers instead: TsgcUIAIEventProvider hands each request to your own code, and TsgcUIAIChatProvider uses the TsgcAIChat component of sgcWebSockets. Only the field catalog is sent, the names, captions, types and a few sample values of the columns, never the rows.
TsgcVCLAIQueryBar, TsgcFMXAIQueryBar, TsgcWinFormsAIQueryBar, TsgcWpfAIQueryBar and TsgcAvaloniaAIQueryBar, with recent questions, suggestions, Cancel and UndoOnFilterRow, highlights become ApplyToRow format rulesUndo goes back one stepLastExplanation tells what was applied, and when the provider fails the rule based parser answersTsgcGridAIQuery with TsgcHTMLAIAssistant, and brings TsgcGridFeedSource_WebSocket, TsgcGridFeedSource_MQTT and TsgcGridFeedSource_SSE, which write JSON messages into the grid by keyEvery edition, Community included, on VCL, FireMonkey, WinForms, WPF and Avalonia. The sgcWebSockets provider and the sgcGridWS bridge need sgcWebSockets and a Registered edition.
Read the help topicThe preview shows exactly what the printer and the PDF get.
Print, Preview and PDF
A printed page shows the content of the grid, not the screen. Every row prints as the grid shows it, with the filter, the sort order, the grouping and the find matches applied, not only the rows scrolled into view. The band rows and the column headers repeat at the top of every page, the footer with the summaries closes every page, and a page holds whole rows only, so a row is never cut.
Print shows the print dialog or prints straight to the default printer, and ShowPrintPreview opens a preview with page navigation, zoom, page setup, printing and PDF exportPrintSettings holds the paper, the orientation, the margins, the scaling and the header and footer text, and the printer, the preview and the PDF all use itExportToPDF writes vector pages with real, searchable text, tagged PDF/UA by default, and every page is a real table with header cells, so a screen reader announces the table with its headersPDFALevel of TsgcUIPDFOptions adds PDF/A-2a or PDF/A-3a for archiving, alone or together with PDF/UAPrinting and the preview are in every edition, the free Community edition included, on VCL, FireMonkey, WinForms, WPF and Avalonia. In FireMonkey, printing works on Windows and macOS, and the preview and the PDF export on every platform. The PDF export needs the sgcUIPDF bridge and a licensed sgcPDF (the NuGet package esegece.sgcUICore.sgcPDF in .NET), so it is not in the Community edition.
UI Automation for screen readers, the keyboard and high contrast, with no setup.
Accessibility
sgcGrid exposes its content to Microsoft UI Automation as a table with column headers, rows and cells, the API that screen readers such as Narrator and NVDA use. Only the visible rows are built, and the row and column counts are always the full ones, so a grid with a million rows costs nothing more.
Accessibility is on by default in every edition, the free Community edition included, on VCL in every Delphi and C++Builder version from Delphi 7 to Delphi 13, on FireMonkey on Windows, and on WinForms, WPF and Avalonia. In Delphi and C++Builder, AccessibleName and AccessibleDescription set the name and the description exposed to UI Automation, and in .NET the standard accessible name and help text of each framework do the same. See the accessibility conformance reports. On Avalonia, which has no table patterns, each cell carries its column and position in its name and help text. Column widths are resized with the mouse only.
sgcGrid inside the sgcUI suite demos: complete applications that run offline with built-in simulated data.
Positions grouped by desk and strategy, P&L cells tinted, fills one click away.
Altamira Markets →
Customers grouped by region with summaries and a linked contact card.
Altamira ERP →
A risk register grouped by programme with mitigation rows.
Altamira PMO →
A vehicle grid with ETA, slack and status per truck, beside the national map.
Altamira Fleet →Last measured averages of the sgcGrid QA performance gate: a 1920 x 1080 frame with 12 columns, 100,000 rows and 45 visible rows, rendered 60 times on the raster canvas. The gate fails above 16 ms per frame on Win64 and 25 ms on Win32.
| Measurement | Result | Conditions |
|---|---|---|
| Plain frame | 3.0 ms | Win32 |
| Plain frame | 4.6 ms | Win64 |
| Plain frame | 3.7 ms | Linux64 |
| Flash and 3 format rules | 3.2 ms | Win32 |
| Flash and 3 format rules | 6.8 ms | Win64 |
| LiveTicker demo, worker thread writes | About 1,000 updates per second | Sorted, flashing grid at 60 fps |
A quote board has to stay readable while hundreds of prices change every second. Feed threads write with UpdateRow and never wait on the UI, flash on change shows the direction of every move, and tail mode keeps the trade log on its newest fill. The sgcGridWS bridge can read the quotes from WebSocket, MQTT or SSE.
Order entry, stock lists and invoicing screens live on a database. Bind the existing TDataSet, let users group by customer or month with totals in every group row, correct values in place with validation, and export a workbook that accounting opens with its groups and SUBTOTAL formulas intact.
Operations screens show event streams that never end. MaxRows caps the log, format rules paint errors red, and virtual mode browses an archive of millions of lines on demand. On a Linux64 server the renderer writes the same grid to a PNG or SVG file for an alert e-mail.
The same API in Delphi, C++ Builder and C#: add columns, append rows by key, and update them later from any thread.
A VCL grid in code: typed columns, rows appended by key, and an update by field name from any thread.
uses
Forms, Classes, Controls,
sgcGrid_Columns, sgcGrid_Data, sgcGrid_VCL;
procedure CreateGrid(aForm: TForm);
var
oGrid: TsgcVCLGrid;
begin
oGrid := TsgcVCLGrid.Create(aForm);
oGrid.Parent := aForm;
oGrid.Align := alClient;
// the columns: FieldName, Caption and DataType
oGrid.Columns.Add('Symbol', 'Symbol');
oGrid.Columns.Add('Price', 'Price', gdtFloat).DisplayFormat := '0.00';
oGrid.Columns.Add('Volume', 'Volume', gdtInteger);
// one row per key, the values in column order
oGrid.Data.AppendRow('MSFT', ['MSFT', 412.5, 1200]);
oGrid.Data.AppendRow('AAPL', ['AAPL', 228.1, 3400]);
// later, from any thread: update the row of a key by field name
oGrid.Data.UpdateRow('MSFT', ['Price', 'Volume'], [413.1, 1350]);
end;The same grid in C++ Builder with the generated sgcGrid headers.
#include "sgcGrid_Columns.hpp"
#include "sgcGrid_Data.hpp"
#include "sgcGrid_VCL.hpp"
void __fastcall CreateGrid(TForm *Form)
{
TsgcVCLGrid *Grid = new TsgcVCLGrid(Form);
Grid->Parent = Form;
Grid->Align = alClient;
// the columns: FieldName, Caption and DataType
Grid->Columns->Add("Symbol", "Symbol", gdtText);
Grid->Columns->Add("Price", "Price", gdtFloat)->DisplayFormat = "0.00";
Grid->Columns->Add("Volume", "Volume", gdtInteger);
// one row per key, the values in column order
Grid->Data->AppendRow("MSFT", OPENARRAY(Variant,
(Variant("MSFT"), Variant(412.5), Variant(1200))));
Grid->Data->AppendRow("AAPL", OPENARRAY(Variant,
(Variant("AAPL"), Variant(228.1), Variant(3400))));
// later, from any thread: update the row of a key by field name
Grid->Data->UpdateRow("MSFT",
OPENARRAY(String, (String("Price"), String("Volume"))),
OPENARRAY(Variant, (Variant(413.1), Variant(1350))));
}A WinForms grid with flashing cells, a negative change rule and the dark theme.
using System.Windows.Forms;
using esegece.sgcGrid;
using esegece.sgcUICore;
internal class MainForm : Form
{
private readonly TsgcWinFormsGrid Grid = new TsgcWinFormsGrid();
public MainForm()
{
Grid.Dock = DockStyle.Fill;
// the columns: field name, caption and data type
Grid.Columns.Add("symbol", "Symbol");
Grid.Columns.Add("price", "Price", TsgcGridDataType.gdtFloat).DisplayFormat = "#,##0.00";
Grid.Columns.Add("change", "Change", TsgcGridDataType.gdtFloat).DisplayFormat = "+0.00;-0.00;0.00";
Grid.Columns.Add("volume", "Volume", TsgcGridDataType.gdtInteger).DisplayFormat = "#,##0";
// changed cells flash and fade, negative rows are tinted red
Grid.FlashChanges = true;
Grid.FormatRules.Add("change", TsgcGridFormatOperator.gfoLess, "0", 0x30E53935).ApplyToRow = true;
Grid.Theme = TsgcUITheme.utDark;
// one row per key, the values follow the column order
Grid.Data.AppendRow("MSFT", "MSFT", 412.5, 0.0, 1200);
Grid.Data.AppendRow("AAPL", "AAPL", 228.1, 0.0, 3400);
Controls.Add(Grid);
}
// call it from any thread: TsgcGridData is thread safe
public void OnQuote(string aSymbol, double aPrice, double aChange, int aVolume)
{
Grid.Data.UpdateRow(aSymbol, new[] { "price", "change", "volume" },
new object[] { aPrice, aChange, aVolume });
}
}dotnet add package esegece.sgcGrid.WinForms19 demos for Delphi, five of them FireMonkey, 13 for C++ Builder and 24 for .NET on WinForms, WPF and Avalonia.
About 1,000 price updates per second from a worker thread with UpdateRow, a sorted view, flashing cells and a format rule for negative changes. VCL, FireMonkey, C++ Builder, WinForms, WPF and Avalonia.
A TsgcGridSource_DataSet bound to a TClientDataSet of 200 records with KeyField, AutoColumns and LiveUpdates, plus JSON and CSV export and import.
Excel mode with three sheets on a tab strip: Orders, whose Total column has the column formula =C1*D1, Summary, with =SUM(Orders!E1:E20) and other formulas across the sheets, and Notes. A toolbar formats the selection, runs the sheet commands and saves and opens XLSX files with the formulas, the formats and the sheet names. VCL, FireMonkey (SpreadsheetFMX), C++ Builder, WinForms, WPF and Avalonia.
200,000 generated orders in an in-memory FireDAC SQLite database, paged by TsgcGridServerProvider_DataSet. Switch between the table and the cards, sort, filter, find, sum the footer, group by country and customer with the counts and sums computed by SQL, and write edits back to the database. VCL and C++ Builder; ServerModeAndCardsFMX pages 100,000 generated rows through TsgcGridServerProvider_Callback, and the WinForms, WPF and Avalonia demos have ADO.NET, IQueryable and callback pages.
100,000 orders grouped by Region and Category with the group panel, Count, Sum and Average summaries, a footer and two frozen columns. .NET calls it Grouping.
100,000 sales rows with the funnel popups, the filter row and the find panel, plus the column chooser, best fit, and a layout saved to a file and loaded back. VCL, FireMonkey, C++ Builder, WinForms, WPF and Avalonia.
2,000 instruments under Instrument, Live data, Price and Position bands, with sparkline, progress and image cells, multi-row selection and a Copy button. VCL, C++ Builder and WinForms.
A pick list column, a boolean column toggled with Space, OnValidate rejecting negative quantities, OnEditError and an OnEdited log, plus date, time, spin, colour and token editors from sgcEditors, a TTrackBar through OnCreateEditor, paste, undo and redo.
Products and categories in two TClientDataSets, with a TDBNavigator and two TDBEdits on the same records: WriteBack, SyncCursor, a lookup column, insert, delete and undo. VCL, C++ Builder and WinForms (a DataTable with AddLookup).
An org chart tree, and customers with an orders detail band filled through a TsgcGridDataStore.
A grouped grid and a tree grid saved with SaveToXLSX and opened in the spreadsheet application, outline and summaries kept.
A grid tile and a chart tile on a dashboard: a TsgcChartDataSource_Table plots the grid rows. Needs sgcCharts and sgcDashboard.
TsgcGridAI and the AI query bar filter, sort and highlight 200 stocks from plain language questions, with no network and no API key, next to the TsgcGridAIQuery bridge. Needs sgcWebSockets.
An in process WebSocket server broadcasts JSON batches of 50 symbols, and a TsgcGridFeedSource_WebSocket writes them into the grid by key. Delphi and .NET.
Ready to run executables of every sgcUI product, nothing to install.
Download sgcUI_bin.zip →Five QuickStart demos for Delphi (VCL) ship in Demos\Grid\Delphi\00.QuickStart. The PDF guide walks through them step by step: a first grid, typed columns, editing in place, a dataset connection, and an orders application with filters, grouping and totals.
sgcGrid is sold on its own, is part of every sgcUI edition from Standard up, and is in the All-Access bundle.
€199 / developer, full source code, 1 year of updates.
Buy sgcGrid → See pricing →The free .NET Community edition is esegece.sgcGrid.Community on NuGet. A project references either the Community or the Registered packages, never both. The free Delphi Community edition is on the download page.
| Feature | Community (free) | Registered |
|---|---|---|
| Live updates from any thread, flash on change, tail mode | ✓ | ✓ |
| Format rules with font styles and icon sets, themes | ✓ | ✓ |
| Sorting, filtering and selection | ✓ | ✓ |
| Grouping, group panel and summaries | ✓ | ✓ |
| Frozen columns and column resizing | ✓ | ✓ |
| Virtual mode | ✓ | ✓ |
| DataTable binding, the grid filter applied to the DataTable, JSON and CSV | ✓ | ✓ |
| Headless PNG and SVG | ✓ | ✓ |
| Column filters with date periods, filter row and find panel | ✓ | ✓ |
| Column chooser, column reordering, best fit, automatic layouts and columns that fill the width | ✓ | ✓ |
| Bands, image, progress, sparkline and tag cells, multi-selection | ✓ | ✓ |
| Check and link cells, images from BLOB fields, multi-line headers and rows, hints | ✓ | ✓ |
| Row header with check boxes, header images and buttons, selection colours, row drag and drop | ✓ | ✓ |
| Ask your grid: TsgcGridAI, the AI query bar and any LLM provider | ✓ | ✓ |
| In-place editing, check box toggling, memo and lookup editors | − | ✓ |
| Two-way DataTable editing, paste, undo and redo, sgcEditors cell editors | − | ✓ |
| Tree rows and master detail | − | ✓ |
| Excel export | − | ✓ |
| Excel mode, cell formatting, sheets and column formulas | − | ✓ |
| Server mode: database paging, sorting, filtering, summaries and grouping on the server | − | ✓ |
| Card view | − | ✓ |
| Live feeds, TsgcGridAIQuery and the sgcWebSockets AI provider (sgcGridWS and sgcUICoreWS bridges) | − | ✓ |
| Component | Target |
|---|---|
| TsgcVCLGrid | Delphi and C++ Builder, VCL (sgcGrid_VCL) |
| TsgcFMXGrid | Delphi FireMonkey from XE6, on Windows, macOS, iOS and Android (sgcGrid_FMX) |
| TsgcGridData, TsgcGridColumns, TsgcGridFormatRules, TsgcGridLineView, TsgcGridRenderer | Framework neutral row store, columns, format rules and renderer, also on Linux64 |
| TsgcGridAI | Framework neutral natural language query engine, in every edition and also on Linux64 (sgcGrid_AI) |
| TsgcVCLAIQueryBar, TsgcFMXAIQueryBar, TsgcUIAIEventProvider | AI query bar and AI provider of sgcUICore, in every edition |
| TsgcUIAIChatProvider | sgcUICoreWS bridge: the TsgcAIChat of sgcWebSockets as the AI provider (Registered edition) |
| TsgcGridSource_DataSet, TsgcGridDataStore | TDataSet binding and the row store of master detail bands |
| TsgcGridFeedSource_WebSocket, TsgcGridFeedSource_MQTT, TsgcGridFeedSource_SSE, TsgcGridAIQuery | sgcGridWS bridge with sgcWebSockets (Registered edition) |
| TsgcWinFormsGrid, TsgcWpfGrid, TsgcAvaloniaGrid | .NET, WinForms, WPF and Avalonia |
| TsgcGridAI, TsgcWinFormsAIQueryBar, TsgcWpfAIQueryBar, TsgcAvaloniaAIQueryBar | .NET, natural language queries and the AI query bar for WinForms, WPF and Avalonia |
| Target | Component | Platforms |
|---|---|---|
| Delphi 7 to 13, VCL | TsgcVCLGrid | Win32, and Win64 from XE2 |
| Delphi XE6 to 13, FireMonkey | TsgcFMXGrid | Windows, macOS, iOS and Android |
| C++ Builder 2007 to 13 | TsgcVCLGrid, TsgcFMXGrid | Generated .hpp headers and static libraries |
| Delphi 10.2 to 13, framework neutral | Model, formatting, renderer, JSON and CSV | Linux64, for example to render grid images on a server |
| .NET Framework 4.7.2, .NET 8, 9 and 10 | TsgcWinFormsGrid, WPF and Avalonia grids | WinForms, WPF, Avalonia, headless PNG and SVG |
Yes. AppendRow, UpdateRow, UpdateCell and DeleteRow of the grid data are thread safe, so a worker thread writes rows by key directly. The grid repaints on the main thread at most MaxFPS times per second. See Live updates.
Only the visible rows are painted, so the cost of a frame depends on the window, not on the row count. The QA gate measures a 1080p frame of a 100,000 row grid at 3.0 ms on Win32 and 4.6 ms on Win64. For data that lives elsewhere, virtual mode stores no rows and asks for values as they scroll into view. See Performance.
Yes, in server mode. A provider reads one page of rows at a time, and the database evaluates the sort, the column filters, the filter row, the find text, the footer summaries, the grouping and the row count. On Delphi and C++ Builder, TsgcGridServerProvider_DataSet builds the SQL for SQLite, SQL Server, PostgreSQL, MySQL, Oracle, Firebird, InterBase or a generic dialect and runs it through any query component. On .NET the providers read an IQueryable, such as an Entity Framework Core set, or an ADO.NET connection, and a callback provider serves any other source. The card view pages the same way. Server mode is in the Registered edition. See Server Mode.
Yes. TsgcGridSource_DataSet fills a grid from any TDataSet, creates the columns with AutoColumns and, with LiveUpdates, follows every Append, Edit and Delete of the dataset. With a KeyField changed rows are updated in place instead of reloaded. In .NET the same source reads a DataTable. See DataSet binding.
Yes. TsgcVCLGrid is an ordinary VCL control, so it can sit on a form next to an existing TStringGrid or TDBGrid. A TDBGrid screen keeps its dataset and adds a TsgcGridSource_DataSet; a TStringGrid screen writes its rows with AppendRow and UpdateRow by key. There is no automatic conversion of whole forms, but at design time the Import columns from DB grid command of the grid context menu copies the columns, the DataSet link, the position and the events of an existing TDBGrid.
In-place editing, check box toggling, the memo and lookup editors, two-way DataTable editing, paste, undo and redo, the sgcEditors cell editors, tree rows, master detail rows, Excel export, Excel mode with cell formatting, sheets and column formulas, server mode, the card view, the sgcGridWS bridge and the alarm acknowledge log. Sorting, filtering, the filter row and the find panel, grouping, summaries, frozen columns, the column chooser, layouts and automatic layouts, columns that fill the width, bands, image, progress, sparkline, tag, link and check cells, images from BLOB fields, multi-line headers and rows, hints, the row header strip, header images and buttons, row drag and drop, multi-selection, format rules with icon sets, date period filters, virtual mode, JSON and CSV, the headless output, the ISA-18.2 alarm list and Ask your grid with TsgcGridAI are in every edition. See Editions.
Yes. Sizes such as GroupIndent and GroupPanelHeight are device independent pixels, and the VCL grid scales them to the DPI of its monitor, per monitor from Delphi 10.3. Theme switches between utLight and utDark, AccentColor sets the selection and flash accent.
Introduction, Quick Start VCL, Quick Start FMX, Live updates, Performance, Editions, Platforms.
Delphi, C++ Builder and .NET, covering every sgcUI product.
A TsgcChartDataSource_Table plots the grid rows and follows its sort and filter, so grid and chart never drift apart.
When grouped rows are not enough, sgcPivotGrid summarises records as a pivot table with fields on rows and columns.
Explore sgcPivotGrid →
A grid in a dashboard tile follows the dashboard theme; the GridAndChart demo pairs it with a chart tile.
Explore sgcDashboard →A migration kit maps each TDBGrid and DevExpress cxGrid member you use to its sgcGrid twin, with code from a compiled demo, numbered migration steps and the known differences.
Migrate from TDBGrid and cxGrid →