Stack Overflow
Stack Overflow

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
2
votes
1 answer

How to set the order of characters in TDBGrid sorting?

I'm using a TDBGrid connected to a TDataSource. This TDataSource uses a TADOQuery as its dataset. The TADOQuery connects to a Oracle10g database and holds the following query: SELECT ST.desc FROM my.subsection ST WHERE ST.date_disp = :dated ORDER…
gustavogbc
  • 695
  • 11
  • 33
2
votes
2 answers

Where the TDBGrid Columns resize event was triggered

I have a TDBGrid component. I need to catch the event triggered when I'm resizing a column of the grid.
Jessie M
  • 498
  • 1
  • 9
  • 23
2
votes
2 answers

Exporting DBgrid to CSV?

I have a DB grid which is sorted (the user clicked a few radio buttons and checkboxes to influence the display). I would like to export all of the data (not just what is visible in the grid), sorted identically, to CSV - how do I do so? The data -…
Mawg says reinstate Monica
  • 38,334
  • 103
  • 306
  • 551
2
votes
4 answers

Printing a TDBGrid

I'm working with Delphi 2009 and I really need to create a button that can print all my data in a DBGrid. I appreciate all the help I can get.
None
1
vote
3 answers

How to get selected cells from TDBGrid in Delphi 5

I have a DBGrid on a form and I have made multiple selections, I now need to send the selected cells (they are email addresses) to the "TO Box" of Outlook how can I do this, I will appreciate any help ( Delphi5) Thanks in advance
Roy
1
vote
1 answer

Column.Index is not reflecting immediately in TDBGrid

I have a TDBGrid and have a Client dataset associated through a TDataSource. When i try to re-arrange the columns of the grid programtically this works fine when there are one or more columns in the grid. Lets say, i made all the columns visible to…
Rahul W
  • 833
  • 11
  • 26
1
vote
1 answer

How to use onDrawColumnCell to change cell text without using textout on Delphi?

I would like to ask if there is another way to alter the cell text without using TextOut()? Using TextOut() requires coordinates which I do not want to mingle into. Besides, I just want to change the text and retain everything else, like color,…
jwan
  • 41
  • 5
1
vote
0 answers

Delphi TDBGrid inserts new record on tab press

Sometimes when the user presses the tab key and it's not in the last column in a TDBGrid it creates a new row and sets the linked DataSet state to dsInsert. I cannot understand why it happens nor avoid it.
Dofunt
  • 11
  • 1
1
vote
1 answer

How to load a XML/CSV/ODB file in DBGrid in Lazarus/Free Pascal?

I want to open a database/spreadsheet in a TDBGrid in Lazarus, and I've tried DBGrid1.LoadFromFile(filename); with xml, csv, xlsx, odb. But with every file I get an error. This is the code I'm using, with 'xml' being different each time I…
Smiley17
  • 31
  • 7
1
vote
1 answer

How to post data in TDBgrid immediately when exiting the cell being edited

I have a TDBGrid --> Tdatasource --> TQuery --> table in MySQL database. One field in the grid/query is Boolean and is shown as a checkbox. I have written code to sort the grid by whichever column title I click following standard answers on SO. I…
user2834566
  • 775
  • 9
  • 22
1
vote
1 answer

TDBGrid - Synchronisation or display problem

I am facing a very strange problem in one of my programs. I have a TSQLConnection followed by two TSQLQUery, TDataSetProvider, TClientDataSet and TDataSource. Its a Master-Detail structure. The TDataSource of the detail query has an additional…
Marks
  • 3,613
  • 5
  • 31
  • 46
1
vote
1 answer

TClientDataset to edit a table with 100k+ records

A client wants to build a worksheet-like application to show data from a database (presumably on a TDbGrid or similar), allowing free search and edition of all cells, as you would do in a worksheet. Underlying table will have more than 100k…
oscar
  • 355
  • 1
  • 2
  • 13
1
vote
1 answer

Scaling DbGrid Indicator and DbNavigator Icons on 4K display

I am using DPro Rio 10.3 on an HP Spectre x360, which has a 4K display. The indicator on DbGrids and icons for DbNavigator controls scale fine at 1980 X 1080, but are almost invisible at 4K resolution. Text scales fine at any resolution. I looked…
Terry Thompson
  • 489
  • 2
  • 15
1
vote
1 answer

Attach TEdit boxes to a TDBgrid column

How can I attach the edit boxes to the corresponding grid columns, so it will change width when the user change the column width and move around when the user change the order of DBGraid columns.
Najem
  • 537
  • 4
  • 12
1
vote
1 answer

How can I show TDBGrid columns editor at run time?

I want to make it so that the user with himself changes the properties of the TDBGrid columns at columns editor in run time and then save columns properties (font name, font size, column width, etc). I need show TDBGrid columns editor at run time.
Aleks
  • 35
  • 2
1 2 3
…
10 11