Database Access Controls VB6: Difference between revisions

From Free Knowledge Base- The DUCK Project
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 1: Line 1:
== Controls ==
Common grids.


* MSFlexGrid
* MSFlexGrid
* DataGrid
* DataGrid
There are many types.
* DBGrid, DataGrid, MSFlexGrid, MSHFlexGrid, and Sheridan Grids (SSDBGrid, etc.).
Editing Cells is not native to these controls.  One trick is to use a hidden text box control with a Grid.OCX (VB4) or a MSFlexGrid.OCX (VB5/6) control to make an editable grid control.  It would work by having a hidden textbox on the same form as the Grid Control and positioning it over the relevant cell when editing is to occur.  Reference: [http://www.codeguru.com/vb/controls/vb_othctrl/article.php/c1509/ Editable FlexGrid/Grid Control in VB4/5/6]
Editing Cells is not native to these controls.  One trick is to use a hidden text box control with a Grid.OCX (VB4) or a MSFlexGrid.OCX (VB5/6) control to make an editable grid control.  It would work by having a hidden textbox on the same form as the Grid Control and positioning it over the relevant cell when editing is to occur.  Reference: [http://www.codeguru.com/vb/controls/vb_othctrl/article.php/c1509/ Editable FlexGrid/Grid Control in VB4/5/6]



Revision as of 19:54, 21 September 2007

Common grids.

  • MSFlexGrid
  • DataGrid

There are many types.

  • DBGrid, DataGrid, MSFlexGrid, MSHFlexGrid, and Sheridan Grids (SSDBGrid, etc.).

Editing Cells is not native to these controls. One trick is to use a hidden text box control with a Grid.OCX (VB4) or a MSFlexGrid.OCX (VB5/6) control to make an editable grid control. It would work by having a hidden textbox on the same form as the Grid Control and positioning it over the relevant cell when editing is to occur. Reference: Editable FlexGrid/Grid Control in VB4/5/6

  • Don't confuse the FlexGrid control with the DataGrid control—both controls use the same icon but behave differently.
  • The difference between the flex grid controls and the DataGrid control is that both versions of the flex grid control only allow you to look into the database, a snapshot and not a dynaset. With the DataGrid control you can look into the data as well as build up the grid and edit the data.