Solved

Differences, Pros and Cons to Datagrid & MSFlexgrid

Posted on 2001-08-28
4
332 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
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…
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…

726 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