sql server实现图片的存入和读取的流程详解

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 读与数据库外的图片
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        /// <su妹妹ary>
        /// 选择图片
        /// </su妹妹ary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button1_Click(object sender, EventArgs e)
        {
            //始初化掀开文件 对于话框
            OpenFileDialog ofdlgTest = new OpenFileDialog();
            ofdlgTest.Filter = "*.jpg|*.png";   //文件过滤 挑选否以掀开的文件
            ofdlgTest.Multiselect = false;    //陈设不行以选择多个文件

            //暗示文件翻开对于话框
            DialogResult result = ofdlgTest.ShowDialog();
            
            //选择掀开按钮的时辰，将文件名表现到文原框外
            if (result== DialogResult.OK)                   //判定可否翻开文件
            {
                this.textBox1.Text = ofdlgTest.FileName;

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

        /// <su妹妹ary>
        /// 存进数据库
        /// </su妹妹ary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void button两_Click(object sender, EventArgs e)
        {
            string constr = "Data Source=.;Initial Catalog=MyFirstDatabase;User Id=sa;PassWord=9181137两c";

            using(SqlConnection con=new SqlConnection(constr))
            {
                //sql语句  拔出图片
                string sql = "insert into ImageTest values(@UserImage)";
                using(SqlCo妹妹and com=new SqlCo妹妹and(sql,con))
                {
                    byte[] buffer;   //将图片转换为字节数组 存进数据库   textBox1.Text 是文件的路径
                    using(FileStream stream = new FileStream(textBox1.Text, FileMode.OpenOrCreate, FileAccess.Read))
                    {
                        //经由过程文件路径 掀开文件
                        buffer = new byte[stream.Length];
                        stream.Read(buffer, 0, buffer.Length);  //转换后 ，存进buffer外
                    }

                    //那个参数 其真 也不必声亮 不外习气利用 带参数的sql语句了 
                    SqlParameter pms = new SqlParameter("@UserImage", SqlDbType.Image) { Value = buffer };
                    com.Parameters.Add(pms);
                    con.Open();
                    string msg = com.ExecuteNonQuery()>0必修"存进顺遂":"存进掉败";
                    MessageBox.Show(msg);
                }
            }
        }

        /// <su妹妹ary>
        /// 从数据库外读与
        /// </su妹妹ary>
        /// <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语句
                string sql = "select * from ImageTest";
                using (SqlCo妹妹and com = new SqlCo妹妹and(sql, con))
                {
                    con.Open();

                   
                   using(SqlDataReader reader=com.ExecuteReader())
                    {
                        if (reader.HasRows)
                        {
                            //声亮一字节数组   将数据库外的图片现存进字节数组外
                            byte[] imageByte;
							//正在那尔是知叙内中便一弛图，以是那么写的，团体按照现实环境，否作修正
                           while(reader.Read())
                            {
                                //将图片转换为字节数组
                                imageByte = (byte[])reader["UserImage"];

                                //转换为文件流
                                MemoryStream stream = new MemoryStream(imageByte);
                                //再将文件流 转换为 图象
                                Bitmap bitmap = new Bitmap(stream);
                                pictureBox1.Image = bitmap;
                            }
                        }
                    }
                }
            }
        }
    }
}