C#如何在 SQL Server2000 中保存图像及读取图像信息

//Author: stardicky //
//E-mail: stardicky@hotmail.com //
//QQNumber: 9531511 //
//CompanyName: Ezone International //
//Class: HBS-0308 //
//title: 如何在 SQL Server2000 中保存保存图像及读取图像信息 //

//注意:运行这实例的之前需要在查询分析器中执行下列SQL语句: //
//CREATE DATABASE EzoneDb //
//go //
//USE EzoneDb //
//go //
//CREATE TABLE [Images] ( //
//[ImageID] [int] IDENTITY (1, 1) NOT NULL , //
//[Description] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , //
//[ImageFile] [image] NULL , //
//[ImageSize] [int] NULL , //
//[ImageType] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL //
//) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] //
//GO //

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

namespace EzoneImageInSQL
{
public class frmMain : System.Windows.Forms.Form
{
private System.Windows.Forms.GroupBox groupBox1;
private System.Windows.Forms.GroupBox groupBox2;
private System.Data.SqlClient.SqlConnection MySqlCon;
private System.Windows.Forms.Label labFilePath;
private System.Windows.Forms.TextBox txtFilePath;
private System.Windows.Forms.Button btnUpload;
private System.Windows.Forms.PictureBox ImgPictureBox;
private System.Windows.Forms.Button btnDownLoad;
private System.Windows.Forms.Label labDescription;
private System.Windows.Forms.TextBox txtImage;

private System.ComponentModel.Container components = null;

public frmMain()
{

InitializeComponent();

}

protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}

private void InitializeComponent()
{
this.labFilePath = new System.Windows.Forms.Label();
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.txtFilePath = new System.Windows.Forms.TextBox();
this.btnUpload = new System.Windows.Forms.Button();
this.groupBox2 = new System.Windows.Forms.GroupBox();
this.ImgPictureBox = new System.Windows.Forms.PictureBox();
this.btnDownLoad = new System.Windows.Forms.Button();
this.MySqlCon = new System.Data.SqlClient.SqlConnection();
this.labDescription = new System.Windows.Forms.Label();
this.txtImage = new System.Windows.Forms.TextBox();
this.groupBox1.SuspendLayout();
this.groupBox2.SuspendLayout();
this.SuspendLayout();
//
// labFilePath
//
this.labFilePath.Location = new System.Drawing.Point(8, 72);
this.labFilePath.Name = "labFilePath";
this.labFilePath.Size = new System.Drawing.Size(80, 16);
this.labFilePath.TabIndex = 0;
this.labFilePath.Text = "文件路径:";
this.labFilePath.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// groupBox1
//
this.groupBox1.Controls.Add(this.txtImage);
this.groupBox1.Controls.Add(this.labDescription);
this.groupBox1.Controls.Add(this.btnUpload);
this.groupBox1.Controls.Add(this.txtFilePath);
this.groupBox1.Controls.Add(this.labFilePath);
this.groupBox1.Location = new System.Drawing.Point(8, 8);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(280, 128);
this.groupBox1.TabIndex = 1;
this.groupBox1.TabStop = false;
this.groupBox1.Text = "文件上传给数据库";
//
// txtFilePath
//
this.txtFilePath.Location = new System.Drawing.Point(72, 64);
this.txtFilePath.Name = "txtFilePath";
this.txtFilePath.Size = new System.Drawing.Size(200, 21);
this.txtFilePath.TabIndex = 1;
this.txtFilePath.Text = "";
//
// btnUpload
//
this.btnUpload.Location = new System.Drawing.Point(192, 96);
this.btnUpload.Name = "btnUpload";
this.btnUpload.TabIndex = 2;
this.btnUpload.Text = "开始上传";
this.btnUpload.Click += new System.EventHandler(this.btnUpload_Click);
//
// groupBox2
//
this.groupBox2.Controls.Add(this.btnDownLoad);
this.groupBox2.Controls.Add(this.ImgPictureBox);
this.groupBox2.Location = new System.Drawing.Point(8, 144);
this.groupBox2.Name = "groupBox2";
this.groupBox2.Size = new System.Drawing.Size(280, 200);
this.groupBox2.TabIndex = 2;
this.groupBox2.TabStop = false;
this.groupBox2.Text = "从数据库下载图像文件并预览图像";
//
// ImgPictureBox
//
this.ImgPictureBox.Location = new System.Drawing.Point(16, 24);
this.ImgPictureBox.Name = "ImgPictureBox";
this.ImgPictureBox.Size = new System.Drawing.Size(168, 160);
this.ImgPictureBox.SizeMode = System.Windows.Forms.PictureBoxSizeMode.StretchImage;
this.ImgPictureBox.TabIndex = 0;
this.ImgPictureBox.TabStop = false;
//
// btnDownLoad
//
this.btnDownLoad.Location = new System.Drawing.Point(192, 24);
this.btnDownLoad.Name = "btnDownLoad";
this.btnDownLoad.TabIndex = 1;
this.btnDownLoad.Text = "开始下载";
this.btnDownLoad.Click += new System.EventHandler(this.btnDownLoad_Click);
//
// MySqlCon 数据库的连接对象
//
this.MySqlCon.ConnectionString = "integrated security=SSPI;data source=.;persist security info=False;initial catalog=ezonedb";
//
// labDescription
//
this.labDescription.Location = new System.Drawing.Point(8, 32);
this.labDescription.Name = "labDescription";
this.labDescription.Size = new System.Drawing.Size(88, 16);
this.labDescription.TabIndex = 3;
this.labDescription.Text = "文件描述信息:";
this.labDescription.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// txtImage
//
this.txtImage.Location = new System.Drawing.Point(96, 24);
this.txtImage.Name = "txtImage";
this.txtImage.Size = new System.Drawing.Size(176, 21);
this.txtImage.TabIndex = 4;
this.txtImage.Text = "亿众国际 Ezone International";
//
// frmMain
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(292, 349);
this.Controls.Add(this.groupBox2);
this.Controls.Add(this.groupBox1);
this.Name = "frmMain";
this.Text = "Ezone International - 亿众国际";
this.groupBox1.ResumeLayout(false);
this.groupBox2.ResumeLayout(false);
this.ResumeLayout(false);

}

[STAThread]
static void Main()
{
Application.Run(new frmMain());
}

private void btnUpload_Click(object sender, System.EventArgs e)
{
try
{
//用文件的路径信息创建一个文件对象
FileInfo MyPicture=new FileInfo(this.txtFilePath.Text);
//检查文件的存在性
if(!MyPicture.Exists)
{
MessageBox.Show("文件不存在!");
}
else
{
//检查文件的扩展名,如果不符合要求就返回
switch(MyPicture.Extension.ToUpper())
{
case ".JPG":this.UpLoadImageFile(MyPicture);break;
case ".GIF":this.UpLoadImageFile(MyPicture);break;
case ".BMP":this.UpLoadImageFile(MyPicture);break;
default:MessageBox.Show("文件类型不正确!");break;
}
}
}
catch
{
MessageBox.Show("文件路径信息不正确!");
}
}

/// <summary>
/// 向数据库写入图像文件
/// </summary>
private void UpLoadImageFile(FileInfo obj)
{
try
{
//创建一字节数组,用来存储图像文件.(数组的长度是图像文件的长度)
byte[] Content=new byte[obj.Length];
//打开文件并用他初始化一个文件流对象
FileStream ImageFileStream=obj.OpenRead();
//将文件内容写入字节数组
ImageFileStream.Read(Content,0,Content.Length);
//关闭文件流
ImageFileStream.Close();

//创建一个Sql命令对象,用来插入记录
SqlCommand Command=new SqlCommand("INSERT Into Images(Description,ImageFile,ImageSize,ImageType) Values(@Description,@ImageFile,@ImageSize,@ImageType)",this.MySqlCon);

//图像的描述信息
SqlParameter imageDescriptionParameter=new SqlParameter("@Description",SqlDbType.NVarChar);
imageDescriptionParameter.Value=this.txtImage.Text;
Command.Parameters.Add(imageDescriptionParameter);

//图像的数据字节数组
SqlParameter imageFileParameter=new SqlParameter("@ImageFile",SqlDbType.Image);
imageFileParameter.Value=Content;
Command.Parameters.Add(imageFileParameter);

//图像的大小信息
SqlParameter imageSizeParameter=new SqlParameter("@ImageSize",SqlDbType.Int);
imageSizeParameter.Value=Content.Length;
Command.Parameters.Add(imageSizeParameter);

//图像的类型新信息
SqlParameter imageTypeParameter=new SqlParameter("@ImageType",SqlDbType.NVarChar);
imageTypeParameter.Value=obj.Extension;
Command.Parameters.Add(imageTypeParameter);

//打开数据库连接
this.MySqlCon.Open();
//执行 Sql 语句
Command.ExecuteNonQuery();
//关闭数据库连接
this.MySqlCon.Close();

MessageBox.Show("图像文件 " + obj.FullName + " 成功上传到数据库!");
}
catch(Exception Ezone)
{
MessageBox.Show(Ezone.Message);
}
}
/// <summary>
/// 从数据库读取图像
/// </summary>
private void btnDownLoad_Click(object sender, System.EventArgs e)
{
try
{
//创建一个Sql命令对象,用来查询记录
SqlCommand Command=new SqlCommand("select * from Images order by ImageID DESC",this.MySqlCon);
//打开数据库连接
this.MySqlCon.Open();
//执行Sql语句
SqlDataReader MyReader=Command.ExecuteReader(CommandBehavior.CloseConnection);

MyReader.Read();
//创建一个内存流对象并用ImageFile字段,ImageSize字段初始化他
MemoryStream MyMemoryStream=new MemoryStream((byte[])MyReader["ImageFile"],0,Convert.ToInt32(MyReader["ImageSize"]));
//创建一个 Image 对象,并赋值给 Picture对象的 Image 属性
this.ImgPictureBox.Image=Image.FromStream(MyMemoryStream);
//关闭内存流
MyMemoryStream.Close();
MyReader.Close();
}
catch(Exception Ezone)
{
MessageBox.Show(Ezone.Message);
}
}
}
}