INTERVIEW QUESTIONS MICROSOFT VISUAL BASIC DETAILS

Question: 3 main differences between flexgrid control and dbgrid control?

Answer:

Source: CoolInterview.com

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.


Source: CoolInterview.com

1.we can highlite the row or specific column of flexgrid but can't do in data grid
2.no of rows are fixed in datagrid but it is flexible in flexgrid.
Source: CoolInterview.com

Using Dbgrid we can connect with database by specify datasource and in flexgrid we have to insert all the values by coding. Not possible to connect with datasource. Source: CoolInterview.com

The 3 Difference between data grid and flex grid

1. Data Grid 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
AND
1. Datagrid is Editable flexgrid is Diplay only.
2. Data binding is possible with datagrid but not with flexgrid.
Source: CoolInterview.com

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. Source: CoolInterview.com

Flexgrid can be increase/decrease the row or colmns by code, but cant be in datagrid, datagrid will function based on recordset. Source: CoolInterview.com

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 id 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.
Source: CoolInterview.com

Datagrid
1>it is editable
2>displays as spread sheet


Flexigrid
1>non editable
2>displays and operates as tabular data Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question