Filling a MSHFlexGrid

Currently, I'm filling the MSHflexgrid on a cell by cell loop.  The reason that I have not used the DataSource property is because I have had nothing but greif trying to use the Data Environment.  I would like an alternate method to fill my flex grid very quick, without using the DataEnvironment and Datasource property.  Any suggestions?
TerryEllisAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Bob LearnedConnect With a Mentor Commented:
You can do a GetString on an ADO recordset, but the MSHFlexGrid does not have an easy method to put the data in the grid.

VideoSoft's vsFlexGrid has a Clip property that lets you do this, so I don't know if you were getting the two controls mixed up.
0
 
Bob LearnedCommented:
What is the reason for not using the DataEnvironment?  What kind of problems were you having?

What is the code you are using to fill the grid?

How many records does the grid need to handle?
0
 
TerryEllisAuthor Commented:
TheLearnedOne, I wish I could tell you why my friend is having so much difficulty with the Data Environement, that he has completly abandoned the tool.  All I can tell you is that he has no faith in using it.  I suggested using the getstring methode of his ado recordset object to fill the flexgrid.  But it eludes me as how to perform this possible solution. By the way, his recordset count is about 1500 records.  Any ideas?
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Bob LearnedCommented:
Is your friend using the TextMatrix property or the AddItem method?

The TextMatrix property is much more efficient then the AddItem.

I have abandoned all Micro$oft released grid controls for VideoSoft's vsFlexGrid.  VideoSoft is the company that created the MSFlexGrid and MSHFlexGrid.  vsFlexGrid is the definitive next step that is backwards compatible with the two Micro$oft controls.

Our company is now looking into the new version 7.0.  It is amazing what this control can do for you!
0
 
TerryEllisAuthor Commented:
TheLearnedOne,  My friend is using the TextMatrix property.  I have used a demo version of the vsFlexGrid in the past and liked it very much, I think it was version 6.0. I also think this was the version that allowed you to use getstring to fill the grid, I'm not sure.  I would like to give you the 200 points if you would post any answer, just for the excellent lead on version 7.0.

Thank You.
0
 
TerryEllisAuthor Commented:
TheLearnedOne, Thats it Thanks a million. Will the clip property work on the 7.0 version of the vsHFlexgrid?
0
 
Bob LearnedCommented:
Yes, they introduced it with 6.0, and it carries on to 7.0.
0
 
TerryEllisAuthor Commented:
Thank You.
0
 
MoondancerCommented:
This question was awarded, but never cleared due to the JSP-500 errors of that time.  It was "stuck" against userID -1 versus the intended expert whom you awarded.  This corrects the problem and the expert will now receive these points; points verified.

Please click on your Member Profile and select "View Question History" to navigate through any open or locked questions you may have to update and finalize them.  If you are an EE Pro user, you can also choose Power Search to find all your open questions.

This is the Community Support link, if help is needed.  Also a question is posted there specific to these changes that apply to the experts here.  Also, I am including the link to our All Topics, since many new ones have recently been added.

http://www.experts-exchange.com/jsp/qList.jsp?ta=commspt
http://www.experts-exchange.com/jsp/zonesAll.jsp
 
Thank you,
Moondancer
Moderator @ Experts Exchange
0
All Courses

From novice to tech pro — start learning today.