• 欢迎访问少将博客,学会感恩,乐于付出,珍惜缘份,成就彼此、推荐使用最新版火狐浏览器和Chrome浏览器访问本网站。
  • 如果您觉得本站非常有看点,那么赶紧使用Ctrl+D 收藏少将博客吧
  • 欢迎加博主微信:jiang_shaobo

数据库开发:在SQL2000数据库写入和读取图片信息

点滴 admin 8年前 (2011-08-19) 196次浏览 已收录 0个评论 扫描二维码

////////////////////////////////////////////////////////////////////////////////

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

喜欢 (0)
[🍬谢谢你请我吃糖果🍬🍬~]
分享 (0)
关于作者:
少将,关注Web全栈开发、项目管理,持续不断的学习、努力成为一个更棒的开发,做最好的自己,让世界因你不同。
发表我的评论
取消评论

表情 贴图 加粗 删除线 居中 斜体 签到

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址