C#中执行批处理文件(.bat),执行数据库相关操作

小贝

1. using System;
2. using System.Collections.Generic;
3. using System.Linq;
4. using System.Text;
5. using System.Threading.Tasks;
6. using System.Configuration;
7. using System.Data.SqlClient;
8. using System.Data;
9. using System.Diagnostics;
11. namespace Sample2
12. {
13. class Program
14. {
15. static void Main(string[] args)
16. {
17. Process proc = null;
18. try
19. {
20. /*
21. * autorun.bat文件内容
22. osql -S 127.0.0.1 -d DataSample -U sa -P 1234567890 -i C:\test.sql
23. */
24. string targetDir = string.Format(@"C:\");
25. proc = new Process();
26. proc.StartInfo.WorkingDirectory = targetDir;
27. proc.StartInfo.FileName = "autorun.bat";
28. proc.StartInfo.Arguments = string.Format("");//this is argument
29. proc.StartInfo.CreateNoWindow = true;
30. proc.StartInfo.WindowStyle = ProcessWindowStyle.Hidden;//这里设置DOS窗口不显示，经实践可行
31. proc.Start();
32. proc.WaitForExit();
33. Console.ReadKey();
34. }
35. catch (Exception ex)
36. {
37. Console.WriteLine("Exception Occurred :{0},小贝", ex.Message, ex.StackTrace.ToString());
38. }
40. /* test.sql内容
41. USE [DataSample]
42. GO
44. SET ANSI_NULLS ON
45. GO
47. SET QUOTED_IDENTIFIER ON
48. GO
50. CREATE TABLE [dbo].[Area](
51. [AreaId] [int] IDENTITY(1,1) NOT NULL,
52. [AreaName] [nvarchar](50) NULL,
53. [CityId] [int] NULL,
54. CONSTRAINT [PK_Area] PRIMARY KEY CLUSTERED
55. (
56. [AreaId] ASC
57. )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
58. ) ON [PRIMARY]
60. GO
61. */
62. }
63. }
64. }

复制代码