执行sql脚本

使用osql.exe执行sql脚本的两种方法
1

      string sqlQuery = "osql.exe /uSa /p123 /s192.192.132.229 /dNorthWind /i yoursql.sql";

      string strRst = ExeCommand(sqlQuery);

      private void ExeCommand(string sqlQuery)
        {
            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(sqlQuery);

                p.StandardInput.WriteLine("exit");

                strOutput = p.StandardOutput.ReadToEnd();

                p.WaitForExit();

                p.Close();

            }

            catch (Exception e)
            {

                strOutput = e.Message;

            }

        }

2

        string sqlQuery =  string.Format("-U {0} -P {1} -d {2} -s {3} -i {4}", "as", "123", DBName, "127.0.0.1", "create.sql");
        private void ExeCommand(string sqlQuery)
        {
            System.Diagnostics.Process pr = new System.Diagnostics.Process();
            pr.StartInfo.FileName = "osql.exe ";
           
            pr.StartInfo.Arguments = sqlQuery;
            pr.StartInfo.UseShellExecute = false;
            pr.StartInfo.RedirectStandardOutput = false;  //重定向输出

            pr.StartInfo.WindowStyle = System.Diagnostics.ProcessWindowStyle.Hidden;//隐藏输出窗口
            pr.Start();

            System.IO.StreamReader sr = pr.StandardOutput;
            Console.WriteLine(sr.ReadToEnd());

            pr.WaitForExit();
            pr.Close();

        }