The Design of Software (CLOSED)

A public forum for discussing the design of software, from the user interface to the code architecture. Now closed.

The "Design of Software" discussion group has been merged with the main Joel on Software discussion group.

The archives will remain online indefinitely.

Looking for a Activexgrid control.

Looking for a Activexgrid control.
Does anyone have a suggestion for a good gird control?

I looking for something that will let me put a some squares on a  screen.

I NEED:
    Major/minor grid lines - just like a ruler – I want the “major” lines to be thicker (in my case every 4 grid lines to “outline” a hour break point).

    Ability to have a heading, but of course those headings should be able to be LARGER then a ONE grid cell, since the heading again is like the ruler, with Major/minor settings.

Here is a screen shot (I used tlist7 from bennet-tec – a consideration on my part as I have a licensed copy)) of what I am working towards. Note to make the “header”, I in fact used a ANOTHER copy of the grid control (and, am willing to do that – but, I still want something that allows a THICKER line on the grid for each hour division, and also a heading that is larger then one cell (as my example shows).

http://www.kallal.ca/tltest/index.htm

So, anyone have a suggestion of a good activeX grid control that they have used that will do the above?

Target environment is access 2003, but most activeX controls that work with VB6 should work with ms-access (those prototype screen shots are ms-access screens).

Albert D. Kallal
Edmonton, Alberta Canada
Kallal@ msn.com
http://www.members.shaw.ca/AlbertKallal
Albert D. Kallal Send private email
Monday, August 22, 2005
 
 
Pretty sure you can do that with Component One VSFlexGrid.
Wayne Bloss Send private email
Monday, August 22, 2005
 
 
+1 for FlexGrid. Lotta features, and top-notch support.
Fred
Monday, August 22, 2005
 
 
Thanks for the tip…I might give that control a try. I kind of don’t want to purchase another gird control (and, of course there is MSflexgrid, and a few others that come with several IDE’s that I have already).

I don’t know if that saying about “bending in the wind” came from the old Kung Fu TV series. However, bending with the wind here is likely the best approach! I don’t want to get TOOO worked about not having major grid lines. The trick in any development process is to be flexible, and not split hairs over a detail that will cost too much, or be more work then the results.

If I want things EXACTLY the way I want, then I going to have to write my own control…but that just is not worth my time in this case!. So, like the young kung fu person…I will bend like a willow tree!

Purchasing a whole new grid control so I can highlight the starting hours in the grid like graph paper might be just too much (I am still open to ideas).

However, I think I’ll just stick with tlist7 (I like that Bennett Tec control a lot). I added a 3rd screen shot where I use a gradient color shading in place of a thicker grid line (A idea I just came up with!!). I think that idea will do the trick for me.

(here is the screen shots with the 3rd plate added again):

http://www.kallal.ca/tltest/index.htm

I am still open grid control suggestions…but I think I can live with what I got…

Albert D. Kallal
Edmonton, Alberta Canada
Kallal@ msn.com
http://www.members.shaw.ca/AlbertKallal
Albert D. Kallal Send private email
Monday, August 22, 2005
 
 
You might also want to look at Infragistics ScheduleX controls.
Wayne Bloss Send private email
Monday, August 22, 2005
 
 
Hi Albert,

Had you considered using Office Web Components (OWC)? I’ve used the spreadsheet control in both Access and Excel (form) projects. This was done in corporate environments where IT policy restricts what components can be installed on a users system. The spreadsheet control also provides a lot of flexibility in formatting of the cells as well as the context.
Marcus from Melbourne
Monday, August 22, 2005
 
 
You should check out SharpGrid from Data Dynamics. This sounds like something you could do with the 'Styles' collection. Send me an email if you'd like and I'll send you a sample.
Lucas Hardbarger Send private email
Tuesday, August 23, 2005
 
 
> I kind of don’t want to purchase another gird control (and, of course there is MSflexgrid, and a few others that come with several IDE’s that I have already).

MSFlexGrid has much less features than eg. FlexGrid, hence the numerous commercial alternatives on the market.

>I am still open grid control suggestions…but I think I can live with what I got…

I doubt you'll find an open-source grid widget that really works well and has the features you're looking for. If you don't find one, I'm interested :-)
Fred
Tuesday, August 23, 2005
 
 
For a time recording and diarising system I ended up crafting my own box grid control an arrangement of containers that I could throw any control in and let the regular form refresh take care of the details.  Any of the grids, including the natives had far too many issues to cope with the rapid changing of data and a none regular number of squares, since the number of days in a month varies.  An alternative would have been a spreadsheet control but that was far too heavy in resources and again raised as many issues as it solved.

That was in VFP not any kind of VB and so the object model helped a great deal in getting it right but I imagine you could do something similar in VB.
Simon Lucy Send private email
Tuesday, August 23, 2005
 
 
I thought that the MSFlexgrid control in VB6 *IS* the Component One VSFlexGrid. It was bundled.
Ace
Tuesday, August 23, 2005
 
 
Simon..I have considred making my own...but too much work...

Thanks for the input guys.

I did look at sharpgird. They should have more screen shots IMHO. I don’t see it as having much more then the tlist7 control I am using. (might be better in terms of data binding..but I don’t need that in this case). If you are wondering, here is some tlist7 screen shots from the vendor

http://www.bennet-tec.com/btproducts/tlist/TListScreenShots.htm

So, to anyone that is selling grid controls….you need some nice screen shots….end of story. I got to look at this stuff quite fast…and then move on….

The only issues with tlist7 is that I could not have major/minor grid rules like most graph paper has. However, tlist7 (thankfully) supports gradient shading for cells, and so I used that in place of a thicker grid line. And, like most good grid controls, you CAN specify properties for a whole row or column at once. The 4th screen shot shows my gradient shade that I used (it is hardly noticalbe..but makes a nice break at each hour interval).

http://www.kallal.ca/tltest/index.htm

The other issue with tlist7 was I changed how selection works with tlist7 (it wants me to hold down the shift key while selecting a bunch of blocks, but I wanted to just hold down the left mouse key and drag to select like  you do in Excel, or msflexgrid). However, adding some code to the “cells” on activate event solved that problem also.

>I doubt you'll find an open-source grid widget that really works well and has the features you're looking for. If you don't find one, I'm interested :-)

Actually, there a very nice collection of grids and free controls for VB here (with full source code by the way):

http://vbaccelerator.com/home/VB/Code/Controls/index.asp

The above stuff is quite nice....

So, at this point, I can well work with tlist7, but if someone had pointed out a better grid control with more features for time scheduling (and major/minor grids), then I would be willing to open my wallet. And, to be fair, tlist7 is a also a nice tree view substitute, and also a list view substitute. So, it got lots of different views and display types, and thus the control is a real winner in that respect (makes it good value too, as it can be used in just about any project).

I suspect that a grid control made JUST for time scheduling might be better here, but this ship has to sail, and I got to move things forward!

Tlist7 is good, very good, but I was open to suggestions. 

As mentioned, I’ll be ok on this one…

Albert D. Kallal
Edmonton, Alberta Canada
Kallal@ msn.com
http://www.members.shaw.ca/AlbertKallal
Albert D. Kallal Send private email
Tuesday, August 23, 2005
 
 
And, in fairness to sharpgrid…they do have zillion nice screen shots…I just missed them…

Here they are!
http://www.datadynamics.com/Products/ProductFeatures.aspx?Product=SG
Albert D. Kallal Send private email
Tuesday, August 23, 2005
 
 
"I suspect that a grid control made JUST for time scheduling might be better here"

Here are the screenshots for Infragistics ScheduleX, but it's  $495.00 for the whole suite (NetAdvantage) that you have to buy to get it, I believe.

http://www.infragistics.com/Products/Gallery/Default.aspx?Product=NetAdvantage&Platform=COM_ActiveX&Element=UltraSchedule&ID=1
Wayne Bloss Send private email
Tuesday, August 23, 2005
 
 
Please check the Janus GridEx, it's and excelent product, very clean and complete.

They made some schedule controls aswell

http://www.janusys.com/controls/
Eduardo
Thursday, September 01, 2005
 
 

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics
 
Powered by FogBugz