Lưu Hình ảnh Vào Database | Võ Văn Hải's Blog

throw; } } } }

public MainForm() { InitializeComponent();

}

private void MainForm_Load(object sender, EventArgs e) { try { conDB = new ConnectDB(); ds = conDB.GetTable(); dtSV = ds.Tables[“tblSinhvien”]; bs = new BindingSource(ds, “tblSinhvien”); bs.CurrentItemChanged += new EventHandler(bs_CurrentItemChanged); dataGridView1.DataSource = bs; bindingNavigator1.BindingSource = bs; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } /// <summary> /// Sự kiện xảy ra khi binding source có sự thay đổi do người /// dùng chọn các dòng trên lưới hặc nhấn các nút di chuyển. /// </summary> /// <param name=”sender”></param> /// <param name=”e”></param> void bs_CurrentItemChanged(object sender, EventArgs e) { DataRowView row = (DataRowView)bs.Current; try { Byte[] i = (byte[])row[“hinhAnh”]; MemoryStream stmBLOBData = new MemoryStream(i); picHinhAnh.Image = Image.FromStream(stmBLOBData); } catch (Exception ex) { picHinhAnh.Image = null; MessageBox.Show(ex.ToString()); } }

private void btnLuu_Click(object sender, EventArgs e) { try { DataRow dr = dtSV.NewRow(); dr[“MSSV”] = txtMSSV.Text; if (picHinhAnh.Image != null) { MemoryStream ms = new MemoryStream(); picHinhAnh.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);

Byte[] bytBLOBData = new Byte[ms.Length]; ms.Position = 0; ms.Read(bytBLOBData, 0, Convert.ToInt32(ms.Length)); dr[“hinhAnh”] = bytBLOBData; dtSV.Rows.Add(dr);

conDB.UpdateSV(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }

private void btnLoadHinh_Click(object sender, EventArgs e) { OpenFileDialog dlg = new OpenFileDialog(); dlg.Filter = “JPG Files(*.JPG)|*.JPG|GIF Files(*.GIF)|*.GIF”; if (dlg.ShowDialog(this) == DialogResult.OK) { picHinhAnh.Image = Image.FromFile(dlg.FileName); } } } }

namespace AnotherWay { class ConnectDB { private SqlConnection conn; private string connectionString = “Server=.;UID=sa;PWD=;Initial Catalog=TestImageDB”;

public ConnectDB() { conn = new SqlConnection(connectionString); }

public void StorePicture(string filename) { byte[] imageData = null; // Read the file into a byte array using (FileStream fs = new FileStream(filename, FileMode.Open, FileAccess.Read)) { imageData = new Byte[fs.Length]; fs.Read(imageData, 0, (int)fs.Length); } using (SqlConnection conn = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand(“InsertImage”, conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue(“@filename”, filename); cmd.Parameters[“@filename”].Direction = ParameterDirection.Input; cmd.Parameters.Add(“@blobdata”, SqlDbType.Image); cmd.Parameters[“@blobdata”].Direction = ParameterDirection.Input; // Store the byte array within the image field cmd.Parameters[“@blobdata”].Value = imageData; conn.Open(); cmd.ExecuteNonQuery(); } }

public byte[] RetrieveImage() { byte[] imageData = null; conn.Open(); SqlCommand cmd = new SqlCommand(“select blobdata from tblImages”, conn); // Assume previously established command and connection // The command SELECTs the IMAGE column from the table

using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.SequentialAccess)) { reader.Read(); // Get size of image data – pass null as the byte array parameter long bytesize = reader.GetBytes(0, 0, null, 0, 0); // Allocate byte array to hold image data imageData = new byte[bytesize]; long bytesread = 0; int curpos = 0; int chunkSize = 1; while (bytesread < bytesize) { // chunkSize is an arbitrary application defined value bytesread += reader.GetBytes(0, curpos, imageData, curpos, chunkSize); curpos += chunkSize; } } conn.Close(); // byte array ‘imageData’ now contains BLOB from database return imageData; } } }

namespace AnotherWay { public partial class Form1 : Form { private ConnectDB conDB; public Form1() { InitializeComponent(); conDB = new ConnectDB(); }

private void button1_Click(object sender, EventArgs e) { OpenFileDialog dlg = new OpenFileDialog(); dlg.Filter = “JPG Files(*.JPG)|*.JPG|GIF Files(*.GIF)|*.GIF”; if (dlg.ShowDialog(this) == DialogResult.OK) { conDB.StorePicture(dlg.FileName); } }

private void button2_Click(object sender, EventArgs e) { byte[] img = conDB.RetrieveImage(); MemoryStream str = new MemoryStream(img); pictureBox1.Image = Image.FromStream(str); } } }