C# 数据库存放图片代码

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

namespace ImageOperation2
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void btnObserve_Click(object sender, EventArgs e)
        {
            string constr = "Data Source=PC-200911031859;Initial Catalog=Image2;Integrated Security=True";
            SqlConnection con = new SqlConnection(constr);
            con.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = con;
            OpenFileDialog f = new OpenFileDialog();
            DialogResult re = f.ShowDialog();

            if (re == DialogResult.OK)
            {
                string s=f.FileName;
                FileStream fs = new FileStream(f.FileName, FileMode.Open, FileAccess.Read);
                BinaryReader reder = new BinaryReader(fs);
                byte[] bb = new byte[fs.Length];
                bb = reder.ReadBytes(Convert.ToInt32(fs.Length));

                SqlCommand com = new SqlCommand("insert into picture2 values(@ImageList)", con);

                com.Parameters.Add("ImageList", SqlDbType.Image);

                com.Parameters["ImageList"].Value = bb;
                com.ExecuteNonQuery();

 

                //string str="";
              
                //string sql = "insert into picture2(piccontent) values(" + bb+ ")";
                //cmd.CommandText = sql;
                //cmd.ExecuteNonQuery();
             
                picBoxShow.Image = Image.FromFile(s);

            }
           
            con.Close();
        }

        private void btnSearch_Click(object sender, EventArgs e)
        {
            string s = "";
            string constr = "Data Source=PC-200911031859;Initial Catalog=Image2;Integrated Security=True";
            SqlConnection con = new SqlConnection(constr);
            con.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = con;
            string sql = "select piccontent from  picture2 where picid=7";
            cmd.CommandText = sql;
            SqlDataReader reader = cmd.ExecuteReader();
            DataSet dd = new DataSet();
            while (reader.Read())
            {
                s = reader.GetValue(0).ToString();
                byte[] bb = (byte[])(reader.GetValue(0));
                //byte[] bb =new byte[s.Length];
                //for (int i = 0; i < s.Length; i++)
                //{
                //    bb[i] = Convert.ToByte(s[i]);

                //}
                MemoryStream me=new MemoryStream(bb);
                Bitmap map = new Bitmap(me);
                picBoxShow.Image = map;
                me.Close();
            }
            reader.Close();
        }

    
    }
}