//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); } } } } |