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.comwww.prenia.comWeblog: blogs.prenia.com/cathi