C#将SQL表中的所有图像选择到所有图片框中

using System;
using System.Data.SqlClient;
using System.Drawing;
using System.Windows.Forms;

public partial class Form1 : Form
{
    private SqlConnection connection;
    private SqlCommand command;
    private SqlDataReader reader;

    public Form1()
    {
        InitializeComponent();
        InitializeConnection();
    }

    private void InitializeConnection()
    {
        connection = new SqlConnection("YourConnectionStringHere");
        command = new SqlCommand("SELECT ImageColumn FROM ImagesTable", connection);
    }

    private void LoadImages()
    {
        try
        {
            connection.Open();
            reader = command.ExecuteReader();

            int pictureBoxIndex = 0;
            while (reader.Read())
            {
                byte[] imageBytes = (byte[])reader["ImageColumn"];
                Image image = byteArrayToImage(imageBytes);

                if (pictureBoxIndex < this.Controls.OfType<PictureBox>().Count())
                {
                    PictureBox pictureBox = this.Controls.OfType<PictureBox>().ElementAt(pictureBoxIndex);
                    pictureBox.Image = image;
                    pictureBox.SizeMode = PictureBoxSizeMode.AutoSize;
                    pictureBoxIndex++;
                }
                else
                {
                    // 如果PictureBox控件不够，可以在这里添加新的PictureBox控件
                    break;
                }
            }
        }
        catch (Exception ex)
        {
            MessageBox.Show("Error: " + ex.Message);
        }
        finally
        {
            reader.Close();
            connection.Close();
        }
    }

    private Image byteArrayToImage(byte[] byteArrayIn)
    {
        using (MemoryStream ms = new MemoryStream(byteArrayIn))
        {
            return Image.FromStream(ms);
        }
    }

    private void Form1_Load(object sender, EventArgs e)
    {
        LoadImages();
    }
}