中实现存储图片到SQLServer2005中.docVIP

把图片存到数据库中,自己用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.Close();??????????? fs.Close(); ??????????? //把图片写到数据库中??????????? string conn = @Data Source=JNITDEV\SQLEXPRESS;Initial Catalog=Picture;Integrated Security=True;??????????? using (SqlConnection sqlConn = new SqlConnection(conn))??????????? {??????????????? SqlCommand sqlComm = new SqlCommand(); ??????????????? sqlConn.Open();??????????????? sqlComm.Connection = sqlConn;??????????????? sqlComm.CommandText = INSERT INTO Picture (PictureContent, PictureText) VALUES (@Picture,Test);??????????????? sqlComm.CommandType = CommandType.Text; ??????????????? sqlComm.Parameters.Add(@Picture, SqlDbType.Image, photo.Length).Value = photo; ??????????????? sqlComm.ExecuteNonQuery();??????????? }??????? } ??????? private void cmdShow_Click(object sender, EventArgs e)??????? {??????????? PicShow picShow = new PicShow();??????????? picShow.Show();??????? }??? }} 下面是显示界面代码 using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.IO;using System.D