难点问题：怎样读出存储过程Print出来的文本？

[leisang]

用.Net

[saucer]

look into Connection object's InfoMessage event, for example, see


http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconWorkingWithConnectionEvents.asp

here is some test code,

1. sql:

create proc testproc as
begin
print 'hello world'
end

2.

using System;
using System.Data;
using System.Data.SqlClient;

class TestData
{
protected static void OnInfoMessage(object sender, SqlInfoMessageEventArgs args)
{
foreach (SqlError err in args.Errors)
{
Console.WriteLine("The {0} has received a severity {1}, state {2} error number {3}\n" +
"on line {4} of procedure {5} on server {6}:\n{7}",
err.Source, err.Class, err.State, err.Number, err.LineNumber,
err.Procedure, err.Server, err.Message);
}
}

static void Main()
{

SqlConnection conn = new SqlConnection("server=localhost;database=tempdb;uid=sa;pwd=;");

conn.InfoMessage += new SqlInfoMessageEventHandler(OnInfoMessage);

SqlCommand cmd = new SqlCommand("testproc", conn);
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}

[leisang]

看到老大真是高兴啊！

其实我的本意是怎样读出存储过程的内容，因为看了一个例子，它是print出来的。
但是老大的例子还是看的不明白，请问有没有读出存储过程的方法？非常感谢！！

[saucer]

读出存储过程的内容??? you mean something like the following in SQL Server?

sp_helptext testproc

??

[leisang]

这么简单.....
巨寒，我吐血了，从早上折腾到现在...............
真是与君一席话，胜读十年书
再一次非常感谢思归老大，呵呵