How to Retrive the Image from SQL db by using file path

Question

0.00/5 (No votes)

See more:

hi friends,

iam doing stroing and retriveing the images from database and display in th gridview control
please refer the following URL

RETRIEVE IMAGES USING A FILE PATH STORED IN DATABASE IN ASP.NET

Now my Problem is not getting the image into girdview from database.could you any one can help me friends.

Regards
Krishna

Posted 22-Dec-13 18:45pm

Member 10453510

Updated 22-Dec-13 21:40pm

v4

Add a Solution

Comments

Ganesh KP 23-Dec-13 1:15am

I think u are saving relative path in your database (like images/file name...) and when u retrieve the file path from the database, check with the absolute path (like YourprojectDirectory/ImagesFoldername/Filename) and check in your windows explorer. if the image is shown opened in your folder then I think it is wokring if it not showing, then there is a problem with your image path.

try that and let us know.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

JR009 · Answer 1 · 2013-12-22T19:10:00

Solution 2

Please refer the following article :
http://www.aspdotnet-suresh.com/2011/03/how-to-save-images-into-folder-and.html[^]

Posted 22-Dec-13 19:10pm

JR009

Comments

Member 10453510 23-Dec-13 1:33am

Still it is not getting.... i could not understand where the problem is occured but there is no buks are rised in .aspx file and .aspx.cs file could you please help me for solve this problem.

and this is my .aspx.cs file

SqlConnection con=new SqlConnection(cs);
SqlDataAdapter da =new SqlDataAdapter("select * from Images",con);
DataTable dt=new DataTable();
da.Fill(dt);
GridView1.DataSource=dt;
GridView1.DataBind();

JR009 23-Dec-13 2:22am

hey friend,
check your database table and its fields datatypes. Also check the file path of the stored images in the database table.

Jignesh Khant · Answer 2 · 2013-12-22T18:56:00

Solution 1

<asp:TemplateField HeaderText="Client Image">
<ItemTemplate>
<asp:Image ID="Image1" ImageUrl='<%#Eval("client_image_url") %>' Width="100"
Height="100" runat="server" />
</ItemTemplate>
</asp:TemplateField>

Here client_image_url is your database field which contains image path.

Posted 22-Dec-13 18:56pm

Jignesh Khant

Comments

Member 10453510 23-Dec-13 1:15am

hi..
Still it is not getting

this is my aspx code for gidview

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
<columns> .
.

<asp:TemplateField HeaderText="ID">
<itemteplate>
<asp:Image ID="image" ImageUrl='<%#Eval("FilePath")%>' runnat="server">

but still it is not working

Jignesh Khant 23-Dec-13 1:32am

Try putting it inside ItemTemplate like this:

<asp:TemplateField HeaderText="ID">
<itemtemplate>
<asp:Image ID="image" ImageUrl='<%#Eval("FilePath")%>' runnat="server"/>

Member 10453510 23-Dec-13 1:46am

Ya already tried but not getting