在C#中实现存储图片到SQLServer2005

 在论坛中碰到有朋友问到如和把图片存到数据库中,自己用VS2005+SQLServer2005实现了这个功能.

上面是主界面

上面是显示界面

数据库为Picture,数据表为Picture,表结构设计如下所示:

PictureID int 4,          PictureContent Image,        PictureText nvarchar(50)

下面是主界面的代码

namespace PictureToDataBase
{
    public partial class Main : Form
    {
        string fileSaveURL;

        public Main()
        {
            InitializeComponent();
        }

        private void cmdOpen_Click(object sender, EventArgs e)
        {
            this.openFileDialog.ShowDialog();

            string fileURL = this.openFileDialog.FileName;
            this.picView.ImageLocation = fileURL;
            this.fileSaveURL = fileURL;
        }

        private void cmdSave_Click(object sender, EventArgs e)
        {  //获取图片的二进制流
            FileStream fs = new FileStream(fileSaveURL, FileMode.Open);
            BinaryReader br = new BinaryReader(fs);

            byte[] photo = br.ReadBytes((int)fs.Length);

            br.