如何在SQLServer2000中保存圖像及讀取圖像信息

//////////////////////////////////////////////////////////////////////////////// //Author: stardicky // //E-mail: stardicky@hotmail.com // //QQNumber: 9531511 // //CompanyName: Ezone International // //Class: HBS-0308 // //title: 如何在 sq

　　////////////////////////////////////////////////////////////////////////////////
//Author: stardicky //
//E-mail: stardicky@hotmail.com //
//QQNumber: 9531511 //
//CompanyName: Ezone International //
//Class: HBS-0308 //
//title: 如何在 sql server(WINDOWS平臺上強大的數據庫平臺)2000 中保存保存圖像及讀取圖像信息 //
////////////////////////////////////////////////////////////////////////////////
//注意:運行這實例的之前需要在查詢分析器中執行下列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 [Prima(最完善的虛擬主機管理系統)RY] TEXTIMAGE_ON [Prima(最完善的虛擬主機管理系統)RY] //
//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 MySQL(和PHP搭配之最佳組合)Con;
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.MySQL(和PHP搭配之最佳組合)Con = 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);
//
// MySQL(和PHP搭配之最佳組合)Con 數據庫的連接對象
//
this.MySQL(和PHP搭配之最佳組合)Con.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 =

聲明：本網頁內容旨在傳播知識，若有侵權等問題請及時與本網聯系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com