在View ASP.NET MVC中调用存储过程

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

public class HomeController : Controller
{
    public ActionResult Index()
    {
        string connectionString = "your_connection_string";
        string storedProcedureName = "your_stored_procedure_name";

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

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

                // 添加输入参数
                command.Parameters.AddWithValue("@param1", value1);
                command.Parameters.AddWithValue("@param2", value2);

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

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

                // 读取输出参数的值
                string outputValue = command.Parameters["@outputParam"].Value.ToString();

                // 处理结果集
                using (SqlDataReader reader = command.ExecuteReader())
                {
                    while (reader.Read())
                    {
                        // 读取结果集的数据
                    }
                }
            }
        }

        return View();
    }
}