Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Any easy way to create an XML table
Message
General information
Forum:
ASP.NET
Category:
Other
Miscellaneous
Thread ID:
00709062
Message ID:
00709871
Views:
17
Hi Joe,

If you use the Visual FoxPro Toolkit for .NET, you can use the CursorToXml function, similar to how you call it in VFP. Just pass in a DataSet object and the name of the file you want to write to.
CursorToXML(ds, "c:\MyDataSet.xml")
>>Hi,
>>
>>I need to create an XML Table from a Windows Form using an SQL table as the source.
>>
>>Know very little about XML.
>>
>>SELECT ClientNum, LastName, FirstName, SignificantOther, Address, City, State, ZipCode, AddressAfterClose, CityAfterClose, StateAfterClose, ZipAfterClose, HomePhone, WorkPhone, WorkPhoneExt, CellPhone, FaxNumber, EmailAddress, Comments, InsertDateTime FROM dbo.Client WHERE (LastName LIKE ?)
>>
>>How would I create the XML table with the result rows?
>>
>>Thanks
>>Roland
>
>I tried to hold back but... In VFP7 cursortoxml(lcName, lcRowName, lnIndent, llNoHeader) and its done.
-----------------------------------------

Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.com
www.prenia.com
Weblog: blogs.prenia.com/cathi
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform