Solved

Differences, Pros and Cons to Datagrid & MSFlexgrid

Posted on 2001-08-28
4
325 Views
Last Modified: 2012-06-21
I am curious about the Pro's and Con's of a DataGrid and a FlexGrid.  What are the major differences? Why use one instead of the other?  

I don't mind links to sights, but I would prefer personal opinions as well.

I will raise points to (100) for a clearly defined answer.
0
Comment
Question by:etstiles
4 Comments
 
LVL 1

Expert Comment

by:krees
ID: 6433899
DataGrid is a bound-only control that shipped with VB since version 3 i think. FlexGrid is a customized stripped version of ComponentOne FlexGrid, although is also bound, you can use it unbound. The latter is better to use because is better programmed and has many other features than DataGrid does not.

Also, over testing I found that the flexgrid is sometimes more responsive than the datagrid, has more control over the appareance of the cells and captions and more properties for you to fiddle with, and has better performance with large recordsets.

I recommend you to use FlexGrid instead of the DataGrid.
0
 

Accepted Solution

by:
jayvb earned 60 total points
ID: 6435311
Datagrid, MSFlexgrid and MSHflexgrid are all data representation in tabular form.

Datagrid (specific to vb6.0)needs Adodc control to bind data. Datagrid must be databound either at design time or at run time.

MSFlexgrid is specific for vb5.0 which need not be databound at design or run time. You can load any values in tabular form using the col and row.text properties. Datagrid does not have these properties.

MSHFlexGrid is specific to vb6.0 where dat can be bound at run time using recordset property of the grid. it can function like MSFlexgrid where any data not neccessarily from database can be displayed using text properties of row and col. A hierarchy can also be built up using child command object or shape functions.

regards
0
 
LVL 3

Expert Comment

by:Bahnass
ID: 6435559
Hi
    I want Just to add
    DataGrid is easier to use as End user can just Write inside cell
Flex Needs some code to Create some entry control OVER a cell to simulate same operation

U can then use     TextMatrix(Row,Col) property to fill in Grid ( that doesnot fire RowColChange event )

Thaugh Headache of Using Flex   I prefer to use it.....but with expert caution in data entry
( Many problems in Lostfocus, gotfocus, ....events)


0
 

Author Comment

by:etstiles
ID: 6436184
Thank you for the answer.  Thanks also to the others.  While I appreciate the answer, it was explained clearly, I am not going to raise the points.  It was very general with minimal detail.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question