Capture Stored Procedure print output in .NET

by

You can do this by adding an event handler to the InfoMessage event on the connection. 

myConnection.InfoMessage += new SqlInfoMessageEventHandler(myConnection_InfoMessage);

void myConnection_InfoMessage(object sender, SqlInfoMessageEventArgs e)
{
    myStringBuilderDefinedAsClassVariable.AppendLine(e.Message);
}

More Related Contents:

  1. Calling Oracle stored procedure from C#?
  2. How do I return XML from a Stored Procedure?
  3. Display lines number in Stack Trace for .NET assembly in Release mode
  4. printing all contents of array in C#
  5. Show a Form without stealing focus?
  6. StaTaskScheduler and STA thread message pumping
  7. Convert Pixels to Points
  8. How can I Convert HTML to Text in C#?
  9. Order of items in classes: Fields, Properties, Constructors, Methods
  10. C# 4.0, optional parameters and params do not work together
  11. Try-catch speeding up my code?
  12. Convert time span value to format “hh:mm Am/Pm” using C#
  13. Do asynchronous operations in ASP.NET MVC use a thread from ThreadPool on .NET 4
  14. How can I remove item from querystring in asp.net using c#?
  15. XML Parsing – Read a Simple XML File and Retrieve Values
  16. Are Java and C# regular expressions compatible?
  17. Parallel.For(): Update variable outside of loop
  18. DataGridView keydown event not working in C#
  19. A pattern for self-cancelling and restarting task
  20. More Elegant Exception Handling Than Multiple Catch Blocks? [duplicate]
  21. What does the @ prefix do on string literals in C#
  22. View Generated Source (After AJAX/JavaScript) in C#
  23. Extracting Path from OpenFileDialog path/filename
  24. Unix time conversions in C# [duplicate]
  25. Working with SAML 2.0 in C# .NET 4.5
  26. Memory limitations in a 64-bit .Net application?
  27. Net Core: Execute All Dependency Injection in Xunit Test for AppService, Repository, etc
  28. How can set a default value constraint with Entity Framework 6 Code First?
  29. Get the item doubleclick event of listview
  30. How can I obtain the case-sensitive path on Windows?

Leave a Comment