Scalabium Software
Knowledge for your independence'.
Home Delphi and C++Builder tips

#43: How can I iterate the selected rows in DBGrid?

If your users can select a rows in the DBGrid, then you must navigate and process them. The TDBGrid component have a SelectedRows property, in which stores a list with bookmarks on each selected record.

var i: Integer;
begin
  for i := 0 to yourMDBGrid.SelectedRows.Count-1 do
  begin
    yourMDBGrid.DataSource.DataSet.Bookmark := yourMDBGrid.SelectedRows[i];

    {here you can process a selected record.
     For example, to sum the Amount field values}
    Inc(intSumAmount, yourMDBGrid.DataSource.DataSet.FieldByName('Amount').AsFloat);
  end;
end;

Published: November 19, 1999

See also

	SMExport suite
	dBase Viewer
	SMImport suite
	Clarion to Text converter
	ABA Database Convert
	ABA Spreadsheet Convert
	SMDBGrid
	Metafile Convert
	ABA Document Convert
	SMMsg suite

Contact to webmaster