Changes

Database Access Controls VB6

408 bytes added, 12:59, 2 February 2008
[[Database Access Controls]] moved to [[Database Access Controls VB6]]
The following lines were added (+) and removed (-):
Common grids.=== Grid Types === * DBGrid, DataGrid, MSFlexGrid, MSHFlexGrid, and Sheridan Grids (SSDBGrid, etc.). Common grids:There are many types.Background: * 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]* The DataGrid control replaces the old DBGrid control from previous versions of Visual BASIC=== Editing Data ===You can use a DataGrid which does support Add, Update, and Delete data.  The DataGrid control allows you to update the database.  The MSFledGrid control does not.You cannot edit data in an MSFlexGrid without doing some trickery:  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]*[http://www.freevbcode.com/ShowCode.asp?ID=5163 Use a FlexGrid as a Datagrid (Tutorial and Demo)]
Admin
Bureaucrat, administrator
16,192
edits