Re: how to use windows service in another project? [modified] - C# Discussion Boards

29-Jun-09 1:27

Hi Experts,

i created a windows service to insert data in to a sql table.
now i want to call this windows service in another project how can i call this?

i tried to add service reference but it is asking for url
how can i give this?
like webservices, is windows services also contain URL?

please help me out

Thanks In Advance
--Naren

himanshu256129-Jun-09 1:50

29-Jun-09 1:50

Hi,

You can install the window service.It is not like webservices so it does not have any url..

Please read some stuff on google about window services.

himanshu

Narendra Reddy Vajrala29-Jun-09 2:03

Re: how to use windows service in another project? [modified]

29-Jun-09 2:03

Hi Himanshu,

i installed my service, it is fine am performing start, stop, restart operations.
but am stuck with calling this windows service in another project. Frown | :(

i tried in google but i did not find any information reagrding this to call a windows service in another project.

himanshu256129-Jun-09 2:13

Re: how to use windows service in another project? [modified]

29-Jun-09 2:13

Hi You can not call window service in any project because it is not like class library.
I am not getting what are you doing with window service. Please explain what is is currently doing and what are you planning to do?

himanshu

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

Narendra Reddy Vajrala29-Jun-09 2:27

29-Jun-09 2:27

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();<br />
            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

<br />
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<br />

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

himanshu256129-Jun-09 2:36

29-Jun-09 2:36

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 Smile | :)

himanshu

Narendra Reddy Vajrala29-Jun-09 2:52

29-Jun-09 2:52

am giving my code sample

<br />
protected override void OnStart(string[] args)<br />
        {<br />
            insertValues(3, "Naresh Kumar", "3658213641", "Begumpet Hyderabad");<br />
        }<br />
<br />
 public void insertValues(int custId, string custName, string custPhone, string custAdd)<br />
        {<br />
            string insertCommand = "Insert into CUSTOMER values ( " + custId + ",'" + custName + "','" + custPhone + "','" + custAdd + "')";<br />
            con.Open();<br />
            cmd = new SqlCommand(insertCommand, con);<br />
            cmd.ExecuteNonQuery();<br />
            con.Close();<br />
        }<br />

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.

himanshu256129-Jun-09 3:04

29-Jun-09 3:04

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 Vajrala29-Jun-09 3:11

29-Jun-09 3:11

same error
no change Frown | :(

even i used try catch block.

himanshu256129-Jun-09 3:15

29-Jun-09 3:15

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

himanshu256129-Jun-09 2:47

29-Jun-09 2:47

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 Vajrala29-Jun-09 2:53

29-Jun-09 2:53

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

J4amieC29-Jun-09 3:00

29-Jun-09 3:00

Narendra Reddy Vajrala wrote:
actually but i have to do in windows services only

why? Says who?

Narendra Reddy Vajrala29-Jun-09 3:05

29-Jun-09 3:05

i cant break my PL orders Frown | :(

himanshu256129-Jun-09 3:09

29-Jun-09 3:09

who make him PL Confused | :confused:

.
Use web service..

himanshu

J4amieC29-Jun-09 4:21

29-Jun-09 4:21

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

Vikram A Punathambekar29-Jun-09 5:35

Vikram A Punathambekar

29-Jun-09 5:35

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.

J4amieC29-Jun-09 5:46

29-Jun-09 5:46

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.

can you please check this code?

Vikram A Punathambekar29-Jun-09 3:07

Vikram A Punathambekar

29-Jun-09 3:07

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.

Narendra Reddy Vajrala29-Jun-09 3:14

Re: can you please check this code?

29-Jun-09 3:14

my code is like this in windows services class

<br />
protected override void OnStart(string[] args)<br />
{<br />
insertValues(3, "Naresh Kumar", "3658213641", "Begumpet, Hyderabad");<br />
}<br />
<br />
public void insertValues(int custId, string custName, string custPhone, string custAdd)<br />
{<br />
string insertCommand = "Insert into CUSTOMER values ( " + custId + ",'" + custName + "','" + custPhone + "','" + custAdd + "')";<br />
con.Open();<br />
cmd = new SqlCommand(insertCommand, con);<br />
cmd.ExecuteNonQuery();<br />
con.Close();<br />
}<br />

J4amieC29-Jun-09 4:20