private void button12_Click(object sender, EventArgs e)
{
#region oracle数据库备份
System.Diagnostics.Process pro = new System.Diagnostics.Process();
pro.StartInfo.FileName = "cmd.exe ";
pro.StartInfo.WindowStyle = System.Diagnostics.ProcessWindowStyle.Normal;
pro.StartInfo.CreateNoWindow = true;
pro.StartInfo.UseShellExecute = false;
pro.StartInfo.RedirectStandardInput = true;
pro.StartInfo.RedirectStandardOutput = true;
pro.Start();
//pro.StandardInput.WriteLine("exp lc1002/cccccc@orcl file=lc100220101113.dmp owner=lc1002");
pro.StandardInput.WriteLine("exp " + textBox2.Text + "/" + textBox3.Text + "@" + textBox1.Text + " file=" + textBox4.Text + textBox2.Text + ".dmp" + " owner=" + textBox2.Text);
pro.StandardInput.WriteLine("exit");
string outPut = pro.StandardOutput.ReadToEnd();
this.textBox4.Text = outPut; MessageBox.Show("ORACLE数据库备份完成!", "提示"); #endregion
}运行后可以成功备份数据,但是textBox4只显示运行cmd.exe和exit了。没有显示平时在DOS下执行exp.exe时在屏幕上输出的详细内容,像导出的表名,导出了多少行等等。请各位老师帮忙看看,谢谢!
{
#region oracle数据库备份
System.Diagnostics.Process pro = new System.Diagnostics.Process();
pro.StartInfo.FileName = "cmd.exe ";
pro.StartInfo.WindowStyle = System.Diagnostics.ProcessWindowStyle.Normal;
pro.StartInfo.CreateNoWindow = true;
pro.StartInfo.UseShellExecute = false;
pro.StartInfo.RedirectStandardInput = true;
pro.StartInfo.RedirectStandardOutput = true;
pro.Start();
//pro.StandardInput.WriteLine("exp lc1002/cccccc@orcl file=lc100220101113.dmp owner=lc1002");
pro.StandardInput.WriteLine("exp " + textBox2.Text + "/" + textBox3.Text + "@" + textBox1.Text + " file=" + textBox4.Text + textBox2.Text + ".dmp" + " owner=" + textBox2.Text);
pro.StandardInput.WriteLine("exit");
string outPut = pro.StandardOutput.ReadToEnd();
this.textBox4.Text = outPut; MessageBox.Show("ORACLE数据库备份完成!", "提示"); #endregion
}运行后可以成功备份数据,但是textBox4只显示运行cmd.exe和exit了。没有显示平时在DOS下执行exp.exe时在屏幕上输出的详细内容,像导出的表名,导出了多少行等等。请各位老师帮忙看看,谢谢!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货