C#

Process[] processList = Process.GetProcessesByName("proccessName");

MessageBox.Show("Killing processes...");
try {
  foreach (Process process in processList) {
    process.Kill();
    process.WaitForExit();
  }

  MessageBox.Show("Processes killed successfully.");

}
catch (Exception exception){
  // Log exception here
  MessageBox.Show("Could not kill on of the processes.");
}

Garth J Lancaster wrote:

until you do that, and we cant do it for you

<br />
SqlCommand.Parameters.Add( [param1] )<br />
SqlCommand.Parameters.Add( [param2] )<br />
SqlCommand.Execute...<br />

<br />
SqlCommand.Parameters.Add( [param1] )<br />
SqlCommand.Parameters.Add( [param2] )<br />
SqlCommand.Parameters.Add( [param3] )<br />
SqlCommand.Execute...<br />

public int Foo(param1, param2)
{
  return Bar(param1, param2, null);
}

public int Bar(param1, param2, param3)
{
   return db.Execut(...);
}

public SqlCommand CreateProc(string procName, ReadOnlyCollection<DbParameter> parameters)
{
SqlCommand cmd = new SqlCommand(procName, SqlConnection);
cmd.CommandType = CommandType.StoredProcedure;

if(parameters != null)
{
    foreach(DbParameter param in parameters)
    {
        cmd.Parameters.Add(param);
    }
}

return cmd;
}