OSQL执行Sql文件

我会带着你远行 2021-12-21 03:57 464阅读 0赞

//执行Sql文件
                                Thread.Sleep(1000);
                                System.Diagnostics.Process pr = new System.Diagnostics.Process();
                                pr.StartInfo.FileName = "osql.exe";
                                pr.StartInfo.Arguments = string.Format(" -U {0} -P {1} -d {2} -s {3} -i \"{4}\"", txtUID.Text.Trim(), txtPWD.Text.Trim(), txtDBNAME.Text.Trim(), txtSERVERNAME.Text.Trim(), @fileName);
                                pr.StartInfo.UseShellExecute = false;
                                pr.StartInfo.RedirectStandardOutput = true;  //重定向输出
                                pr.StartInfo.WindowStyle = System.Diagnostics.ProcessWindowStyle.Hidden;//隐藏输出窗口
                                pr.Start();
                                System.IO.StreamReader sr = pr.StandardOutput;
                                Console.WriteLine(sr.ReadToEnd());
                                pr.WaitForExit();
                                pr.Close();
 string.Format(" -U {0} -P {1} -d {2} -s {3} -i \"{4}\"",用户名,密码，数据库名称, 服务器名称或IP, @fileName);
fileName：sql文件路径