Forum

Hi.

1. Is it possible to implement the drag drop feature for multiple rows/columns in the datagrid?
I think this would mean to allow multiple focused rows/columns, but I think it would be useful,
I don’t see the reason of restricting the drag drop to 1 row/column.

2. Is it possible to allow the editing of multiple selected cells?
I mean the user selects multiple cells, and he decides to assign the same value to all of them.
Implementing it from outside the datagrid is probably possible,
but it would be nice to use an in-place editor (maybe on the last selected cell?) that affects all selected rows.

Thanks.

Thank you for the interesting suggestions.

1) Drag-and-drop of multiple rows/columns and drag-and-drop of a custom cell range in the grid window can be implemented easy only for particular modes of the grid window. This can be done only if the grid window is NOT in:

a) Cacheable mode with a known row/column number.

b) Virtual mode with an unknown row/column count.

2) The editing of multiple cells has the same restrictions as in the first feature. Additionally, the multiple cell editing well applicable only if all the edited cells are well compatible with each other. The edited cells should have exactly the same type or similar types to apply the result correctly to all the cells. Although all the cells can be assigned and compared between each other, the assignment between some of them cannot be performed correctly. For example, assignment and comparison between date and currency is impossible.

Hi.

Could you please give us more details about Cacheable mode and Virtual mode?
Is there a sample that uses these modes?

The cacheable and virtual grid windows are demonstrated in the AdoRecordsetView sample application. Just open the recordset options dialog and specify database connection settings and an SQL Query. Now you can click OK to see the results in the grid window. There is one more important push-like check box in the recordset options dialog: the Use Virtual Mode button. If it is checked, the grid window displays data records in the virtual mode. If it is unchecked, the grid window displays data records in the simple cacheable mode. In fact, both modes are based on caching. This means the grid window keeps only data records which are visible on the screen. But simple cacheable mode is based on a database recordset with a known number of rows in the query result and you can see the vertical scrollbar that is working classically. The virtual mode is based on a database recordset with an unknown number of rows. The vertical scrollbar in the virtual mode can have only three states: top, middle and bottom. The virtual database recordset knows only the current record position and whether the current record at this position is the first and/or last record in the returned table. This explains the meaning of the grid virtual mode and the behavior of the scroll bar in this mode. The virtual mode can be used if the data base API supports only this kind of recordset or if you have a very large scrollable data range which often becomes updated dynamically. The Prof-UIS grid window supports the cacheable and/or virtual scrolling strategies in both horizontal and vertical directions even at the same time. So, scrolling the unlimited data source is not a problem.