Changes

Database Access Controls VB6

298 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.Common grids:* Don't confuse the FlexGrid control with the DataGrid control—both controls use the same icon but behave differently.Background:* The DataGrid control replaces the old DBGrid control from previous versions of Visual BASIC* Don't confuse the FlexGrid control with the DataGrid control—both controls use the same icon but behave differently.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]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 can use a DataGrid which does support Add, Update, and Delete data.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)]
Bureaucrat, administrator
16,192
edits