private void BtnAddEmployee_Click(object sender, EventArgs e) { Image myImage = Image.FromFile(imgLoc); byte[] data; using (MemoryStream ms = new MemoryStream()) { myImage.Save(ms, System.Drawing.Imaging.ImageFormat.Bmp); data = ms.ToArray(); } using (SqlConnection con1 = new SqlConnection("data source=.;Initial catalog=RMSDB;user=sa;password=ibs;")) { con1.Open(); using (SqlCommand com1 = new SqlCommand("INSERT INTO Employees(Emp_Pic_ImageData) VALUES (@IM)", con1)) { com1.Parameters.AddWithValue("@IM", data); com1.ExecuteNonQuery(); } } }
string imgLoc = ""; private void BtnBrowseimage_Click(object sender, EventArgs e) { OpenFileDialog dlg = new OpenFileDialog(); dlg.Filter = "jpg All files (*.jpg)| *.jpg" + " | All Files (*.*) | *.*"; if (dlg.ShowDialog()==DialogResult.OK) { imgLoc = dlg.FileName.ToString(); PicboxEmployee.ImageLocation = imgLoc; } }
string sql = String.Format("Select Emp_Pic_ImageData From Employees where Emp_Id='{0}'", TxtBoxId.Text); SqlCommand cmd = new SqlCommand(sql, con); SqlDataReader reader = cmd.ExecuteReader(); reader.Read(); if (reader.HasRows) { byte[] img = (byte[])(reader[0]); if (img == null) { PicboxEmployee.Image = null; } else { MemoryStream mstrm = new MemoryStream(img); PicboxEmployee.Image = new System.Drawing.Bitmap(mstrm); //there is error of parameter is not valid. } } else { MessageBox.Show("this not exists"); }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)