Question

I use ASP 3.0 on IIS 7 and SQL Server 2008 as my dbms. I have a stored procedure coded in SQL Server. I have some "Print" statements in it and also a select statement that throws out a recordset after the procedure is executed. I can retrieve the recordset by using

Set RecordsSet = 服务器.CreateObject(“ADODB.RecordSet”)

页: 1

What I wish to do here is to retrieve the outputs of the "Print" statements that I am executing in the stored procedure. Please help. Thanks in advance!

Answer 1

在ADO中,在 Errors的收集中,都有以下数据:

Dim e
For Each e In dbConn.Errors
    Response.Write e.Description
Next

Answer 2

You can try to use the SqlInfoMessage event to trap the print statement from the connection object.

SQLConnection.InfoMessage += delegate(object sender, SqlInfoMessageEventArgs e) 
{                                    
   string printresponse = e.Message;                                    
};

You can get much more details from this link, http://www.dotnetcurry.com/ShowArticle.aspx?ID=344

希望这一帮助。

友情链接