////////////////////////////////////////////////////////////////////////////////
//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 =
