ADO.NET and T-SQL print command

[Adam K.]

Hello,
I want write application, that execute stored procedure (MSSQL 2005).
This procedure looks for example look like this:
CREATE PROCEDURE dbo.Test AS
BEGIN
PRINT 'Hello World!!';
END

I know that i can use ie SqlCommand but how can i read messages printed by
T-SQL command PRINT??

Can anyone help me?

Best regards

Adam

 

[Alberto Poblacion]

Hello,
I want write application, that execute stored procedure (MSSQL 2005).
This procedure looks for example look like this:
CREATE PROCEDURE dbo.Test AS
BEGIN
PRINT 'Hello World!!';
END

I know that i can use ie SqlCommand but how can i read messages printed by
T-SQL command PRINT??

Those PRINT messages come back to you in the InfoMessage event of the
SqlConnection object:

using (SqlConnection cn = new SqlConnection(connString))
{
cn.InfoMessage += new SqlInfoMessageEventHandler(myRoutine);
SqlCommand cmd = new SqlCommand("dbo.Test", cn);
cmd.CommandType = CommandType.StoredProcedure;
cn.Open();
cmd.ExecuteNonQuery();
//At this point "myRoutine" will have been triggered and received the
text.
}
....

private void myRoutine(object sender, SqlInfoMessageEventArgs e)
{
string receivedPrintText = e.Message;
//...
}

 

[Adam K.]

Those PRINT messages come back to you in the InfoMessage event of the
SqlConnection object:

using (SqlConnection cn = new SqlConnection(connString))
{
cn.InfoMessage += new SqlInfoMessageEventHandler(myRoutine);
SqlCommand cmd = new SqlCommand("dbo.Test", cn);
cmd.CommandType = CommandType.StoredProcedure;
cn.Open();
cmd.ExecuteNonQuery();
//At this point "myRoutine" will have been triggered and received the
text.
}
...

private void myRoutine(object sender, SqlInfoMessageEventArgs e)
{
string receivedPrintText = e.Message;
//...
}

It's working, thank you

Regards

Adam