如何从C#正确执行链接服务器存储过程

string connectionString = "Server=myServerAddress;Database=myDatabase;User Id=myUsername;Password=myPassword;";
SqlConnection connection = new SqlConnection(connectionString);

connection.Open();

SqlCommand command = new SqlCommand("存储过程名称", connection);
command.CommandType = CommandType.StoredProcedure;

command.Parameters.AddWithValue("@参数名", 值);

command.ExecuteNonQuery(); // 执行不返回结果的存储过程

// 执行返回结果集的存储过程
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
    // 处理结果集中的数据
}
reader.Close();

connection.Close();