关于DbgridEh.Columns.DropDownBox.Columns的问题？

das 2003-10-18 12:21:09

Ehlib2.6中自带的Demos1里的范例程序中，该属性选中后弹出编辑框，鼠标右键菜单中可选中"Add All Fields"，它是怎样与什么数据源关联的？搞了半天了，上火。

...全文

177 1 打赏收藏转发到动态举报

写回复

1 条回复

切换为时间正序

请发表友善的回复…

发表回复

yzykjh 2003-10-18

打赏
举报

回复

这是组件开发的问题。建议你看看《Delphi 5开发人员指南》这本书中组件方面的内容。

dbgrideh 中的keylist,picklist的用法,有交流Delphi请留言。

The history of the EhLib library -------------------------------- Version 6.1 + A new component TDBVertGridEh - DataSet Grid with the Vertical Orientation. The component is used to display and edit a single record of DataSet in a vertical orientation. Basic properties of the TDBVertGridEh: Rows: TDBVerGridRows - A collection of items of TFieldRowEh type to display fields of a record. This is analogous to the Columns collection in TDBGridEh. Options: TDBVHGridOptions - Configure basic properties of the vertical grid. RowsDefValues: TFieldRowDefValuesEh - default values for line Grid row - TFieldRowEh. This is analogous of ColumnDefValues in TDBGridEh. GridLineParams: TDBVertGridLineParamsEh - Color settings of the dividing lines in vertical grid. DataColParams: TDBVertGridDataColParamsEh - The setting of the column with data. LabelColParams: TDBVertGridLabelColParamEh - The setting of the column with row label. See an example of using TDBVertGridEh in a project: <EhLib Archive> \ Demos \ DBVertGridEh.SimpleDemo \ Project1.dpr compiled project: <EhLib Archive> \ Demos \ Bin \ DBVertGridEh.SimpleDemo.Exe * There are changes in the grids inheritance tree: New inheritance tree is: TCustomControl | - TCustomGridEh | - TCustomDBAxisGridEh | - TCustomDBGridEh | | | - TDBGridEh | - TCustomDBVertGridEh | - TDBVertGridEh * Some constants and procedures are moved from the module DBGridEh to the DBAxisGridsEh. + Added a new global function to display a ObjectInspector-like Form. Use the next procedure to display the ObjectInspector-like Form: procedure ShowObjectInspectorForm ( Component: TObject; // A component to Inspect FormBounds: TRect; // Form Borders NewForm: Boolean = False // Show as a new Form ); This is a simple ObjectInspector that can be used to debug property setting at run-time. See an example that shows how to use ShowObjectInspectorForm here: <EhLib Archive> \ Demos \ ObjectInspectorForm.SimpleDemo \ Project1.dpr compiled project: <EhLib Archive> \ Demos \ Bin \ ObjectInspectorForm.SimpleDemo.Exe In DBGridEh + Added an ability to change the size of RowDetailPanel by mouse at RunTime. New properties in RowDetailPanel: property VertSizing: Boolean - Show an RowDetailPanel Splitter at the buttom of the RowDetailPanel. property MinHeight: Integer - Minimum height of the RowDetailPanel. property MaxHeight: Integer - Maximum height of the RowDetailPanel. property SizingBarBeveled: Boolean - Splitter area has a 3D border. property SizingBarHeight: Integer - The height of the Splitter. + Added an ability to darken gray the grid while the data is loading. See StartLoadingStatus and FinishLoadingStatus methods in the TDBGridEh. See the example that shows this opportunity in a project: <EhLib Archive> \ Demos \ DBGridEh.LoadingStatus \ Project1.dpr compiled project: <EhLib Archive> \ Demos \ Bin \ DBGridEh.LoadingStatus.Exe

一个DBGrid转excel文件的类 Delphi环境，用的XLSReadWrite。下面代码设置列宽,导出数据时应将AutoFitColWidths属性值设置为False 　　 XLS.Sheet[0].Columns.AddIfNone(0,FColumnCount); 　　 FitColWidths:=FDBGridEh.AutoFitColWidths; 　　 FDBGridEh.AutoFitColWidths:=False; 　　 for i:=0 to FColumnCount-1 do 　　 XLS.Sheet[0].Columns[i].PixelWidth:=FDBGridEh.Columns[i].Width; 　　 FDBGridEh.AutoFitColWidths:=FitColWidths; 　　 //下面代码设置标题行行高　　 XLS.Sheet[0].Rows.AddIfNone(FStartRow,FTitleRowCount); 　　 for i:=FStartRow to FStartRow FTitleRowCount-1 do 　　 XLS.Sheet[0].Rows[i].PixelHeight:=GetTitleHeightFull; 　　end; 　　另外还有导出数据行、显示进度条进度、输出DBGridEh表脚、设置单元格横向对齐方式、设置单元格显示格式、设置数据行行高等功能的代码，请下载类源码。

+ A new property SelectionDrawParams: TGridSelectionDrawParamsEh SelectionDrawParams property is added in DBGridEh and DBVertGridEh component, which allows you to customize the style of the currently selected cell. The property has the following sub-properties: SelectionStyle: TGridSelectionDrawStyleEh - paint style of the currently selected cell DrawFocusFrame: Boolean - Specifies whether to draw a dotted border around the currently selected cell. TGridSelectionStyleEh type contains the following values: gsdsDefaultEh - The default style is determined depending on the version of the OS and included Windows schemas and Delphi schemas.If Windows schemes is on the gssListViewThemedEh is used. If the active style of Delphi XE is on the GridThemed style is used. gsdsClassicEh - Classic style. The cell is painted by uniform clSelected color. gsdsGridThemedEh - The Delphi XE style is used to draw a celeced cell. gsdsListViewThemedEh - Windows ListView style is to draw a celeced cell. For a global management of style use the properties of the global object GridDrawStyle of TGridDrawStyleEh type. Use the procedure GridDefaultDrawStyleEh, SetGridDefaultDrawStyleEh, declared in a module GridsEh.pas to access GridDrawStyle the object. TGridDrawStyleEh type has the following properties: SelectionStyle: TGridSelectionStyleEh - style shading display the currently selected cell. DrawFocusFrame: Boolean - Specifies whether to draw a dotted border around the currently selected cell. To change the style of lighting in all grids of project, use code like this: unit MyMainForm; uses ... GridsEh; .... initialization GridDefaultDrawStyleEh.SelectionStyle := gsdsClassicEh; //Draw selected cell by the classic style. end. Setting Lookup relationships directly in the columns of the grid without using of lookup fields. + A new property - Column.LookupParams: TDBLookupDataEh in columns of DBGridEh and DBVertGridEh. The property allows you to setup lookup relationship in the grid columns. The property consists of the following sub-properties: KeyFieldNames: String - Identifies the field or fields in the dataset that must be matched in a lookup dataset when doing a lookup. LookupCache: Boolean - Determines whether the values of a lookup field are cached or looked up dynamically every time the current record in the dataset changes. LookupDataSet: TDataSet - Identifies the dataset used to look up field values. LookupDisplayFieldName: String - Identifies the field from the lookup dataset whose value is displayed in place of KeyFields. LookupKeyFieldNames: String - Identifies the field or fields in the lookup dataset to match when doing a lookup. Other features of this version + New property - TBaseColumnEh.CaseInsensitiveTextSearch: Boolean default True. Defines CaseInsensitive search in a text editor for the dropdownbox items. The property as added in columns of DBGridEh, DBVertGridEh and in TDBComboboxEh TDBLookupcomboboxEh controls. + LimitTextToListValues property of Boolean type. Defines to limit of values in the edit box by the list of values in the dropdownbox. The property as added in columns of DBGridEh DBVertGridEh and in TDBComboboxEh control. + In DBGridEh. At Design-Time it is allowed select DataSet from the list of Favorite DataSets DataSet is created via the Grid Design Panel. + In the Filter Drop-down lists of the DBGridEh it is allowed to selected several values quickly by pressing and dragging the pressed mouse. + In DBGridEh. If gioShowRowselCheckboxesEh value is in the DBGridEh.IndicatorOptions property then it is allowed to selected several records quickly by pressing and dragging the pressed mouse. + In DBGridEh.Pas A new property ColWidthsOptimizationMaxWaitingTime is added in the global class TDBGridEhCenter. This property can be assigned by a maximum time, which will be used to calculate the widths of the columns when the user double click on the line that separates columns. If the time of calculation of column widths is exceeded the value that was set in ColWidthsOptimizationMaxWaitingTime then grid cancels a calculation of the remaining records. The default value is 2000 (2 seconds). + New property ShowImageAndText is added in the TColumnTitleEh class. If ShowImageAndText = True and the title of the grid is set to display images from TitleParams.Images, then the text of the column header will be displayed along with the picture. If ShowImageAndText = False, it will only display the picture without the text. + New methods GetColCellParams GetTitleParams RowDetailPanelShow and RowDetailPanelHide are added in the global class TDBGridEhCenter, This mathods are virtual methods so you can override them in new derived class TMyDBGridEhCenter and control corresponding events for all Grids of the project. (DBVertGridsEh.pas) + A new property OptionsEh of TDBVHGridOptionsEh type is added in the TDBVertGridEh component. TDBVHGridOptionsEh type contains the following values: dgvhHighlightFocusEh - Highlight the current cell when the grid has focus. dgvhClearSelectionEh - Clear a selected area when a user navigates the current cell in the grid. dgvhEnterToNextRowEh - Move the current cell to the next row in a grid when user presses an Enter key. dgvhTabToNextRowEh - Move the current cell to the next row in a grid when user presses an Tab key. dgvhRowsIsTabControlsEh - Rows in the grid are operated as a list of edit controls. ie : - Does not allow to leave the current record of DataSet with keyboard keys. - When the current cell in the grid is on the last line, the Tab key on the grid translates the input focus to the next TabStop Control of a Form (dgvhTabToNextRowEh property must be included). - When the current cell in the grid is on the first line , then by Alt+Tab key in the Grid will put focus to the previous TabStop Control of a Form (dgvhTabToNextRowEh property must be included). + TDBVertGridEh allows to select lines and rectangular region of cells with mouse or keyboard and supports ClipBoard operations. + A new property - AllowedSelections of TDBVertGridAllowedSelectionsEh. Specifies the permitted types of selections in the grid. vgstRowsEh - Allows to select lines in the grid with the mouse or with the keyboard. vgstRectangleEh - Allows the select square area in the grid with the mouse or with the keyboard. vgstAllEh - Allows to the select all the data in the grid by a Ctrl+A key combination. + A new property - EditActions of TGridEditActionsEh type. Defines the permitted operations with the selected area. geaCutEh, geaCopyEh, geaPasteEh, geaDeleteEh, geaSelectAllEh. + New Property - Selection of TDBVertGridSelectionEh type. The property contains information about the selected area in the Grid. + Added TDBVertGridEh.OnRowCategoriesNodeExpanded and TDBVertGridEh.OnRowCategoriesNodeCollapsed events. (DataDriverEh.pas) * Changes: Published parameter - TConnectionProviderEh.OnGetServerSpecOperations: TResolverGetServerSpecOperationsEh was changed. Old declaration: TResolverGetServerSpecOperationsEh = function (var Processed: Boolean): TServerSpecOperationsEh of object; New declaration: TResolverGetServerSpecOperationsEh = procedure (var Processed: Boolean; var ServerSpecOperations: TServerSpecOperationsEh) of object; Announcement via function caused an inexplicable error in compile-time in C++ Builder. (DBCtrlsEh.pas) + New events (OnCloseDropDownForm OnOpenDropDownForm) are added in TDBEditEh, TDBDateTimeEditEh, TDBComboBoxEh controls.

+ New type of DropDown calendar with support for entering date and time + Highlight holidays, weekends and current day in TPlannerCalendarPickerEh component + Highlight current day and current time in TPlannerControlEh + AllowedOperations property in TPlannerControlEh + ReadOnly state for TPlannerControlEh and TPlannerDataItemEh + Time divider of 5, 6, 10, 15, 30 and 60 minutes in TPlannerDayViewEh and TPlannerWeekViewEh components + New properties and events in TPlannerXXXViewEh components (TPlannerDayViewEh, TPlannerWeekViewEh …) + CellButtons in columns of DBGridEh and rows DBVertGridEh to create buttons in cells of the grid operating without activation InplaceEditor text editor. + Search in a mode of “Begins with” in SearchPanel + Selecting of rows in DBGridEh.DataGrouping mode by pressing the group row in the indicator section

5,386

社区成员

262,729

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章