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

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

namespace ImageSelectionApp
{
    public partial class MainForm : Form
    {
        public MainForm()
        {
            InitializeComponent();
        }

        private void LoadImagesToPictureBoxes()
        {
            string connectionString = "YourConnectionString"; // 替换为你的数据库连接字符串
            string selectQuery = "SELECT ImageData FROM YourTableName"; // 替换为你的查询语句

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                SqlCommand command = new SqlCommand(selectQuery, connection);
                connection.Open();

                SqlDataReader reader = command.ExecuteReader();
                while (reader.Read())
                {
                    byte[] imageData = (byte[])reader["ImageData"]; // 假设图像数据保存在名为 ImageData 的列中

                    // 创建新的PictureBox控件
                    PictureBox pictureBox = new PictureBox();
                    pictureBox.Width = 200; // 设置图片框的宽度
                    pictureBox.Height = 200; // 设置图片框的高度
                    pictureBox.SizeMode = PictureBoxSizeMode.StretchImage; // 设置图片适应框的显示方式
                    pictureBox.Image = Image.FromStream(new MemoryStream(imageData)); // 将图像数据加载到图片框中
                    pictureBoxesPanel.Controls.Add(pictureBox); // 将图片框添加到容器中
                }

                reader.Close();
            }
        }

        private void MainForm_Load(object sender, EventArgs e)
        {
            LoadImagesToPictureBoxes();
        }
    }
}