.Net下執(zhí)行sqlcmd的方法

2020-07-25 13:26:00

字體：大中小

供稿：網(wǎng)友

如下代碼：
被的調(diào)用方法：

復(fù)制代碼代碼如下:

 
public static string ExeCommand(string commandText) 
{ 
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; 
} 

調(diào)用方法：

復(fù)制代碼代碼如下:

 
protected void Button1_Click(object sender, EventArgs e) 
{ 
string sqlQuery = "sqlcmd.exe -U sa -P 123 -S 20100330-0922 -d test -i c://1.sql"; 
string strRst = ExeCommand(sqlQuery); 
} 

1.sql文件

復(fù)制代碼代碼如下:

 
use master 
go 
CREATE ENDPOINT Orders_Endpoint6 
state=started 
as http( 
path='/sql/orders6', 
AUTHENTICATION=(INTEGRATED), 
ports=(clear) 
) 
for soap( 
WebMethod 'CustOrdersOrders'( 
name='test.dbo.GetAlltb12' 
), 
wsdl=default, 
database='test', 
namespace='http://mysite.org/' 
) 