Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Hierarchy grid
Message
From
08/11/2003 11:10:12
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
07/11/2003 16:13:33
General information
Forum:
Visual FoxPro
Category:
ActiveX controls in VFP
Title:
Miscellaneous
Thread ID:
00847806
Message ID:
00847942
Views:
23
>Has somebody had any luck with FlexGrid?
>If yes, can I populate it from XML file?
>
>Thanks, Mark

Mark,
FWIW always use Hflexgrid not Flexgrid.
#define XMLFile 'myXML.xml'
Local oRecordSet As ADODB.Recordset
Local oConn As ADODB.Connection

strCn =	"Provider = MSDAOSP; Data Source=MSXML2.DSOControl.2.6;"

oRecordSet = Createobject("adodb.recordset")
oConnection = Createobject("adodb.connection")

With oConnection
  .Provider = "MSDataShape"
  .ConnectionString = strCn
  .Open
Endwith

oRecordSet.Open(XMLFile,oConnection)
ShowMe('Contents',oRecordSet)

Function ShowMe
Lparameters tcCaption,toRecordset
oForm = Createobject('myForm', tcCaption,toRecordset)
oForm.Show
Read Events
Endfunc

Define Class myform As Form
  Height = 450
  Width = 750
  Name = "Form1"

  Add Object hflex As OleControl With ;
    Top = 10, Left = 10, Height = 430, Width = 730, Name = "Hflex", ;
    OleClass = 'MSHierarchicalFlexGridLib.MSHFlexGrid'

  Procedure Init
  Lparameters tcCaption,toRecordset
  This.Caption = tcCaption
  This.hflex.Datasource = toRecordset
  This.hflex.CollapseAll
Endproc
  Procedure QueryUnload
  Clear Events
Endproc
Enddefine
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform