What Grid it is better to use (that came with visual studio) ?

Posted on 2002-06-07
Medium Priority
Last Modified: 2010-05-02
Hi Experts.

What Grid it is better to use (that came with visual studio) ? and i don't meen to grid that came with

out supplier like "True DB grid".

i need to do work with the standard microsoft controls.


Question by:Alon10003
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
LVL 22

Expert Comment

by:Mohammed Nasman
ID: 7061470

  There's two grids came, Data Grid, and MS Flex Grid

  both of them not allow you to edit the data, so i think if you could have another one, it's will be better
LVL 43

Expert Comment

ID: 7061491
What do you want to use the grid for?

There are a variety of grids with different properties:

DBGrid : Compatible with DAO and allows in-cell editing but not complex formatting of cells such as colours etc.
Datagrid: Similar to DBGrid but also supports ADO.
Flexgrid : Supports DAO and to some extent ADO but does allow complex formatting of cells but not in-cell editing though this can be successfully simulated
MSHFlexgrid : Similar to flexgrid but also supports hierarchical recordsets.

If you can summarise your requirements for the grid then I can recommend the appropriate one for your requirements and also help you work-around some of the limitations of the grid that is chosen.
LVL 23

Expert Comment

by:Roshan Davis
ID: 7061499
Check these links


some interesting Custom Grid Controls.

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Accepted Solution

priya_pbk earned 1000 total points
ID: 7061517
I always think, the DataGrid is a better tool to use if one has to edit, update and delete the records and for just displaying the records, the MSHFlexgrid is a good one.

Both of these controls can be bound to Adodc control.

I would not prefer to choose the Msflexgird and the DBgrid coz both of them are more compatible with DAO and not ADO, which i think is used more often in Vb applications

Again, choose that which your application needs to run it effeciently.

LVL 70

Expert Comment

by:Éric Moreau
ID: 7061817
You already asked this question on May 26 and had accepted the FlexGrid. What else do you want?

Anyway, have a look at http://vbaccelerator.com/codelib/sgrid/sgrid.htm
LVL 49

Expert Comment

ID: 7873331
Hi Alon10003,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Split points between: TimCottee and priya_pbk

Alon10003, if you think your question was not answered at all or if you need help, just post a new comment here; Community Support will help you.  DO NOT accept this comment as an answer.

EXPERTS: If you disagree with that recommendation, please post an explanatory comment.
DanRollins -- EE database cleanup volunteer

Expert Comment

ID: 7925006
per recommendation

Community Support Moderator @Experts Exchange

TimCottee points for you at:

Featured Post

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

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

If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
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…
Suggested Courses
Course of the Month8 days, 15 hours left to enroll

764 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