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