将第二个参数传递给C#中的存储过程

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

public class Program
{
    public static void Main()
    {
        string connectionString = "YourConnectionString";
        string storedProcedureName = "YourStoredProcedureName";
        int parameterValue = 42; // 第二个参数的值

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

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

                // 添加参数
                command.Parameters.AddWithValue("@ParameterName", parameterValue);

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