如何获取存储过程或触发器等中的print的字符串

/*存储过程*/

create proc proc_stu
as
print 'procmy'

 

那么这个'procmy'没有在返回的结果集里的 所以不能按照获取结果集的方法获取该字符串的。

方法就是看看MSDN的解释：

http://msdn.microsoft.com/en-us/library/a0hee08w(v=VS.90).aspx

 

 

例子就是：自己写的print的是在err.Message 中

 

using System; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class _Default : System.Web.UI.Page { protected void OnInfoMessage( object sender, SqlInfoMessageEventArgs args) { foreach (SqlError err in args.Errors) { Response.Write( "The " + err.Source + "has received a severity " + err.Class + ", state " + err.State + " error number " + err.Number + "/n" + "on line " + err.LineNumber + "of procedure " + err.Procedure + " on server " + err.Server + ":/n-------" + err.Message + "----------"); } } protected void Page_Load(object sender, EventArgs e) { string connectionStrings = "server=WWW-AE53BDDCB98//SQL2005;database=test;uid=sa;pwd=123;"; SqlConnection connection = new SqlConnection(connectionStrings); SqlCommand cmd = new SqlCommand("proc_stu", connection); connection.InfoMessage += new SqlInfoMessageEventHandler(OnInfoMessage); //Response.Write(connection.State.ToString()); cmd.CommandType = CommandType.StoredProcedure; connection.Open(); cmd.ExecuteReader(); connection.Close(); } }

 

 

 

相关的帖子:

http://topic.youkuaiyun.com/t/20040811/21/3265470.html