Posts

Showing posts with the label Store/Retrieve image from DataBase

Store/Retrieve image from DataBase

Store Image: SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]); con.Open(); byte[] ImgBytes = new byte[flurl.PostedFile.InputStream.Length]; flurl.PostedFile.InputStream.Read(ImgBytes, 0, ImgBytes.Length); string qry = "Insert into Table1(ImageData) values(@ImageData)"; SqlCommand cmd = new SqlCommand(qry, con); cmd.Parameters.AddWithValue("@ImageData", ImgBytes); cmd.ExecuteNonQuery(); con.Close(); Retrieve Image: private string dumpImageToFile ( ref Byte[] img ) { string strTempPath = System.IO.Path.GetTempPath (); // Create the file name string strFileName = strTempPath + "\\" + ".img"; // Copy raw data to a memory stream System.IO.FileStream fs = new FileStream( strFileName, FileMode.OpenOrCreate, FileAccess.Write ); int offset = 0; fs.Write( img, offset, img.Length - offset ); // Close stream fs.Close(); fs = null; return strFileName; } catch ( System.IO.IOExcep...