How to Create a Windows Service Queries SQL Database and Send Parameters to a Client Web Service.

Question

Has anyone ever created a windows service in C#.NET which would run every 30 to 60 minutes with the following parameters:

1. Query SQL Database in own environement,

2. Pass results from SQL query to client Web Service in another environment.

It sounds very basic but I am new to Windows and Web Services.

If anyone has any example code for download or an article on such a configuration, I would appreciate any advice.

Thanks,

Always Learning

Answer 1

hi,

this is quite easy, use this code fomr the site to generate a general service using a timer object and place your appropiate actions in the timer event.

http://www.codeproject.com/dotnet/simplewindowsservice.asp

HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---

Answer 2

Thank you for the response. I have actually already reviewed this article and it does as address the basics of creating a windows service and how to have it run based on a specified period of time. However, the learning curve that I am looking for is how to run a query on SQL server in your own environment to produce a dataset of results based on specified parameters and send those results to a specified external web service.

The majority of my experience is in ASP.NET(C#) and ADO.NET. I do not have much experience with web services.

Your thoughts are greatly appreciated. I catch on real quick but I need an example with supporting documentation if that is possible.

 

Thanks.

Answer 3

Still problems with the rampup of the Windows Service ?

Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---

Answer 4

did you ever figure this out.  I am trying to do the exact same thing and found your thread. I know its been a few years but if you have the code to your solution, it would probably help me.  I am new to programming as well.

Thank you for your help

Answer 5

That was five years ago. The Microsoft platform has changed radically in five years. Even if the OP had the code, it wouldn't be code you'd want to use five years later.

---

John Saunders
WCF is Web Services. They are not two separate things.
Use WCF for All New Web Service Development, instead of legacy ASMX or obsolete WSE
Use File->New Project to create Web Service Projects