Re: Please check this code - C# Discussion Boards

how to use windows service in another project?

Narendra Reddy Vajrala29-Jun-09 1:27

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

Re: how to use windows service in another project?

himanshu256129-Jun-09 1:50

himanshu2561

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

Re: how to use windows service in another project?

Narendra Reddy Vajrala29-Jun-09 2:03

Narendra Reddy Vajrala

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.

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

himanshu256129-Jun-09 2:13

himanshu2561

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

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

Narendra Reddy Vajrala29-Jun-09 2:27

Narendra Reddy Vajrala

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

Re: how to use windows service in another project?

himanshu256129-Jun-09 2:36

himanshu2561

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

Re: Please check this code

Narendra Reddy Vajrala29-Jun-09 2:52

Narendra Reddy Vajrala

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.

Re: Please check this code

himanshu256129-Jun-09 3:04

himanshu2561

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

Re: Please check this code

Narendra Reddy Vajrala29-Jun-09 3:11

Narendra Reddy Vajrala

29-Jun-09 3:11

same error
no change Frown | :(

even i used try catch block.

Re: Please check this code

himanshu256129-Jun-09 3:15

himanshu2561

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

Re: how to use windows service in another project?

himanshu256129-Jun-09 2:47

himanshu2561

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

Re: how to use windows service in another project?

Narendra Reddy Vajrala29-Jun-09 2:53

Narendra Reddy Vajrala

29-Jun-09 2:53

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

Re: how to use windows service in another project?

J4amieC29-Jun-09 3:00

J4amieC

29-Jun-09 3:00

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

why? Says who?

Re: how to use windows service in another project?

Narendra Reddy Vajrala29-Jun-09 3:05

Narendra Reddy Vajrala

29-Jun-09 3:05

i cant break my PL orders Frown | :(

Re: how to use windows service in another project?

himanshu256129-Jun-09 3:09

himanshu2561

29-Jun-09 3:09

who make him PL Confused | :confused:

.
Use web service..

himanshu

Re: how to use windows service in another project?

J4amieC29-Jun-09 4:21

J4amieC

29-Jun-09 4:21

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

Re: how to use windows service in another project?

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.

Re: how to use windows service in another project?

J4amieC29-Jun-09 5:46

J4amieC

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.

Re: how to use windows service in another project?

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.

can you please check this code?

Narendra Reddy Vajrala29-Jun-09 3:14

Narendra Reddy Vajrala

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

Re: can you please check this code?

J4amieC29-Jun-09 4:20

J4amieC

29-Jun-09 4:20

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.

creating excel workbooks from a given template in a particular folder

Krishna Aditya29-Jun-09 1:07

Krishna Aditya

29-Jun-09 1:07

Hi,

I have a template in location " c:\excel_temp\template1.xls". This template is a user defined template.

I have to use this template in a browsed location. ( if user selects "d:\temp\" folder, then I have to import the template in " c:\excel_temp" to "d:\temp" folder).

I am trying this with C#. i have done somepart of it

                        string tempPath =   @"D:\Documents and Settings\eob\Desktop\Testing";

                        //System.IO.Directory.CreateDirectory(@tempPath + launchName);

                        //check path exists
                        if (!System.IO.Directory.Exists(@tempPath + launchName))
                        {
                              System.IO.Directory.CreateDirectory(@tempPath + launchName);
                        }

                        System.IO.DirectoryInfo dir = new System.IO.DirectoryInfo(@tempPath + launchName);
                        int directoryCount = dir.GetFiles().Length;

                        if (directoryCount != 0)
                        {
                              FileInfo[] fileNames = dir.GetFiles(@tempPath + launchName);
                        }

                        Excel.Application excelFile = new Excel.ApplicationClass();

Now with the excelFile created above, I have to access the template and create an excel file same as the template in the above folder.

I am stuck at this point, pls guide me

Thanks
Ramm

Re: creating excel workbooks from a given template in a particular folder [modified]

padmanabhan N29-Jun-09 1:31

padmanabhan N

29-Jun-09 1:31

Krishna Aditya wrote:
I have a template in location " c:\excel_temp\template1.xls". This template is a user defined template.

I have to use this template in a browsed location. ( if user selects "d:\temp\" folder, then I have to import the template in " c:\excel_temp" to "d:\temp" folder).

for this you can use:
string source = "c:\excel_temp\template1.xls";
string Destination = "d:\temp\Temp.xls";
if (File.Exists(Destination))
{
File.Copy(source, Destination, true);
}

//refer : Word automation (Part 1)[^]

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

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

Datagridview Column Header ReadOnly

rhtbhegade28-Jun-09 21:43

rhtbhegade

28-Jun-09 21:43

Hello Experts
I want to make my columnheader Readonly of my datagrid...

Re: Datagridview Column Header ReadOnly

stancrm28-Jun-09 21:52

stancrm

28-Jun-09 21:52

what do you want with columnheader readonly ?
do you mean "not clickable and not sortable" ?

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.