how to retrieve image from db

yadagiri uppari

13y1.7k.NET

I am displaying sme images...some of them are displaying half part..some of them not displaying....

pls solve this

aspx:

html xmlns="http://www.w3.org/1999/xhtml" >

<%----%>

Select file to save into the database:

Text="Save to the database" onclientclick="return validate();" />

onclick="Button1_Click" />

<%--

--%>

Height="200px" Width="200px" Visible="true"/>

<%--

--%>

codebehind:

protected void Button1_Click(object sender, EventArgs e)

{

ImID1.ImageUrl = "Handler.ashx?imgFromDB=" + Session["id"];

}

handler.ashx:

<%@ WebHandler Language="C#" Class="Handler" %>

using System;

using System.Web;

using System.Data.SqlClient;

using System.Configuration;

using eBizLink_DAL;

using eBizLink_BLL;

//using System.Collections;

public class Handler : IHttpHandler

{

public void ProcessRequest(HttpContext context)

{

SqlDataReader dr = null;

string image = "";

if (context.Request.QueryString["imgFromDB"] != null)

image = (context.Request.QueryString["imgFromDB"]).ToString();

//string image = Session["ConnMemID"];

if (image != "")

{

SqlConnection connection = new SqlConnection();

connection.ConnectionString = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;

connection.Open();

SqlCommand command = new SqlCommand("select top(1) Image from tbl_Images where MemId=5 order by ImgId desc", connection);

dr = command.ExecuteReader();

if (dr.HasRows)

{

while (dr.Read())

{

context.Response.BinaryWrite((byte[])dr["Image"]);

context.Response.Flush();

context.Response.End();

//SqlDataReader dr = null;

//dr = SqlHelper.ExecuteReader(CommonSetting.GetConnectionString(true), CommandType.StoredProcedure, "sp_getImg");

//if (dr.Read())

//{

// Response.BinaryWrite((byte[])dr["Image"]);

}

else

{

context.Response.WriteFile("Images/default-profile.jpg");

context.Response.End();

}

connection.Close();

}

public bool IsReusable

{

get

{

return false;

}

6 Replies

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

Sanjay Kumar13y ago
Hi

file uplode larger size
web.config

Height="" Width="" set you
ref..link
http://www.aspdotnet-suresh.com/2011/05/how-to-resize-size-image-without-losing.html

0
Pankaj Kumar13y ago
try this code:

http://www.aspdotnet-suresh.com/2011/01/how-to-insert-images-into-database-and.html
0
yadagiri uppari13y ago
sir thank u fr ur reply...but i tried like that...not coming....
the problem is cmng fr larger images...so hw reduce size of an image sir without lose quality
0
Sanjay Kumar13y ago
try

<asp:Image ID="Image1" runat="server" ImageUrl='<%# Bind("Image")%>' />
0
yadagiri uppari13y ago
sir i uploaded fine...bt i am not displaying img from db....some images are displaying(less size)....some images are displaying half(larger size)....hw to solve
0
Sanjay Kumar13y ago
Hi

CREATE INSERT PROCEDURE IMAGE UPLODE

FileUpload1
<asp:FileUpload ID="fileuploadimages" runat="server" />
string fu, path;
if (fileuploadimages.PostedFile.ContentLength > 0)
{
fu= Path.GetFileName(fileuploadimages.FileName);
path = Server.MapPath("UploadFile") + "/" + fu;
fileuploadimages.SaveAs(path);
}
<asp:Image ID="Image1" runat="server" ImageUrl='<%# Bind("Image")%>' Height="50px" Width="50px" />

SqlConnection con = new SqlConnection(strConnString);
SqlCommand cmd = new SqlCommand("select image from TABLENAME where UserName='" + Session["UserName"] + "'", con);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Image1.ImageUrl = "/UploadFile/" + dr[0].ToString();
Image1.Visible = true;
}
con.Close();

0