Stored procedure print message

Friend,

The printed output can be processed in the SqlConnection event InfoMessage:

So if you have to display the result of PRINT statements in an TextBox,

SqlConnection cn = OpenMyConnection();

cn.InfoMessage += new SqlInfoMessageEventHandler(cn_InfoMessage);

sbLog = new System.Text.StringBuilder();

SqlCommand cmd = new SqlCommand("PRINT 'Hello World'", cn);


cmd.ExecuteNonQuery();


TextBox1.Text = sbLog.ToString();


 void cn_InfoMessage(object sender, SqlInfoMessageEventArgs e)

{

sbLog.AppendLine(e.Message);

}

if it helps you please check "Do you like answer"

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Kirtan Patel17y ago
Friend,
The printed output can be processed in the SqlConnection event InfoMessage:

So if you have to display the result of PRINT statements in an TextBox,
```
SqlConnection cn = OpenMyConnection();

cn.InfoMessage += new SqlInfoMessageEventHandler(cn_InfoMessage);

sbLog = new System.Text.StringBuilder();

SqlCommand cmd = new SqlCommand("PRINT 'Hello World'", cn);


cmd.ExecuteNonQuery();


TextBox1.Text = sbLog.ToString();


 void cn_InfoMessage(object sender, SqlInfoMessageEventArgs e)

{

sbLog.AppendLine(e.Message);

}
```
if it helps you please check "Do you like answer"