Are you saying you want to generate an XML file from a SQL Select statement? Are you using a DataSet inside of your Windows Form now? If so, then you can output the DataSet directly to XML using the GetXml method or the WriteXml method.
>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
-----------------------------------------
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