在c#中从vs中的存储过程获取返回值

using System;
using System.Data;
using System.Data.SqlClient;

namespace YourNamespace
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString = "YourConnectionString"; // 替换为实际的数据库连接字符串

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

                SqlCommand command = new SqlCommand("YourStoredProcedure", connection);
                command.CommandType = CommandType.StoredProcedure;

                // 添加输入参数（如果有）
                command.Parameters.AddWithValue("@InputParameter", "InputValue");

                // 添加输出参数
                SqlParameter outputParameter = new SqlParameter("@OutputParameter", SqlDbType.VarChar, 50);
                outputParameter.Direction = ParameterDirection.Output;
                command.Parameters.Add(outputParameter);

                // 执行存储过程
                command.ExecuteNonQuery();

                // 获取返回值
                string returnValue = command.Parameters["@OutputParameter"].Value.ToString();
                Console.WriteLine("返回值：" + returnValue);
            }
        }
    }
}