利用C#在SQL Server2000存取图像 For Window

数据库表:

CREATE TABLE [TABLE1] (
 [id] [int] IDENTITY (1, 1) NOT NULL ,
 [img] [image] NULL ,
 [name] [varchar] (50) COLLATE Chinese_PRC_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;

namespace WindowsApplication1
{
 /// <summary>
 /// Form1 的摘要说明。
 /// </summary>
 public class Form1 : System.Windows.Forms.Form
 {
  private System.Windows.Forms.OpenFileDialog openFileDialog1;
  private System.Data.SqlClient.SqlCommand sqlCommand1;
  private System.Data.SqlClient.SqlConnection sqlConnection1;
  private System.Windows.Forms.ListBox listBox1;
  private System.Windows.Forms.Splitter splitter1;
  private System.Windows.Forms.Panel panel1;
  private System.Windows.Forms.Button button2;
  private System.Windows.Forms.Button button1;
  private System.Windows.Forms.ContextMenu contextMenu1;
  private System.Windows.Forms.MenuItem menuItem1;
  private System.Windows.Forms.SaveFileDialog saveFileDialog1;
  private System.Windows.Forms.Panel panel2;
  private System.Windows.Forms.PictureBox pictureBox1;
  private System.Windows.Forms.MenuItem menuItem2;
  private System.Windows.Forms.MenuItem menuItem3;
  /// <summary>
  /// 必需的设计器变量。
  /// </summary>
  private System.ComponentModel.Container components = null;

  public Form1()
  {
   //
   // Windows 窗体设计器支持所必需的
   //
   InitializeComponent();

   //
   // TODO: 在 InitializeComponent 调用后添加任何构造函数代码
   //
  }

  /// <summary>
  /// 清理所有正在使用的资源。
  /// </summary>
  protected override void Dispose( bool disposing )
  {
   if( disposing )
   {
    if (components != null)
    {
     components.Dispose();
    }
   }
   base.Dispose( disposing );
  }

  #region Windows 窗体设计器生成的代码
  /// <summary>
  /// 设计器支持所需的方法 - 不要使用代码编辑器修改
  /// 此方法的内容。
  /// </summary>
  private void InitializeComponent()
  {
   this.openFileDialog1 = new System.Windows.Forms.OpenFileDialog();
   this.sqlCommand1 = new System.Data.SqlClient.SqlCommand();
   this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();
   this.listBox1 = new System.Windows.Forms.ListBox();
   this.splitter1 = new System.Windows.Forms.Splitter();
   this.panel1 = new System.Windows.Forms.Panel();
   this.button2 = new System.Windows.Forms.Button();
   this.button1 = new System.Windows.Forms.Button();
   this.contextMenu1 = new System.Windows.Forms.ContextMenu();
   this.menuItem1 = new System.Windows.Forms.MenuItem();
   this.saveFileDialog1 = new System.Windows.Forms.SaveFileDialog();
   this.panel2 = new System.Windows.Forms.Panel();
   this.pictureBox1 = new System.Windows.Forms.PictureBox();
   this.menuItem2 = new System.Windows.Forms.MenuItem();
   this.menuItem3 = new System.Windows.Forms.MenuItem();
   this.panel1.SuspendLayout();
   this.panel2.SuspendLayout();
   this.SuspendLayout();
   //
   // listBox1
   //
   this.listBox1.Dock = System.Windows.Forms.DockStyle.Left;
   this.listBox1.ItemHeight = 12;
   this.listBox1.Location = new System.Drawing.Point(0, 0);
   this.listBox1.Name = "listBox1";
   this.listBox1.Size = new System.Drawing.Size(176, 412);
   this.listBox1.TabIndex = 4;
   //
   // splitter1
   //
   this.splitter1.Location = new System.Drawing.Point(176, 0);
   this.splitter1.Name = "splitter1";
   this.splitter1.Size = new System.Drawing.Size(3, 421);
   this.splitter1.TabIndex = 5;
   this.splitter1.TabStop = false;
   //
   // panel1
   //
   this.panel1.Controls.Add(this.button2);
   this.panel1.Controls.Add(this.button1);
   this.panel1.Dock = System.Windows.Forms.DockStyle.Bottom;
   this.panel1.Location = new System.Drawing.Point(179, 349);
   this.panel1.Name = "panel1";
   this.panel1.Size = new System.Drawing.Size(469, 72);
   this.panel1.TabIndex = 6;
   //
   // button2
   //
   this.button2.Location = new System.Drawing.Point(152, 16);
   this.button2.Name = "button2";
   this.button2.Size = new System.Drawing.Size(208, 40);
   this.button2.TabIndex = 4;
   this.button2.Text = "选择图片存入数据库";
   this.button2.Click += new System.EventHandler(this.button2_Click_1);
   //
   // button1
   //
   this.button1.Location = new System.Drawing.Point(216, 16);
   this.button1.Name = "button1";
   this.button1.Size = new System.Drawing.Size(88, 32);
   this.button1.TabIndex = 5;
   this.button1.Text = "读取";
   this.button1.Visible = false;
   //
   // contextMenu1
   //
   this.contextMenu1.MenuItems.AddRange(new System.Windows.Forms.MenuItem[] {
                       this.menuItem1,
                       this.menuItem2,
                       this.menuItem3});
   //
   // menuItem1
   //
   this.menuItem1.Index = 0;
   this.menuItem1.Text = "另存";
   //this.menuItem1.Click += new System.EventHandler(this.menuItem1_Click);
   //
   // panel2
   //
   this.panel2.AutoScroll = true;
   this.panel2.Controls.Add(this.pictureBox1);
   this.panel2.Dock = System.Windows.Forms.DockStyle.Fill;
   this.panel2.Location = new System.Drawing.Point(179, 0);
   this.panel2.Name = "panel2";
   this.panel2.Size = new System.Drawing.Size(469, 349);
   this.panel2.TabIndex = 7;
   //
   // pictureBox1
   //
   this.pictureBox1.ContextMenu = this.contextMenu1;
   this.pictureBox1.Location = new System.Drawing.Point(0, 0);
   this.pictureBox1.Name = "pictureBox1";
   this.pictureBox1.Size = new System.Drawing.Size(264, 192);
   this.pictureBox1.SizeMode = System.Windows.Forms.PictureBoxSizeMode.AutoSize;
   this.pictureBox1.TabIndex = 0;
   this.pictureBox1.TabStop = false;
   //
   // menuItem2
   //
   this.menuItem2.Index = 1;
   this.menuItem2.Text = "缩小";
   //this.menuItem2.Click += new System.EventHandler(this.menuItem2_Click);
   //
   // menuItem3
   //
   this.menuItem3.Index = 2;
   this.menuItem3.Text = "放大";
   //this.menuItem3.Click += new System.EventHandler(this.menuItem3_Click);
   //
   // Form1
   //
   this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
   this.ClientSize = new System.Drawing.Size(648, 421);
   this.Controls.Add(this.panel2);
   this.Controls.Add(this.panel1);
   this.Controls.Add(this.splitter1);
   this.Controls.Add(this.listBox1);
   this.Name = "Form1";
   this.Text = "Form1";
   this.Load += new System.EventHandler(this.Form1_Load);
   this.panel1.ResumeLayout(false);
   this.panel2.ResumeLayout(false);
   this.ResumeLayout(false);

  }
  #endregion

  /// <summary>
  /// 应用程序的主入口点。
  /// </summary>
  [STAThread]
  static void Main()
  {
   Application.Run(new Form1());
  }

  private void Form1_Load(object sender, System.EventArgs e)
  {
   string connString="";
   connString = @"Persist Security Info=False;User ID=sa;Initial Catalog=work;Data Source=(local)";
   this.sqlConnection1.ConnectionString = connString;
   this.FillListBox();
   if (this.listBox1.Items.Count > 0) this.listBox1.SetSelected(0,true);
  }

  private void FillListBox()
  {
   this.listBox1.SelectedIndexChanged -= new System.EventHandler(this.listBox1_SelectedIndexChanged);
   string comm = "select id,name from table1";
   System.Data.DataTable dt = new DataTable("imgTable");
   this.sqlCommand1.CommandType = System.Data.CommandType.Text ;
   this.sqlCommand1.CommandText = comm;
   this.sqlCommand1.Connection = this.sqlConnection1 ;
   System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(this.sqlCommand1);
   this.sqlConnection1.Open();
   da.Fill(dt);
   this.sqlConnection1.Close();
   this.listBox1.DataSource = dt;
   this.listBox1.DisplayMember = "name";
   this.listBox1.ValueMember = "id";
   this.listBox1.Refresh();
   this.listBox1.SelectedIndexChanged += new System.EventHandler(this.listBox1_SelectedIndexChanged);
  }

  //将SQL server2000中保存的图像显示在Picture中
  private void listBox1_SelectedIndexChanged(object sender, System.EventArgs e)
  {
   byte[] buffByte = null;
   string comm = @"select img from table1 where id = " + this.listBox1.SelectedValue ;
   this.sqlCommand1 = new System.Data.SqlClient.SqlCommand ();
   this.sqlCommand1.CommandType = System.Data.CommandType.Text ;
   this.sqlCommand1.CommandText = comm;
   this.sqlCommand1.Connection = this.sqlConnection1 ;
   this.sqlConnection1.Open();
   System.Data.SqlClient.SqlDataReader rd = this.sqlCommand1.ExecuteReader();
   while (rd.Read())
   {
    buffByte = ((byte[])rd[0]);
   }
   rd.Close();
   this.sqlConnection1.Close();
   //将图像的字节数组放入内存流
   System.IO.MemoryStream ms = new System.IO.MemoryStream(buffByte);
   //通过流对象建立Bitmap
   System.Drawing.Bitmap bmp = new Bitmap(ms);
   this.pictureBox1.Image = bmp;
  }
  
  //将图像保存到SQL server2000的Image字段中
  private void button2_Click_1(object sender, System.EventArgs e)
  {
   string pathName;
   if (this.openFileDialog1.ShowDialog()==System.Windows.Forms.DialogResult.OK)
   {
    pathName = this.openFileDialog1.FileName;
    System.Drawing.Image img = System.Drawing.Image.FromFile(pathName);
    this.pictureBox1.Image = img;
    
    //将图像读入到字节数组
    System.IO.FileStream fs = new System.IO.FileStream(pathName,System.IO.FileMode.Open,System.IO.FileAccess.Read);
    byte[] buffByte = new byte[fs.Length];
    fs.Read(buffByte,0,(int)fs.Length);
    fs.Close();
    fs = null;
    
    //建立Command命令
    string comm = @"Insert into table1(img,name) values(@img,@name)";
    this.sqlCommand1 = new System.Data.SqlClient.SqlCommand ();
    this.sqlCommand1.CommandType = System.Data.CommandType.Text ;
    this.sqlCommand1.CommandText = comm;
    this.sqlCommand1.Connection = this.sqlConnection1 ;
    //创建Parameter
    this.sqlCommand1.Parameters.Add("@img",System.Data.SqlDbType.Image);
    this.sqlCommand1.Parameters[0].Value = buffByte;
    this.sqlCommand1.Parameters.Add("@name",System.Data.SqlDbType.VarChar);
    this.sqlCommand1.Parameters[1].Value =pathName.Substring(pathName.LastIndexOf("//")+1);
    try
    {
     this.sqlConnection1.Open();
     this.sqlCommand1.ExecuteNonQuery();
     this.sqlConnection1.Close();
    }
    catch(System.Exception ee)
    {
     MessageBox.Show(ee.Message );
    }
    buffByte = null;

    this.FillListBox();
   }
  }

//  private void menuItem1_Click(object sender, System.EventArgs e)
//  {
//   this.saveFileDialog1.FileName = ((System.Data.DataRowView)this.listBox1.SelectedItem)[1].ToString();
//   this.saveFileDialog1.Filter = "JPG (*.jpg)|*.jpg|GIF (*.gif)|*.gif|位图(*.bmp)|*.bmp";
//   if (this.saveFileDialog1.ShowDialog() == System.Windows.Forms.DialogResult.OK)
//   this.pictureBox1.Image.Save(this.saveFileDialog1.FileName);
//  }
//
//  private void menuItem2_Click(object sender, System.EventArgs e)
//  {
//   System.Drawing.Image img = this.pictureBox1.Image;
//   System.Drawing.Image.GetThumbnailImageAbort myCallback = new System.Drawing.Image.GetThumbnailImageAbort(ThumbnailCallback);
//
//   System.Drawing.Image img1 = img.GetThumbnailImage(System.Convert.ToInt32(img.Width*0.5),System.Convert.ToInt32(img.Height*0.5),myCallback,IntPtr.Zero);
//   this.pictureBox1.Image = img1;
//  }
//  public bool ThumbnailCallback()
//  {
//   return false;
//  }
//
//  private void menuItem3_Click(object sender, System.EventArgs e)
//  {
//   System.Drawing.Image img = this.pictureBox1.Image;
//   System.Drawing.Image.GetThumbnailImageAbort myCallback = new System.Drawing.Image.GetThumbnailImageAbort(ThumbnailCallback);
//
//   System.Drawing.Image img1 = img.GetThumbnailImage(System.Convert.ToInt32(img.Width*1.5),System.Convert.ToInt32(img.Height*1.5),myCallback,IntPtr.Zero);
//   this.pictureBox1.Image = img1;
//  }

 }
}