How to get the output of a T-SQL PRINT command as string in a .net application [duplicate]

Question

How can I retrieve a string generated by the PRINT t-sql command of SQL Server in my .net application

Example Microsoft SQl Server Management Studio :

If its really necessary (i.e you cannot use a select/return value, OUT param) use a SqlInfoMessageEventHandler — Alex K.
– Alex K., Commented Mar 26, 2017 at 15:48
I've tried not working d. How did Microsoft SQL Server Management Studio do it? — Emre BOSTAN
– Emre BOSTAN, Commented Mar 26, 2017 at 15:50
That's the way to do it, if its not working then you must not be using it correctly. There are many examples out there E.g. tf3604.com/2016/03/01/capturing-output-from-sql-server-using-c — Alex K.
– Alex K., Commented Mar 26, 2017 at 15:52

Cyril Durand · Accepted Answer · 2017-03-26 15:51:34Z

7

In order to retrieve these message, you can use the InfoMessage event available on the SqlConnection class.

using (SqlConnection conn = new SqlConnection("..."))
{
    conn.InfoMessage += (sender, e) =>
    {
        Console.WriteLine($"{e.Source}-{e.Message}");
    };
    conn.Open();
    using (SqlCommand command = new SqlCommand("PRINT 'Hello World'", conn))
    {
        command.ExecuteNonQuery();
    }
}

answered Mar 26, 2017 at 15:51

Cyril Durand

16.2k5 gold badges58 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to get the output of a T-SQL PRINT command as string in a .net application [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related