So today I was at client's site providing Technical Support and finalizing Enhancement Project that was done for the past few months. One of the task was for me to develop a Windows Service, which will grab the user's updated profile from a table in SQL Server 2000 and submit them to a Web Service developed by another vendor. I am using SOAP in my Windows Service to communicate with the Web Service on the other side. Since SOAP is using an XML format in their request and response, I had to grab the data from the SQL Server and build a SOAP Request XML before sending it to the Web Service.