C#学习教程：需要在C＃中获取SQLServer“PRINT”值分享

您可以使用SqlConnection.InfoMessage事件。

您可以像这样使用SqlConnection.InfoMessage事件：

上述就是C#学习教程：需要在C＃中获取SQL Server“PRINT”值分享的全部内容，如果对大家有所用处且需要了解更多关于C#学习教程，希望大家多多关注&＃8212;编程笔记

 using System.Data; using System.Data.SqlClient; namespace foo { class bar { static public void ExecuteStoredProc() { var cOnnectionString= "Data Source=.;Integrated Security=True;Pooling=False;Initial Catalog=YourDatabaseName"; using (var cOnnection= new SqlConnection(connectionString)) using (var command = new SqlCommand("dbo.YourStoredProcedure", connection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@YourParameterName", "YourParameterValue"); connection.Open(); // wire up an event handler to the connection.InfoMessage event connection.InfoMessage += connection_InfoMessage; var result = command.ExecuteNonQuery(); connection.Close(); } } static void connection_InfoMessage(object sender, SqlInfoMessageEventArgs e) { // this gets the print statements (maybe the error statements?) var outputFromStoredProcedure = e.Message; } } }