If you hate Microsoft DataGrid and you dont need, cant find or dont have $300 for other grid then
you are gonna love this ;).
This is an activex control made in vb to replace bug-plagued DataGrid that you got with vs6. It
is pretty fast, supports many things that are left behind in MS DataGrid and it is open-source
(though not for proper distribution for now). Have a look at screenshots if there are some (psc
might not allow me to upload them).
There are some examples included on how to use the grid. It does not matter what drivers are used
since this grid uses t-sql for reading/writing data. For now it does not support built-in
editors, but that is to be added in next version. Just download the example and experiment a bit.
If you need any help on using the control post comment here and I will be glad to help.
This is first version, so please post any bugs you may find.
Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzip to decompress it.Virus note:All files are scanned once-a-day by Planet Source Code for viruses, but new viruses come
out every day, so no prevention program can catch 100% of them. For your own safety, please:
Re-scan downloaded files using your personal virus checker before using it.
NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
Scan the source code with Minnow's Project Scanner
If you don't have a virus scanner, you can get one at many places on the net
including:McAfee.com
Terms of Agreement:
By using this code, you agree to the following terms...
You may use
this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
You may link to this code from another website, but ONLY if it is not wrapped in a frame.
You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.
A complete grid with database connection, done from scratch without any subclassing - folks, there is lot of work in it! My ***** for and thx for sharing!
Alas, plz increase the number of comments in code ;) and disable the blinking of the sliders (TabStop = False and another hidden control with tabindex = 0, e.g.).
Regards and plz keep the very good work up! LiTe
(If this comment was disrespectful, please report it.)
I haven't tried yet coz i lost my visual studio cd but looks great. Does it support multicolored rows? i mean alternating colors for rows. (If this comment was disrespectful, please report it.)
wow nicely done! (If this comment was disrespectful, please report it.)
1/14/2005 3:59:08 AM:
its a pretty control but its still far from the datagrid in options and configuration
the problem of MS datagrid is the events that are too messy they have tooo many bugs try to do same function in the datagrid that interacts with rowcolchange huge bug it freezzes your program but if you use a timer nothing hapends your control is very good dont put it dynamic thats roung choice let it be optional like datagrid than it whould stay alot better (If this comment was disrespectful, please report it.)
Thnx for support, I wasnt able to access psc for some time (isp problem maybe).
There are many things that I must add to totaly replace MS DataGrid, for now 1st place is implementation of built-in editors, property pages, more events etc.
Custom row colors will be added, but coloring rows will cause slowdown with more than 10000 records, that is why access is not an eye-candy :). Scrollbars are now added to queue of fixes. Events such as those fired when field changes can be implemented with declaration of your ADO object (recordset) or you can use adodc events. That will be added to grid as well.
I am working to replace that unnecessary "NewAdded" function, so grid will automaticaly detect when you insert record.
Version 2.0 will have all that MS DataGrid haves.
One day we will finaly have a perfect (non-crashing, super-stable) data aware grid.
(If this comment was disrespectful, please report it.)
Hello, this control looks very nice. I think there is a lot of hard work in it, so I will say thank you for share this useful control. (If this comment was disrespectful, please report it.)
very well done and well thought out, definitely not a small undertaking. 5 from me.
I do have one gripe - the comments about ado and microsoft. I get tired of people on psc bashing microsoft for one thing or another. Don't get me wrong I am often critical about some of their business decisions, but if it weren't for microsoft, we wouldn't have this wonderful programming tool and PSC probably never would have come about.
Read on if you dare, comment if you must, but this is just MHO and it will remain unchanged.
If they are are so shi77y then why bother using their stuff? You could just as easily do it in another language created by another company that uses different technology. ie. Powerbuilder's Data Windows is probably the best design time Grid - since it allows you to view data at design time. Not to mention PB has true OO priniciples that VB lacks. (If this comment was disrespectful, please report it.)
Reply for james kahl: As I said in the comment, money=good, what means products such as their c++, vb, office, win nt, etc. ARE GOOD, but not good as they should be (bugs, crashing, viruse-magnets).
Why do I use their products? I bow to the world globalisation and Microsoft economy domination. And dont worry about PSC, I am sure that it would exist with the same name whatever company is dominating the world software production.
Apex (or component-one today) corporation offers the leading and most popular DataGrid activex control in the world, Microsoft DataGrid as we know it dotay is actualy an old version Apex DataGrid created in far 1995. They sold compiled version of their Grid before so thay can be what are they now.
You as a standard Microsoft user (just as I am) should not bother yourself with this, I only wanted to say that ADO is not good :), use only the most necessary class functions such as Connect and Open ;).
Best regards, and thnx for comment! (If this comment was disrespectful, please report it.)
If you try to load more than 32767 records then you have to change all of the variables in mdlShellSort to long and get a new scroll bar. (If this comment was disrespectful, please report it.)
Add Your Feedback
Your feedback will be posted below and an email sent to
the author. Please remember that the author was kind enough to
share this with you, so any criticisms must be stated politely, or they
will be deleted. (For feedback not related to this particular code, please
click here instead.)
By 28 Users
Download code
1/13/2005 8:03:31 AM: 
