using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace 讀取數(shù)據(jù)庫(kù)中的圖片
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        /// <summary>
        /// 選擇圖片
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button1_Click(object sender, EventArgs e)
        {
            //初始化打開(kāi)文件 對(duì)話框
            OpenFileDialog ofdlgTest = new OpenFileDialog();
            ofdlgTest.Filter = "*.jpg|*.png";   //文件過(guò)濾 篩選可以打開(kāi)的文件
            ofdlgTest.Multiselect = false;    //設(shè)置不可以選擇多個(gè)文件

            //顯示文件打開(kāi)對(duì)話框
            DialogResult result = ofdlgTest.ShowDialog();
            
            //選擇打開(kāi)按鈕的時(shí)候，將文件名顯示到文本框中
            if (result== DialogResult.OK)                   //判斷是否打開(kāi)文件
            {
                this.textBox1.Text = ofdlgTest.FileName;

                pictureBox1.Image = Image.FromFile(ofdlgTest.FileName);
            }
        }

        /// <summary>
        /// 存入數(shù)據(jù)庫(kù)
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button2_Click(object sender, EventArgs e)
        {
            string constr = "Data Source=.;Initial Catalog=MyFirstDatabase;User Id=sa;PassWord=91811372c";

            using(SqlConnection con=new SqlConnection(constr))
            {
                //sql語(yǔ)句  插入圖片
                string sql = "insert into ImageTest values(@UserImage)";
                using(SqlCommand com=new SqlCommand(sql,con))
                {
                    byte[] buffer;   //將圖片轉(zhuǎn)換為字節(jié)數(shù)組 存入數(shù)據(jù)庫(kù)   textBox1.Text 是文件的路徑
                    using(FileStream stream = new FileStream(textBox1.Text, FileMode.OpenOrCreate, FileAccess.Read))
                    {
                        //通過(guò)文件路徑 打開(kāi)文件
                        buffer = new byte[stream.Length];
                        stream.Read(buffer, 0, buffer.Length);  //轉(zhuǎn)換后 ，存入buffer中
                    }

                    //這個(gè)參數(shù) 其實(shí) 也沒(méi)必要聲明 不過(guò)習(xí)慣使用 帶參數(shù)的sql語(yǔ)句了 
                    SqlParameter pms = new SqlParameter("@UserImage", SqlDbType.Image) { Value = buffer };
                    com.Parameters.Add(pms);
                    con.Open();
                    string msg = com.ExecuteNonQuery()>0?"存入成功":"存入失敗";
                    MessageBox.Show(msg);
                }
            }
        }

        /// <summary>
        /// 從數(shù)據(jù)庫(kù)中讀取
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button3_Click(object sender, EventArgs e)
        {
            string conStr = "Data Source=.;Initial Catalog=MyFirstDatabase;User Id=sa;PassWord=自己的密碼";
            using(SqlConnection con=new SqlConnection(conStr))
            {
                //sql語(yǔ)句
                string sql = "select * from ImageTest";
                using (SqlCommand com = new SqlCommand(sql, con))
                {
                    con.Open();

                   
                   using(SqlDataReader reader=com.ExecuteReader())
                    {
                        if (reader.HasRows)
                        {
                            //聲明一字節(jié)數(shù)組   將數(shù)據(jù)庫(kù)中的圖片現(xiàn)存入字節(jié)數(shù)組中
                            byte[] imageByte;
							//在這我是知道里面就一張圖，所以這么寫(xiě)的，個(gè)人根據(jù)實(shí)際情況，可做修改
                           while(reader.Read())
                            {
                                //將圖片轉(zhuǎn)換為字節(jié)數(shù)組
                                imageByte = (byte[])reader["UserImage"];

                                //轉(zhuǎn)換為文件流
                                MemoryStream stream = new MemoryStream(imageByte);
                                //再將文件流 轉(zhuǎn)換為 圖像
                                Bitmap bitmap = new Bitmap(stream);
                                pictureBox1.Image = bitmap;
                            }
                        }
                    }
                }
            }
        }
    }
}