how to use windows service in another project?

[Narendra Reddy Vajrala]

what am trying to do is i want to insert records into a sqlTable for that i created a method with 4 arguments in windows services class. inside that method i wrote code to insert those 4 arguments. i installed this windows service. from another project i want to call this method To insert records from a form i called that service like this WindowsService1.Service1 winService = new WindowsService1.Service1(); winService.insertValues(txtcustId.Text, txtcustName.Text, txtcustPhone.Text, txtcustAddress.Text); here insertValues is my method inside windows service, where i wrote insert statement. is this correct way? when i tried to build it is giving below error Error 2 The type 'System.ServiceProcess.ServiceBase' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.ServiceProcess, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'. C:\Inetpub\wwwroot\WindowsFormsApplication1\WindowsFormsApplication1\Form1.cs 451 13 WindowsFormsApplication1

modified on Monday, June 29, 2009 8:37 AM

[himanshu2561]

Hi, Stop your service from services.msc and check weather you are still able to insert records into your sql table. Just check it and you will find your answer :)

himanshu

[himanshu2561]

Hi if you want to achieve this type of functionality than i suggest you to consider webservice.Using window service you will not achieve this. Moreover,there is no point to keep busy your server by making window service.

himanshu

[Narendra Reddy Vajrala]

am giving my code sample protected override void OnStart(string[] args) { insertValues(3, "Naresh Kumar", "3658213641", "Begumpet Hyderabad"); } public void insertValues(int custId, string custName, string custPhone, string custAdd) { string insertCommand = "Insert into CUSTOMER values ( " + custId + ",'" + custName + "','" + custPhone + "','" + custAdd + "')"; con.Open(); cmd = new SqlCommand(insertCommand, con); cmd.ExecuteNonQuery(); con.Close(); } when am trying run this service from computer Mangement is it displaying below alert "The service on local machine started and stopped. some services stopped automatically if they have no work to do for example the performance logs and alerts service." please help me out.

[Narendra Reddy Vajrala]

ya actually but i have to do in windows services only. :(

[J4amieC]

Narendra Reddy Vajrala wrote:

actually but i have to do in windows services only

why? Says who?

[himanshu2561]

Narendra Reddy Vajrala wrote:

"The service on local machine started and stopped. some services stopped automatically if they have no work to do for example the performance logs and alerts service.

This error means there is some error in the code of your window service. You have not done any exception handling.Write Try/Catch block to catch the exception and log that error in event viewer or log file.

himanshu

[Narendra Reddy Vajrala]

i cant break my PL orders :(

[Vikram A Punathambekar]

You are confusing web services and Windows services. I suggest you buy a book.

Cheers, Vikram.

Recent activities: TV series: Friends, season 9 Books: Freakonomics, by Steven Levitt and Stephen J Dubner.

---

Carpe Diem.

[himanshu2561]

who make him PL :confused:. Use web service..

himanshu

[Narendra Reddy Vajrala]

same error no change :( even i used try catch block.

[Narendra Reddy Vajrala]

my code is like this in windows services class protected override void OnStart(string[] args) { insertValues(3, "Naresh Kumar", "3658213641", "Begumpet, Hyderabad"); } public void insertValues(int custId, string custName, string custPhone, string custAdd) { string insertCommand = "Insert into CUSTOMER values ( " + custId + ",'" + custName + "','" + custPhone + "','" + custAdd + "')"; con.Open(); cmd = new SqlCommand(insertCommand, con); cmd.ExecuteNonQuery(); con.Close(); } when am trying run this service from computer Mangement is it displaying below alert "The service on local machine started and stopped. some services stopped automatically if they have no work to do for example the performance logs and alerts service." please help me out

[himanshu2561]

Hi Have you log your error in log file or somewhere else... Read error from there and post it. Also, Do not use window service for this task.

himanshu

[J4amieC]

The reason it stopped automatically is because there is no further work for the service to do once the line insertValue(...) has run. In general, windows services' OnStart method starts a thread/timer which continues to process until interupted by a Pause or Stop command. Whatever a "PL" is, he is an idiot, or you have misunderstood his request.

[J4amieC]

What is a "PL" and what specifically are their/it's "orders"?

[Vikram A Punathambekar]

Project Lead, sounds like a cretin who's just been promoted into management by virtue of warming the seat for X years and is out to show his minions who's boss.

Cheers, Vikram.

Recent activities: TV series: Friends, season 9 Books: Freakonomics, by Steven Levitt and Stephen J Dubner.

---

Carpe Diem.

[J4amieC]

Ah ok, I guess we have PM's (Project Managers) but they don't get involved with how the thing is written, or Technical Lead's which do. Hence my confusion. Anyway, he might have a valid reason for wanting to send all database communication through a windows service (ie, single point of caching) but he's obviously not been specific enough on how to communicate with this service for his more junior team members.