数据库存取图片

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.IO;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace 数据库存取图片
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        //定义缓冲区
        byte[] b;
 
        private void btnAddPhoto_Click(object sender, EventArgs e)
        {
            if (openFileDialog1.ShowDialog() == DialogResult.OK)
            {
                txtPath.Text = openFileDialog1.FileName;
            }
            FileStream fs = new FileStream(txtPath.Text, FileMode.Open, FileAccess.Read);
            b = new byte[fs.Length];
            fs.Read(b, 0, b.Length);
            Stream s = new MemoryStream(b,0,b.Length);
            pictureBox1.Image = Image.FromStream(s);
        }
        private void btnOK_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection("server=.;database=pubs;uid=sa;pwd=123456");
            string sql = "insert into userinfo values(@userName,@userPhoto)";
            SqlCommand cmd = new SqlCommand(sql, con);
            cmd.Parameters.Add("@userName",SqlDbType.VarChar,50);
            cmd.Parameters[0].Value = txtUserName.Text;
            cmd.Parameters.Add("@userPhoto", SqlDbType.Image);
            cmd.Parameters["@userPhoto"].Value = b;
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
            MessageBox.Show("添加完毕");
        }
        private void btnGet_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection("server=.;database=pubs;uid=sa;pwd=123456");
            string sql = "select * from userinfo where username [email==@username]=@username[/email]";
            SqlCommand cmd = new SqlCommand(sql, con);
            cmd.Parameters.Add("@username",SqlDbType.VarChar,50);
            cmd.Parameters[0].Value = txtGetName.Text;
            con.Open();
            SqlDataReader dr = cmd.ExecuteReader();
            if(!dr.HasRows)
            {
                MessageBox.Show("不存在该用户");
                dr.Close();
                con.Close();
                return;
            }
            dr.Read();//游标下移
            byte []photo =(byte[]) dr["userPhoto"];
            Stream s = new MemoryStream(photo);
            pictureBox2.Image = Image.FromStream(s);
            con.Close();
            MessageBox.Show("读取完毕");
        }
    }
}