圖片上傳讀取代碼

標籤：

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.IO;
using System.Data.SqlClient;

namespace XuanKeForm
{
public partial class FormImage : Form
{
public FormImage()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)
{
openFileDialog1.Filter = "*jpg|*.jpg|*bmp|*.bmp|*gif|*.gif";
DialogResult dia = openFileDialog1.ShowDialog();
if (dia == DialogResult.OK)
{
string filename = openFileDialog1.FileName;

FileStream fs = new FileStream(filename,FileMode.Open,FileAccess.Read);//將圖片讀入流中
byte[] imagebytes = new byte[fs.Length];//位元組，用以臨時儲存映像的二進位編碼
BinaryReader br = new BinaryReader(fs);//二進位讀取器
imagebytes = br.ReadBytes(Convert.ToInt32(fs.Length));//將圖片讀入到位元組中

//開始串連資料庫存入資料庫中
SqlConnection conn = new SqlConnection("server=.;database=schoolData;user=sa;pwd=");
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "insert into tutable values(@image)";
cmd.Parameters.Clear();
cmd.Parameters.Add("@image",imagebytes);
cmd.ExecuteNonQuery();
conn.Close();
MessageBox.Show("圖片上傳成功");

}
}

//讀取
private void button2_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("server=.;database=schoolData;user=sa;pwd=");
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "select top 1 *from tutable";
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();
byte[] imgbytes = (byte[])dr["tuxiang"];
//將映像寫入記憶體
MemoryStream ms = new MemoryStream(imgbytes, 0, imgbytes.Length);
ms.Write(imgbytes, 0, imgbytes.Length);

Image img = Image.FromStream(ms);

this.pictureBox1.SizeMode = PictureBoxSizeMode.Zoom;
this.pictureBox1.Image = img;
}
}
}

圖片上傳讀取代碼