圖檔儲存到資料庫和從資料庫讀取圖檔并顯示（C＃）

圖檔儲存到資料庫的方法：        public void imgToDB(string sql)

{

//參數sql中要求儲存的imge變量名稱為@images

//調用方法如：imgToDB("update UserPhoto set Photo=@images where UserNo='" + temp + "'");

FileStream fs = File.OpenRead(t_photo.Text);

byte[] imageb = new byte[fs.Length];

fs.Read(imageb, 0, imageb.Length);

fs.Close();

SqlCommand com3 = new SqlCommand (sql,con);

com3.Parameters.Add("@images", SqlDbType.Image).Value = imageb;

if (com3.Connection.State == ConnectionState.Closed)

com3.Connection.Open();

try

{

com3.ExecuteNonQuery();

}

catch

{ }

finally

{ com3.Connection.Close(); }

}

資料庫中讀出圖檔并顯示在picturebox中：

方法一：

private void ShowImage(string sql)

{

//調用方法如：ShowImage("select Photo from UserPhoto where UserNo='" + userno +"'");

SqlCommand cmd = new SqlCommand(sql, conn);

conn.Open();

byte[] b= (byte[])cmd.ExecuteScalar();

if (b.Length 〉 0)

{

MemoryStream stream = new MemoryStream(b, true);

stream.Write(b, 0, b.Length);

pictureBox1.Image = new Bitmap(stream);

stream.Close();

}

conn.Close();

}

方法二：當在dg中選中某行時：  private void dg_MouseUp(object sender, MouseEventArgs e)

{

//整行選擇

if (e.Button == System.Windows.Forms.MouseButtons.Left)

{//使用者編号，姓名，性别，身份證号，籍貫，學院，系所，校區，部門，電話，照片

//顯示相片

object imgobj=dg[10, dg.CurrentRow.Index].Value;

if (imgobj != null && !Convert.IsDBNull(imgobj))

{

byte[] imgb = (byte[])imgobj;

MemoryStream memStream = new MemoryStream(imgb);

try

{

Bitmap myimge = new Bitmap(memStream);

this.pictureBox1.Image = myimge;

}

catch

{

DB.msgbox("從資料庫讀取相片失敗！");

}

}

else

pictureBox1.Image = null;

}

}