.NET调用osql.exe执行sql脚本创建表和存储过程

今天药忘吃喽~ 2022-08-13 11:54 160阅读 0赞

本文转自：[http://www.cnblogs.com/wenjl520/archive/2010/07/08/1773952.html][http_www.cnblogs.com_wenjl520_archive_2010_07_08_1773952.html]

Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->using System;
    using System.Diagnostics;
    using System.Windows.Forms;
    
    namespace WindowsFormsApplication1
    {
        public partial class Form1 : Form
        {
            public Form1()
            {
                InitializeComponent();
            }
    
            private void button1_Click(object sender, EventArgs e)
            {
                //参数
                string[] args = new string[5];
                args[0] = "-U " + txtUserName.Text; //用户名
                args[1] = "-P " + txtPassword.Text; //用户密码
                args[2] = "-S " + txtServer.Text; //服务器
                args[3] = "-d " + txtDatabase.Text; //数据库
                args[4] = "-i " + AppDomain.CurrentDomain.BaseDirectory + "Install.sql"; //sql脚本路径
    
                //执行
                textBox1.Text = CommandLine("osql.exe", args);
            }
    
            #region 调用命令行工具
    
            /// <summary>
            /// 调用命令行工具
            /// </summary>
            /// <param name="name">命令行工具名称</param>
            /// <param name="args">可选命令行参数</param>
            /// <remarks>注意：所有命令行工具都必须保存于system32文件夹中</remarks>
            /// <returns></returns>
            private string CommandLine(string name, params string[] args)
            {
                return CommandLine(name, "", args);
            }
    
            /// <summary>
            /// 调用命令行工具
            /// </summary>
            /// <param name="name">命令行工具名称</param>
            /// <param name="workingDirectory">设置工作目录</param>
            /// <param name="args">可选命令行参数</param>
            /// <remarks>注意：所有命令行工具都必须保存于system32文件夹中</remarks>
            /// <returns></returns>
            private string CommandLine(string name, string workingDirectory, params string[] args)
            {
                string returnValue = "";
    
                using (Process commandline = new Process())
                {
                    try
                    {
                        commandline.StartInfo.UseShellExecute = false;
                        commandline.StartInfo.CreateNoWindow = true;
                        commandline.StartInfo.WindowStyle = ProcessWindowStyle.Hidden;
                        commandline.StartInfo.RedirectStandardOutput = true;
                        commandline.StartInfo.FileName = name;
                        commandline.StartInfo.WorkingDirectory = workingDirectory;
                        //添加命令行参数
                        if (args.Length > 0) commandline.StartInfo.Arguments = string.Join(" ", args);
                        commandline.Start();
                        commandline.WaitForExit();
                        returnValue = commandline.StandardOutput.ReadToEnd();
                        commandline.Close();
                    }
                    catch
                    {
                        commandline.Dispose();
                        throw;
                    }
                }
    
                return returnValue;
            }
    
            #endregion
        }
    }

[http_www.cnblogs.com_wenjl520_archive_2010_07_08_1773952.html]: http://www.cnblogs.com/wenjl520/archive/2010/07/08/1773952.html