在.net执行sql脚本的简单实现

                            Process p = new Process();

                            p.StartInfo.FileName = "cmd.exe";

                            p.StartInfo.UseShellExecute = false;

                            p.StartInfo.RedirectStandardInput = true;

                            p.StartInfo.RedirectStandardOutput = true;

                            p.StartInfo.RedirectStandardError = true;

                            p.StartInfo.CreateNoWindow = true;

                            string strOutput = null;

                            try

                            {

                                     p.Start();

                                     p.StandardInput.WriteLine(commandText);

                                     p.StandardInput.WriteLine("exit");

                                     strOutput = p.StandardOutput.ReadToEnd();

                                     p.WaitForExit();

                                     p.Close();

                            }

                            catch(Exception e)

                            {

                                     strOutput = e.Message;

                            }

                            return strOutput;

上一页  [1] [2] [3]  下一页

Copyright ＠ 2007-2012 敏韬网(敏而好学，文韬武略--MinTao.Net)（学习笔记） Inc All Rights Reserved.
闵涛 E_mail:admin@mintao.net(欢迎提供学习资源)

鄂公网安备 42011102001154号

站长：MinTao ICP备案号：鄂ICP备11006601号-18