Difference between revisions of "Database Access Controls VB6"

From Free Knowledge Base- The DUCK Project: information for everyone
Jump to: navigation, search
m
m
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 20: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.