dbgrid

Is there a DBGrid component that can handle large datasets fast?

Large datasets, millions of records, need special programming to maintain speed in DBGrids. I want to know if there are any ready-made components for Delphi (DBGrids) that do this automatically? EDIT For Example: Some databases have features such as fetch 1st X records (eg 100 records). When I reach the bottom with scrolling, I want t...

Setting a DBGrid column format in Delphi

I am using a DBGrid component in delphi. I wonder how I can set the format of a column. I have real values that I want to be displayed as currency in the grid. Someone knows how? ...

View position in DBGrid when scrolling in Delphi.

I have a DBGrid on a form. The DBGrid has many columns, so an horizontal scroller is displayed. I scroll the DBGrid view to the right to see more columns. If I select a row, the DBGrid view is automatically reset to view the first column (As if I scroll back to the left most position). Is there a way to prevent that? ...

options in dbgrid or combobox in dbgrid

Hello I want to give 3 options for a column in a DBGrid. How to achieve this. How to drop and incorporate a combobox for the same in dbgrid. regards sridhar ...

Sort DBGrid by clicking column's title

Well, this seems a little tricky (if not imposible). I'm tryin to make my DBGrid sort its data by clicking on column's title. The thing is that I'm (sadly) working with Delphi3, I'm not using ADO DataSets and the query gets a lot of rows, thus I can't reopen my TQuery changing the "order by" clause on clicks. Someone has implemented so...

Are there any good free/cheap Delphi grid controls?

I gave up on Delphi's DBGrid nearly a decade ago because it is simply no good. Since then, I have used Virtual TreeView which offers a lot of value but it has a few issues. Like the current state of development (e.g. None) and the fact that there is no good data-bound version. DevExpress's QuantumGrid is famous for the rich feature set b...

How can i print a dbgrid?

I'm working with delphi2009 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. ...

DBGrid scroll page instead of row

Well I have an issue with DBGrid vertical scrolling. When I scroll it vertically with mousewheel or vertical scrollbar it moves selected row up and down. I want to make it scroll not selected row but entire grid. Just like it works in Microsoft Excel for example (just to let you know what I mean). Any suggestions? ...

How to get rid of the empty space in the right part of DBGrid Delphi

Although the question seems simple, I couldn't find the answer to it. I have a DBGrid component with lots of columns, and as a result they don't fit into the page and scrollbar appears. I also have column-autofix mechanism, which makes each column have width of the longest element in the table. When I scroll DBGrid to the right-end the...

VCLSkin, TDBGrid column header skinning?

Hi, Having tried VCLSkin from http://link-rank.com, i came to an issue where column header skin didn't work on TStringGrid descendants including TDBGrid. I want it to display header similar like TListView colum header in report mode. Anyone has code to solve this problem? PS: already looked http://andy.jgknet.de/blog/?page%5Fid=206, ...

Select row after refreshing DBGrid

Well, some kind of n00b question from me. I've surfed the net and similar questions here but haven't found any right answers for such simple (as I thought) problem. I have a DBGrid. I select one row and make some actions with another data linked to this row. After I finished, my DBGrid being refreshed and selected row resets to first. I...

How to find the actual width of grid component with scrollbar in Delphi

I have a grid component (DBGrid) which has lots of columns on it. Because of large number of columns, a scrollbar was created, and thus some part of grid remains hidden. I need to find out what is the real width of DBGrid, including the part which is not shown due to scroll bar. But Width property gives only the width of the component it...

How to catch scrolling event in DBGrid in Delphi

I have a DBGrid, I need to run some code, each time the horizontal scrollbar is used. I couldn't find such event in DBGrid. Can you advise something? ...

DBGrid get selected cell

i need to get the value of the selected cell of a DBGrid in Delphi (i have no idea how to do it, i tryed dbGrid's OnMouseMove pt : TGridCoord; ... pt:=dbGrid.MouseCoord(x, y); ) [Edited] I can use the OnCellClick to get the value of the cell with "Column.Field.AsString", but i want to get the value from the first column when i click on...

Repositioning columns in DBGrid in Delphi

I need to dynamically change position of certain column in DBGRid. Let's say I need to place column number 21 on position 10. I use: DBGrid.Columns[21].Index:=10; But, this also changes the array itself, that means, that next time I want to access this column, I will need to write DBGrid.Columns[10], this makes it a little unclean, I ...

dbgrid text search

how to search dbgrid column with query not table ...

Looking for a free, customizable DB grid

I'm working on converting the codebase of an "open-source" project to something that will actually work. I put the term in quotes because what the original authors did was take a commercial product and say "OK, we've made enough money off this now. Here's the source code. Do whatever you'd like to with it." Unfortunately, the codebas...

"key violation" autoincrement field in ClientDataSet [Delphi]

Hi, this is my third question here, so far excellent responses ^^ I'm having no problems in browsing, editing the data, but insertions... Here is my doubt: In a finance/stock software i have a form to create a new order, naturally i need to insert a new row in t_orders table and insert items in t_orderitems table with orderId field lin...

How to refresh dbgrid without close and open dataset in delphi?

I need to refresh dbgrid constantly, in real time. Close and open dataset works fine, but blink the dbgrid. What can I do to avoid this? I'd like a solution like Ajax, that update only the necessary. Thanks ...

Is There a way to update/refresh only one record in delphi dbgrid?

Is it possible? How? ...