Questions tagged [tdbgrid]

TDBGrid is a VCL control used to display and manipulate records from a TDataset in a tabular fashioned way. It is defined in DbGrids.pas unit.

156 questions
0
votes
2 answers

How to get each row from a TDBGrid in c++

I am using embarcadero c++ builder and i want to copy the result of a query contained in a DBGrid, is there a way to get each row from the DBGrid?
0
votes
1 answer

Sending email using TIdSMTP and TIdMessage

I'm using an action from my ActionManager to send an email to a client in my DBGrid. I select the row with the client details in my DBGrid, right click, a Popupactionbar comes up, I click the send mail action and the mail should be sending. This is…
t1f
  • 3,021
  • 3
  • 31
  • 61
0
votes
1 answer

DBGrid - OnCellClick & OnDblClick, return a form/TBMemo containing cell/column value/s

I'm using the following code added to my DBGrid - OnCellClick event procedure TForm2.DBGrid1CellClick(Column: TColumn); begin if dbmodule.comenziDataSet.Active then begin if not Assigned(dbgridCelulaForm) then begin dbgridCelulaForm…
t1f
  • 3,021
  • 3
  • 31
  • 61
0
votes
1 answer

Adding a search that searches data in a DBGrid and temporarily changes what that DBGrid displays- Delphi

Ok so, I'm using a DBGrid that displays data from a database. The database contains a table which contains 11 columns. Column number 4 is called customer name and contains name of customers. I'd like a search box (similar to google search bar) where…
t1f
  • 3,021
  • 3
  • 31
  • 61
0
votes
0 answers

Delphi TDBGrid edit inplace with drop down list

I have to do maintenance to an old Delphi v7 application which uses a TDBGrid allowing inplace editting with drop down lists. The issue is: the grid will show only the values present at data source. Without editting, this would be no problem at all.…
rslemos
  • 2,454
  • 22
  • 32
0
votes
1 answer

Stop Auto Edit working in TDBGrid

D5, ZEOS 6.6, SQLite. I have srcAccount.AutoEdit = False; I have All Edit functions set to False in the TDBGrid Options. Only options are set to true are Indicator, grind lines and Titles. I have a form with a few TDBEdits and a TDBGrid on it…
user2175495
0
votes
1 answer

Twwdbgrid.PaintOptions.ActiveRecordColor - change background color and font color

I built a project using Delphi 7 with Infopower and 1stClass components. In one of my forms is use the TwwDBGrid Component. My Task is when the user selects a specific record, this one to be highlighted with a specific color. Even though one of…
kostas
  • 75
  • 1
  • 13
0
votes
3 answers

Select Multiple Rows on Shift+Click in DBGrid

I need to write the code to select multiple rows on Shift+MouseClick, so that I am able to fill down the values. Is there any way I can do it? My DBGrid options are as follows: dbGrid1.Options = [dgEditing, dgAlwaysShowEditor, dgTitles, dgColLines,…
jetty
  • 859
  • 2
  • 17
  • 37
0
votes
1 answer

Change color of DBGrid row

how change latest rec color dbgrid? if (Sender as TDBGrid).DataSource.DataSet.RecNo = (Sender as TDBGrid) .DataSource.DataSet.RecordCount then begin Canvas.Brush.Color := $00C66F71; end; (Sender as TDBGrid).DefaultDrawColumnCell(Rect, DataCol,…
Michael Bosh
  • 13
  • 1
  • 8
0
votes
1 answer

Delphi Style issue TDBGrid Vertical Scroll choppy when scrolling

I'm using Delphi XE5 with a Style applied. When using a DBGrid that has enough records to show the vertical scroll bar, clicking and dragging the scroll bar results in a choppy animation. The grid keeps repainting/updating. If I set the…
Dangas56
  • 849
  • 1
  • 8
  • 32
0
votes
1 answer

How to Draw Vertical Centered Content on DBGrid

Edited: I want to draw a vertical centered TIcon graphic and Text on a TJvDBGrid (Project's Jedi descendant of TDBGrid). I tried to disable the DefaultDrawing method of JvDBGrid and override it, but I only could fill the cells with black (I think…
Mathias Berwig
  • 488
  • 5
  • 13
0
votes
1 answer

Set up SQL Database table in Delphi with TDBGrid (Unidirectional error)

How can i set the whole table of a database to show in my delphi form? Using TDBGrid i presume; but when I configure the data source (connected to a query) I receive an error message about it being Unidirectional. I've heard about a Clientdataset…
Toby Fox
  • 105
  • 4
  • 11
0
votes
2 answers

Editing data in Delphi controls and updating of its underlying dataset

In embarcadero docwiki, it says: In all data controls except TDBGrid, when you modify a field, the modification is copied to the underlying dataset when you Tab from the control. If you press Esc before you Tab from a field, the data control…
rbndeveloper
  • 123
  • 2
  • 8
0
votes
3 answers

Is there a better way than this to stop a DBgrid flickering with time consuming updates?

Can anyone offer advice on how to achieve what I want in the situation below? (I wonder whether theads might help but haven't used them before.) In my Delphi application I have a query running against an external MYSQL database over the Internet.The…
user3209752
  • 619
  • 2
  • 17
  • 29
0
votes
1 answer

How to change selected row's border color and background color of style enabled DBGrid in delphi xe2?

I used default style "Amethyst Kamri" in application. And my DBgrid's selected row color change according to style. But i want to change selected row's border color and background color. I change font style using the answer of following…
Ganpat
  • 768
  • 3
  • 15
  • 30