存储过程在查询生成器中执行时有效，但在C#代码中不起作用

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

public class Program
{
    public static void Main()
    {
        string connectionString = "YourConnectionString";
        string storedProcedureName = "YourStoredProcedureName";

        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);

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

                // 处理存储过程的执行结果
                // ...
            }
        }
    }
}