What are the differences between flexgrid control and dbgrid control?

[Chandrakant81]

Hello!

What are the differences between flexgrid control and dbgrid control?

Please help!

[ArunJ]

1. Datagrid is Editable, flexgrid is Diplay only.

2. DBGrid allows full data binding while MSFlexGrid allows read-only binding

3. MSFlex grid is smaller and allows cell merging while Datagrid is larger and does not allow cell merging.

[Matellis]

Bound is truly evil - do not let it tempt you just because you can edit the grid...

Editing a flex grid is very easy by placing a textbox or combo box on top of the cell to edit - the VB help actually has samples of the code required to make this happen.

We do so much with the simple MS Flex Grid...

[Geo3213]

The Microsoft FlexGrid (MSFlexGrid) control displays and operates on tabular data. It allows complete flexibility to sort, merge, and format tables containing strings and pictures. When bound to a Data control, MSFlexGrid displays read-only data.Adaptation to existing Visual Basic code for the data-bound grid (DBGrid).
DBgrid is A spreadsheet-like bound control that displays a series of rows and columns representing records and fields from a Recordset object.

The data grids are bound controls; that is, they require a data source that actually connects to a database and retrieves their data. And it seems that the root of the problem with DBGrid is that there’s no data source that can be readily included along with the DBGrid control.
In Visual Basic, the solution is simply to include the Data Control on the same form as DBGrid. But the Data Control is an intrinsic control; it’s unavailable to anything outside of the Visual Basic environment itself. and VB 6.0 has a new set of data controls (DataGrid, DataList, DataCombo, MSHFlexGrid, MSFlexGrid) that once again are bound controls. Unlike DBGrid, though, they support OLE DB, and therefore rely on the an ADO Data Source (and in particular the ActiveX Data Objects Data Control, or ADO DC) for data access. Unlike the Data Control, the ADO DC is a custom control (that is, an .OCX) that can be added to any project. In short, if you add ADO DC to your project along with the DataGrid control.

[Alphonsus]

Hi,

1. In DB Grid you can do Add/Mod/Del Function in the DataSource Where as in Flex Grid direct these operation not possible.

2. We have Events for Before or After Editing a Column in DB Grid But in Flex Grid we do not have.