{"id":2712,"date":"2018-05-17T16:36:45","date_gmt":"2018-05-17T14:36:45","guid":{"rendered":"http:\/\/www.capri-soft.de\/blog\/?p=2712"},"modified":"2018-06-07T08:30:47","modified_gmt":"2018-06-07T06:30:47","slug":"asp-net-sparx-systems-enterprise-architect-read-binary-image-from-database-blob-and-show-display-it-on-a-webpage","status":"publish","type":"post","link":"https:\/\/www.capri-soft.de\/blog\/?p=2712","title":{"rendered":"ASP.NET \/ Sparx Systems Enterprise Architect : Read binary Image from Database ( BLOB ) and show \/ display it on a webpage"},"content":{"rendered":"

Problem<\/h1>\n

A binary picture that has been saved in a database or an Access File (i.e. of the Sparx Systems Enterprise Architect) shall be displayed on a web page.<\/p>\n

Approach<\/h1>\n
    \n
  1. Create a new ASP.NET Webform and name it GetImage.aspx<\/li>\n
  2. Go to the Page_Load function in it<\/li>\n
  3. Paste the code under solution in the area in customize according your data structure (here it is Sparx EA).<\/li>\n
  4. Create a img-Tag in HTML, that has a src-Attribute pointing to that webpage with a get parameter img={your image id}<\/li>\n
  5. Use Response.BinaryWrite in the way shown below<\/li>\n<\/ol>\n

    Solution<\/h1>\n
    \r\nusing System;\r\nusing System.Collections.Generic;\r\nusing System.Data.OleDb;\r\nusing System.Linq;\r\nusing System.Web;\r\nusing System.Web.UI;\r\nusing System.Web.UI.WebControls;\r\n\r\npublic partial class GetImage : System.Web.UI.Page\r\n{\r\n    \/\/ Mit folgender URL Kann ein Bild nun rausgeladen werden \r\n    \/\/ http:\/\/localhost:51241\/GetImage.aspx?img=343868582\r\n    \/\/ und entsprechend in HTML \u00fcber den Image-Tag geladen werden:\r\n    \/\/ <img src="GetImage.aspx?img=343868582" \/>\r\n    protected void Page_Load(object sender, EventArgs e)\r\n    {\r\n        string sqlStatement = @"\r\n            SELECT Image \r\n            FROM t_image \r\n            WHERE ImageID={ImageID}         \r\n        ";\r\n\r\n        sqlStatement = sqlStatement.Replace("{ImageID}", Request.QueryString["img"].Trim());\r\n\r\n        OleDbConnection conn = new OleDbConnection(MyConfigurationManager.eapFilePath);\r\n\r\n        try\r\n        {\r\n            conn.Open();\r\n            OleDbCommand comm = new OleDbCommand();\r\n            comm.Connection = conn;\r\n            comm.CommandText = sqlStatement;\r\n\r\n            OleDbDataReader reader = comm.ExecuteReader();\r\n\r\n            while (reader.Read())\r\n            {\r\n                Response.ContentType = "image\/jpeg"; \/\/ if your image is a jpeg of course\r\n                Response.BinaryWrite((byte[])reader.GetValue(0));\r\n            }\r\n        }\r\n        catch (Exception ex)\r\n        {\r\n            \/\/return e.Message;\r\n        }\r\n        finally\r\n        {\r\n            conn.Close();\r\n        }\r\n    }\r\n}\r\n<\/pre>\n