//将图像保存到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("http://www.cnblogs.com/moss_tan_jun/admin/file://")+1/);

    try

    {

     this.sqlConnection1.Open();

     this.sqlCommand1.ExecuteNonQuery();

     this.sqlConnection1.Close();

    }

    catch(System.Exception ee)

    {

     MessageBox.Show(ee.Message );

    }

    buffByte = null; 

    this.FillListBox();

   }

读取：

从数据库读图片到picturebox

SqlConnection conn=new SqlConnection(@"data source=chenyuming2004VSdotNET;uid=sa;pwd=cym;database=lhf");

conn.Open();

SqlCommand cmd=new SqlCommand("select 照片 from fuser where password='1b'",conn);

SqlDataReader reader=cmd.ExecuteReader();

reader.Read();

MemoryStream buf=new MemoryStream((byte[])reader[0]);

Image image=Image.FromStream(buf,true);

pictureBox1.Image=image;