Solved

Differences, Pros and Cons to Datagrid & MSFlexgrid

Posted on 2001-08-28
4
321 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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

743 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now