///<summary>
 ///executes a system command from inside csharp
 ///</summary>
 ///<param name="cmd">a dos type command like "isql ..."</param>
 
 ///<param name ="millsecTimeOut">how long to wait on the command</param>
 
 public static int executeCommand(string cmd, int millsecTimeOut) {
    System.Diagnostics.ProcessStartInfo processStartInfo =
       new System.Diagnostics.ProcessStartInfo("CMD.exe", "/C "+cmd);
    processStartInfo.CreateNoWindow = true;
    processStartInfo.UseShellExecute = false;
    System.Diagnostics.Process process =
       System.Diagnostics.Process.Start(processStartInfo);
    process.WaitForExit(millsecTimeOut); //wait for 20 sec
    int exitCode = process.ExitCode;
    process.Close();
    return exitCode;
 }