how to use windows services in win form appliction

Question

2.33/5 (2 votes)

See more:

Dear all
i want to know how to create windows services for backup of sql server database and how to use this service to my win form application .

Thanks in Advance

Posted 8-May-13 20:44pm

priya3456

Add a Solution

4 solutions

Solution 2

A service is a service. It does something.
If you put an IPC interface in it you can communicate with it from an application. I suppose you want to add the missing Server Agent feature of SQL Server Express.
For doing the backup itself I suggest you use SMO Backup class[^].
For the IPC you can use WCF, named pipes, MSMQ, or even plain TCP. But if you want to send only a simple message, like "do backup", this one can be also a solution: http://arcanecode.com/2007/05/30/windows-services-in-c-sending-commands-to-your-windows-service-part-7/[^]

Posted 8-May-13 22:31pm

Zoltán Zörgő

Solution 3

check this link

windows service in visual studio[^]

Posted 9-May-13 0:23am

josh-jw

Solution 4

There is an article for that!!!
stop asking questions what already are articles!!!

Posted 9-May-13 8:21am

Radoslav Dimitrov

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

G.Tarun Kumar · Accepted Answer · 2013-05-08T21:21:00

With the below code you will be able to access your local service from a win form.

C#

// ADD "using System.ServiceProcess;" after you add the 
// Reference to the System.ServiceProcess in the solution Explorer
using System.ServiceProcess;

ServiceController myService = new ServiceController();    
myService.ServiceName = "ImapiService";

string svcStatus = myService.Status.ToString();

if (svcStatus == "Running")
{
    myService.Stop();
}
else if(svcStatus == "Stopped")
{
    myService.Start();
}
else
{
    myService.Stop();
}

This article may help you to take a backup of sql database with C# code.

How create Backup and Restore database in c# window application[^]

Write code to backup the database in service.

Happy Coding.

[Edit]Code block added[/Edit]