在.NET中捕获存储过程打印输出

using System;
using System.Data.SqlClient;

namespace CaptureStoredProcedureOutput
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "Data Source=your_server;Initial Catalog=your_database;Integrated Security=True";
            string storedProcedureName = "your_stored_procedure";

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                connection.Open();

                using (SqlCommand command = new SqlCommand(storedProcedureName, connection))
                {
                    command.CommandType = System.Data.CommandType.StoredProcedure;

                    // 添加参数，如果需要的话
                    // command.Parameters.AddWithValue("@param1", value1);

                    // 添加输出参数以捕获存储过程的打印输出
                    SqlParameter outputParameter = new SqlParameter("@output", System.Data.SqlDbType.VarChar, 8000);
                    outputParameter.Direction = System.Data.ParameterDirection.Output;
                    command.Parameters.Add(outputParameter);

                    command.ExecuteNonQuery();

                    string output = (string)command.Parameters["@output"].Value;

                    Console.WriteLine("存储过程的打印输出：");
                    Console.WriteLine(output);
                }
            }
        }
    }
}