Bytes to Image Conversion

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

<%@ WebHandler Language="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;
}
}
}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Laxmidhar Sahoo6y ago
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
<%@ WebHandler Language="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 R6y ago
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 Ranwa7y ago
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 Kumar7y ago
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/