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