How to run specific command in Command prompt using C#

Question

5.00/5 (2 votes)

See more:

I want to restart Sql server from command prompt using these following command:

NET STOP MSSQL$SQLExpress
NET START MSSQL$SQLExpress

I have found these following code which start cmd process. But i have no idea how to run above command on command prompt using c#

C#

Process p = new Process();
ProcessStartInfo psi = new ProcessStartInfo();
psi.FileName = Application.StartupPath.Trim() + @"\command\cmd.exe";
psi.Arguments = "NET STOP MSSQL$SQLExpress";
p.StartInfo = psi;
p.Start();

please help me to restart SQL server.
Thanks in advance

Posted 10-Jan-12 23:28pm

sahabiswarup

Updated 10-Jan-12 23:47pm

Mehdi Gholam

v3

Add a Solution

Comments

Shahin Khorshidnia 11-Jan-12 5:47am

Good question.

2 solutions

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)

Amir Mahfoozi · Accepted Answer · 2012-01-11T01:43:00

When there are some classes to do this why you are using command prompt ?

C#

public static void RestartService(string serviceName, int timeoutMilliseconds)
{
  ServiceController service = new ServiceController(serviceName);
  try
  {
    int millisec1 = Environment.TickCount;
    TimeSpan timeout = TimeSpan.FromMilliseconds(timeoutMilliseconds);

    service.Stop();
    service.WaitForStatus(ServiceControllerStatus.Stopped, timeout);

    // count the rest of the timeout
    int millisec2 = Environment.TickCount;
    timeout = TimeSpan.FromMilliseconds(timeoutMilliseconds - (millisec2-millisec1));

    service.Start();
    service.WaitForStatus(ServiceControllerStatus.Running, timeout);
  }
  catch
  {
    // ...
  }
}

extracted from here :
http://www.csharp-examples.net/restart-windows-service/[^]

To know the name of the SQL Server service go to control panel or see the output of this command :

sc query | more

koolprasad2003 · Accepted Answer · 2012-01-10T23:31:00

Solution 1

C#

Process.Start("NET STOP MSSQL$SQLExpress");

Posted 10-Jan-12 23:31pm

koolprasad2003

Comments

sahabiswarup 11-Jan-12 5:34am

no need to mention other parameter?

Andreas Gieriet 12-Jan-12 15:05pm

Usually this is sufficient.

The only problem: the net command returns before the stop got fully completed. So, if you immediately try to e.g. delete the DB files, you might fail with an access violation. Adding an arbitrary delay does only reduce the risk that this happens. The more reliable way in connection with services start/stop is to do it over the ServiceController class and wait there until the service reports that it is stopped.

The code must be a bit sophisticated, e.g. pseudo-code for stopping the service:


if (!stopped)
{
   if (!stopping)
   {
       stop()
   }
   wait-for-stopped
}