while retrieving image in byte format from SQL table it is previewing but encripted symbols are also showing top of my web page rdRead Session34id34 rd34id34ToString ccnameText rd34CustomerName34ToString ffnameText rd34FathersName34ToString ddobText rd34Dob34ToString ggenderText rd34Sex34ToString

Display Binary Image from database using Generic Handler in ASP.Net

Dev@KKM

SOLVED CLOSED ACTIVE ANSWERED
User: Dev@KKM
Posted: on Jul 02, 2019 04:16 AM
Forum: ASP.Net Web Forms
Replies: 5
Views: 3989
Sample Code: Download

while retrieving image in byte format from SQL table it is previewing but encripted symbols are also showing @ top of my web page

                    rd.Read();

                    Session["id"] = rd["id"].ToString();
                    ccname.Text = rd["CustomerName"].ToString();
                    ffname.Text = rd["FathersName"].ToString();
                    ddob.Text = rd["Dob"].ToString();
                    ggender.Text = rd["Sex"].ToString();
                    ooccupation.Text = rd["Occupation"].ToString();
                    mmnumber.Text = rd["MobileNumber"].ToString();
                    almnumber.Text = rd["alternativemobilenumber"].ToString();
                    llnumber.Text = rd["LandLineNumber"].ToString();
                    pproof.Text = rd["IdProof"].ToString();
                    iidnum.Text = rd["IdNumber"].ToString();
                    aaddress.Text = rd["Address"].ToString();
                    ccity.Text = rd["City"].ToString();
                    rReference.Text = rd["Reference"].ToString();
                    rrefrelation.Text = rd["ReferenceRelationship"].ToString();

                    Context.Response.BinaryWrite((Byte[])rd[rd.GetOrdinal("Photo")]);


                    rd.Close();

i have tried this method to retrive my image from sql server with the help of store procedure but i could't find an solution is there any changes in my syntax pls give me some suggestion

byte[] bytes = ((byte[])rd["Photo"]);
string imageSource = string.Format("/CustomerImage.ashx?id={0}&id={1}", Session["id"], "{0}");
string strBase64 = Convert.ToBase64String(bytes);
photo.ImageUrl = string.Format(imageSource, strBase64);
con.Close();

Download FREE API for Word, Excel and PDF in ASP.Net

pandeyis...

0 3

Reply
User: pandeyism
Replied: on Jul 02, 2019 05:31 AM
Report

Hi Dev@KKM,

I checked the code is working as you can see below smaple code.

May be your data is not proper for that reason image coming in inappropriate format or encrypted format.

Namespaces

using System.Data.SqlClient;
using System.Configuration;

VB.Net

Imports System.Data.SqlClient
Imports System.Configuration

Code

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
        SqlConnection con = new SqlConnection(constr);
        SqlCommand cmd = new SqlCommand("SELECT Name,Data FROM tblfiles", con);
        con.Open();
        SqlDataReader dr = cmd.ExecuteReader();
        if (dr.Read())
        {
            Context.Response.BinaryWrite((Byte[])dr["Data"]);
        }
        con.Close();
    }
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
    If Not Me.IsPostBack Then
        Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
        Dim con As SqlConnection = New SqlConnection(constr)
        Dim cmd As SqlCommand = New SqlCommand("SELECT Name,Data FROM tblfiles", con)
        con.Open()
        Dim dr As SqlDataReader = cmd.ExecuteReader()

        If dr.Read() Then
            Context.Response.BinaryWrite(CType(dr("Data"), Byte()))
        End If

        con.Close()
    End If
End Sub

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Display Binary Image from database using Generic Handler in ASP.Net

Company

Explore

Follow us

Contact Us