如何在 SQL Server2000 中儲存映像及讀取映像資訊

來源:互聯網
上載者:User
server ////////////////////////////////////////////////////////////////////////////////
//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);
}
}
}
}



相關文章

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。