C#

[System.Runtime.InteropServices.DllImport("kernel32.dll")]
private static extern bool AllocConsole(); 

private void button1_Click(object sender, EventArgs e)
{
    AllocConsole();

    MessageBox.Show(ConsoleWriteAndReadLine(new string[]{"arg 1","arg 2","arg 3"}));
}

private string ConsoleWriteAndReadLine(string[] values)
{
    Console.WriteLine("Command line = {0}", Environment.CommandLine);

    for (int i = 0; i < values.Length; i++)
    {
        Console.WriteLine("argument{0} = {1}", i + 1, values[i]);
    }

    Console.Write("? ");

    return Console.ReadLine(); 
}

// Start the child process.
 Process p = new Process();
 // Redirect the output stream of the child process.
 p.StartInfo.UseShellExecute = false;
 p.StartInfo.RedirectStandardOutput = true;
 p.StartInfo.FileName = "Write500Lines.exe";
 p.Start();
 // Do not wait for the child process to exit before
 // reading to the end of its redirected stream.
 // p.WaitForExit();
 // Read the output stream first and then wait.
 string output = p.StandardOutput.ReadToEnd();
 p.WaitForExit();

using (var process = new Process())
            {

                process.StartInfo.UseShellExecute = false;
                process.StartInfo.CreateNoWindow = true;
                process.StartInfo.RedirectStandardError = true;
                process.StartInfo.RedirectStandardOutput = true;
                process.StartInfo.FileName = "Codegen.exe";
                process.StartInfo.Arguments = open.FileName + " 10 30";

                process.Start();

                //Thread.Sleep(100);

                using (Task processWaiter = Task.Factory.StartNew(() => process.WaitForExit()))
                using (Task<string> outputReader = Task.Factory.StartNew(() => process.StandardOutput.ReadToEnd()))
                using (Task<string> errorReader = Task.Factory.StartNew(() => process.StandardError.ReadToEnd()))
                {
                    Task.WaitAll(processWaiter, outputReader, errorReader);

                    standardOutput = outputReader.Result;
                    standardError = errorReader.Result;
                }

StringBuilder returnValue = new StringBuilder();

Process P = new Process();
p.StartInfo.UseShellExecute = false;
p.StartInfo.CreateNoWindow = true;
p.StartInfo.RedirectStandardError = true;
p.StartInfo.RedirectStandardOutput = true;
p.StartInfo.FileName = "Codegen.exe";
p.StartInfo.Arguments = open.FileName + " 10 30";
 
p.Start();

p.OutputDataReceived += (o, e) =>
{
  if (e.Data != null)
   returnValue.AppendLine(e.Data);
};

p.ErrorDataReceived += (o, e) =>
{
  if (e.Data != null)
   returnValue.AppendLine(e.Data);
};

p.Start();
p.BeginOutputReadLine();
p.BeginErrorReadLine();

p.WaitForExit();
p.Close();
p.Dispose();

if (returnValue.Length > 0)
{
  standardOutput  = returnValue.ToString();
} 

p.OutputDataReceived += (o, e) =>
{
  if (e.Data != null)
   returnValue.AppendLine(e.Data);
};

sortProcess.OutputDataReceived += new DataReceivedEventHandler(SortOutputHandler);

private static void SortOutputHandler(object sendingProcess, 
            DataReceivedEventArgs outLine)
        {
            //do something with outline.Data
            
        }

Keshav Shivhare wrote:

// Perform copy.

private void btnupload_Click(object sender, EventArgs e)
      {

          foreach (DataGridViewRow row in dataGridView1.Rows)
          {
              if (row.Cells[5].Value!=null)
              {
                  if ((Boolean)row.Cells[5].Value == true)
                  {
                      con = new SqlConnection("Data Source=(local);Initial Catalog=vediocon;Integrated Security=True");

                      con.Open();

                      string s = "insert into Temptransaction (date,dealercode,amounttranfer,actualamount,transactioncode)values'" + row.Cells[1].ToString() + "','" + row.Cells[2].ToString() + "','" + row.Cells[3].ToString() + "','" + row.Cells[4].ToString() + "','" + row.Cells[5].ToString() + "'";
                      cmd = new SqlCommand(s, con);

                     cmd.ExecuteNonQuery();

                      DataTable dt = new DataTable();

string s = "insert into Temptransaction (date,dealercode,amounttranfer,actualamount,transactioncode)values'" + row.Cells[1].ToString() + "','" + row.Cells[2].ToString() + "','" + row.Cells[3].ToString() + "','" + row.Cells[4].ToString() + "','" + row.Cells[5].ToString() + "'";
                      cmd = new SqlCommand(s, con);

string s = "insert into Temptransaction (date,dealercode,amounttranfer,actualamount,transactioncode)  values ('" + row.Cells[1].ToString() + "','" + row.Cells[2].ToString() + "','" + row.Cells[3].ToString() + "','" + row.Cells[4].ToString() + "','" + row.Cells[5].ToString() + "')";
                     cmd = new SqlCommand(s, con);

using (SqlConnection con = new SqlConnection("Data Source=(local);Initial Catalog=vediocon;Integrated Security=True"))
using (SqlCommand cmd = new SqlCommand("insert into Temptransaction (date, dealercode, amounttranfer, actualamount, transactioncode) values (@date, @dealercode, @amounttranfer, @actualamount, @transactioncode)", con))
{
    cmd.Parameters.AddWithValue("@date", row.Cells[1]);
    cmd.Parameters.AddWithValue("@dealercode", row.Cells[2]);
    cmd.Parameters.AddWithValue("@amounttranfer", row.Cells[3]);
    cmd.Parameters.AddWithValue("@actualamount", row.Cells[4]);
    cmd.Parameters.AddWithValue("@transactioncode", row.Cells[5]);

    con.Open();
    cmd.ExecuteNonQuery();
}