使用asp.net从数据库中获取图像并在webform中显示

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack)
    {
        // 连接数据库
        string connectionString = "YourConnectionString";
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            // 打开数据库连接
            connection.Open();

            // 创建SQL查询语句
            string query = "SELECT ImageData FROM YourTableName WHERE ImageId = @ImageId";

            // 创建SQL命令对象
            using (SqlCommand command = new SqlCommand(query, connection))
            {
                // 设置参数
                command.Parameters.AddWithValue("@ImageId", 1); // 替换为你要获取的图像的ID

                // 执行查询并获取结果
                byte[] imageData = (byte[])command.ExecuteScalar();

                // 将图像数据转换为Base64字符串
                string base64String = Convert.ToBase64String(imageData);

                // 设置Image控件的ImageUrl属性为Base64字符串
                Image1.ImageUrl = "data:image/jpeg;base64," + base64String;
            }
        }
    }
}