Bytes to Image Conversion

Question

I have saved my Image in SQL SERVER in byte form and i want to show it on label in asp.net c#. I have tried a lot but unable to do. I m beginner. So please suggest

Laxmidhar Sahoo · Answer

Hi In different ways you can retrive and display .One is the best way is using aspx file the file handler extention is shx .You can add in from new Item . The example code is gine bellow Aspx file: %@ Page Language = "C#" AutoEventWireup = "true" CodeFile = "Default.aspx.cs" Inherits = "_Default" % > > html xmlns = "http://www.w3.org/1999/xhtml" > head runat = "server" > title > title > head > body > form id = "form1" runat = "server" > div > img src = "ImgHandler.ashx?ImageID=1" alt = "" /> img src = "ImgHandler.ashx?ImageID=2" alt = "" /> img src = "ImgHandler.ashx?ImageID=3" alt = "" /> img src = "ImgHandler.ashx?ImageID=4" alt = "" /> div > form > body > html > The c# code is here "C#" Class= "ImgHandler" %> using System; using System.Web; using System.Data.Sql; using System.Data.SqlClient; public class ImgHandler : IHttpHandler { public void ProcessRequest (HttpContext context) { byte [] buffer = null ; string querySqlStr = "" ; if (context.Request.QueryString[ "ImageID" ] != null ) { querySqlStr= "select * from testImageTable where ID=" +context.Request.QueryString[ "ImageID" ]; } else { querySqlStr= "select * from testImageTable" ; } SqlConnection connection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings[ "TestDataBaseConnectionString" ].ToString()); SqlCommand command = new SqlCommand(querySqlStr, connection); SqlDataReader reader = null ; try { connection.Open(); reader = command.ExecuteReader(); //get the extension name of image while (reader.Read()) { string name = reader[ "imageName" ].ToString(); int endIndex = name.LastIndexOf( '.' ); string extensionName = name.Remove(0, endIndex + 1); buffer = ( byte [])reader[ "imageContent" ]; context.Response.Clear(); context.Response.ContentType = "image/" + extensionName; context.Response.BinaryWrite(buffer); context.Response.Flush(); context.Response.Close(); } reader.Close(); } finally { connection.Close(); } } public bool IsReusable { get { return false ; } } }

Mageshwaran R · Answer

Hi, Please refer the below link, it might helps you http://csharp-video-tutorials.blogspot.com/2015/08/how-to-show-images-from-database-in.html

Sanwar Ranwa · Answer

Hello Rashid Please check these Links https://www.aspsnippets.com/Articles/Display-Images-from-SQL-Server-Database-using-ASP.Net.aspx http://csharp-video-tutorials.blogspot.com/2015/08/save-image-to-database-using-aspnet.html http://csharp-video-tutorials.blogspot.com/2015/08/load-image-from-database-in-aspnet.html http://csharp-video-tutorials.blogspot.com/2015/08/how-to-show-images-from-database-in.html

Jignesh Kumar · Answer

Hi Rashid, Please find below link which will help you, https://www.aspsnippets.com/Articles/Display-Binary-Image-from-database-in-ASPNet-GridView-control-using-C-and-VBNet.aspx https://www.c-sharpcorner.com/blogs/how-to-save-image-in-database-and-display-it-into-views-in-mvc-5 http://www.dotnettutorials.com/save-retrieve-image-cs/