Messages from stored procedure

[Guest]

Ho can I get the messages from a Stored Procedure (MS-SQLServer)

I do the follwing

Dim oCn As SqlConnection = Nothing '//--- Declare the SqlConnectio
oCn = New SqlConnection(Me.ConnectionString
oCn = Connect(

Dim oCmd As SqlCommand = New SqlCommand() '//--- Create a new SqlComman

oCmd .Connection = oC
oCmd .CommandText = sProcNam
oCmd .CommandType = CommandType.StoredProcedur

Dim oDA As SqlDataAdapter = New SqlDataAdapter() '//--- Create a new SqlDataAdapte

oDA.SelectCommand = oCm

And now, I would like to have the output of the stored procedure (the messages I see executing the Stored Procedure in the query analyzer)

How do I do that

your help is very much appreciated

Beat

 

[William Ryan eMVP]

you can trap the infomessage event if you are trying to grab print messages for instances. Check out
Using ADO.NET to prcoess T-SQL batches from a few days ago answered by Graeme Malcolm and this link http://www.knowdotnet.com/articles/connections.html