Solved

Differences, Pros and Cons to Datagrid & MSFlexgrid

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
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…

739 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