Lưu File Ảnh Vào Sql Server

throw;

public MainForm()InitializeComponent();

private void MainForm_Load(object sender, EventArgs e)tryconDB = 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());/// /// Sự kiện xảy ra lúc binding source bao gồm sự biến đổi do người/// cần sử dụng lựa chọn các cái trên lưới hặc nhấn những nút dịch chuyển./// /// /// void bs_CurrentItemChanged(object sender, EventArgs e)DataRowView row = (DataRowView)bs.Current;tryByte<> 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)tryDataRow 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.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)*.JPG

namespace AnotherWayclass ConnectDBprivate 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 arrayusing (FileStream fs = new FileStream(filename, FileMode.xuất hiện, FileAccess.Read))imageData = new Byte;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(“
blobdata”>.Direction = ParameterDirection.Input;// Store the byte array within the image fieldcmd.Parameters<“
blobdata”>.Value = imageData;conn.Open();cmd.ExecuteNonQuery();

public byte<> RetrieveImage()byte<> imageData = null;conn.Open();SqlCommvà cmd = new SqlCommand(“select blobdata from tblImages”, conn);// Assume previously established commvà và connection// The command SELECTs the IMAGE column from the table

using (SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.SequentialAccess))reader.Read();// Get form size of image data – pass null as the byte array parameterlong bytekích thước = reader.GetBytes(0, 0, null, 0, 0);// Allocate byte array to lớn hold image dataimageData = new byte;long bytesread = 0;int curpos = 0;int chunkSize = 1;while (bytesread // chunkSize is an arbitrary application defined valuebytesread += reader.GetBytes(0, curpos, imageData, curpos, chunkSize);curpos += chunkSize;conn.Close();// byte array ‘imageData’ now contains BLOB from databasereturn imageData;

namespace AnotherWaypublic partial class Form1 : Formprivate ConnectDB conDB;public Form1()InitializeComponent();conDB = new ConnectDB();

private void button1_Click(object sender, EventArgs e)GIF Files(*.GIF)

private void button2_Click(object sender, EventArgs e)byte<> img = conDB.RetrieveImage();MemoryStream str = new MemoryStream(img);pictureBox1.Image = Image.FromStream(str);