Show image in gridview.

Question

0.00/5 (No votes)

See more:

Hii i have been uploaded image using below code its working.Image path is gooing in database and image also storing in folder bt image is not displaying in gridview.How can i do.. using this code plzz edit or modify code for show image in gridview..

SqlConnection con = new SqlConnection("Data Source=DEEPAK-PC\\SQLEXPRESS;Initial Catalog=Imageup;User ID=sa;Password=sasa");
   protected void Page_Load(object sender, EventArgs e)
   {

   }

  protected void Button1_Click(object sender, EventArgs e)
   {
       if (FileUpload1.HasFile)
       {
           String str = FileUpload1.FileName;
           //FileUpload1.PostedFile.SaveAs(Server.MapPath(",") + "~//uploadedimages//" + str);


           string FileName= Path.GetFileName(FileUpload1.FileName);
           FileUpload1.SaveAs(Server.MapPath("~/uploadedimages/")+ FileName);
           string path = "~//Uploads//"+str.ToString();
           con.Open();
           SqlCommand cmd = new SqlCommand("insert into FileUploads1 values('" + TextBox1.Text + "','" + path + "')", con);
           cmd.ExecuteNonQuery();
           con.Close();
           Label1.Text = "Image upload Successfully";
       }
       else
       {
           Label1.Text = "Plz select ur image and upload";
       }
       SqlDataAdapter da = new SqlDataAdapter("select * from FileUploads1", con);
       DataTable dt = new DataTable();
       da.Fill(dt);
       GridView1.DataSource = dt;
       DataBind();



   }

Posted 7-Jan-14 23:38pm

amit1992

Add a Solution

Comments

JoCodes 8-Jan-14 5:43am

Check the file path of the image . Use the same path which you are trying to save the image. Can you show the gridview markup code too?

amit1992 8-Jan-14 5:46am

markup code for gridview..

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
CellPadding="4" ForeColor="#333333" GridLines="None">
<alternatingrowstyle backcolor="White">
<footerstyle backcolor="#990000" font-bold="True" forecolor="White">
<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
<rowstyle backcolor="#FFFBD6" forecolor="#333333">
<SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
<sortedascendingcellstyle backcolor="#FDF5AC">
<sortedascendingheaderstyle backcolor="#4D0000">
<sorteddescendingcellstyle backcolor="#FCF6C0">
<sorteddescendingheaderstyle backcolor="#820000">
<columns>
<asp:TemplateField HeaderText="uid">
<itemtemplate>
<asp:Label ID="lbl1" runat="server" >

<asp:TemplateField HeaderText="Name">
<itemtemplate>
<asp:Label ID="lbl1" runat="server" >

<asp:TemplateField HeaderText="Image">
<itemtemplate>
<asp:Image ID="img" runat="server" Height="100" Width="100" />

JoCodes 8-Jan-14 5:50am

set the imageurl property to the imaeg control . Have added a solution . check .

amit1992 8-Jan-14 5:59am

Where u added a solution plzz post in comment or refer where u added. Thnxx.

amit1992 8-Jan-14 6:11am

@jocodes i have set the imageurl property nw image is not showing properly.

JoCodes 8-Jan-14 6:42am

Have you checked the image path is correctly referred?

amit1992 8-Jan-14 6:48am

yes i have set imageurl="uimg" where uimg is coloumn name in which imagepath is stored

JoCodes 8-Jan-14 6:54am

Yeah, but can see from your code that the file saved locally and inserted into the table are different?insert the same filepath into db.

JoCodes 8-Jan-14 6:56am

Mean to say FileUpload1.SaveAs(Server.MapPath("~/uploadedimages/")+ FileName); and the "insert into FileUploads1 values('" + TextBox1.Text + "','" + path + "' differs

amit1992 8-Jan-14 6:59am

Bt image is going in db and folder both palace. and location for both part is same.

amit1992 8-Jan-14 7:05am

Code is below and till i know path is same..
------------
String str = FileUpload1.FileName;
//FileUpload1.PostedFile.SaveAs(Server.MapPath(",") + "~//uploadedimages//" + str);

string FileName= Path.GetFileName(FileUpload1.FileName);
FileUpload1.SaveAs(Server.MapPath("~/uploadedimages/")+ FileName);
string path = "~//Uploads//"+str.ToString();
con.Open();
SqlCommand cmd = new SqlCommand("insert into FileUploads1 values('" + TextBox1.Text + "','" + path + "')", con);
cmd.ExecuteNonQuery();
con.Close();
Label1.Text = "Image upload Successfully";
}
else
{
Label1.Text = "Plz select ur image and upload";
}

6 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)

Gitanjali Singh · Answer 1 · 2014-01-07T23:45:00

Solution 1

Use image handler for displaying image in gridview.
Refer :http://stackoverflow.com/questions/19132451/how-to-display-binary-images-into-a-gridview-in-asp-net-using-c[^]

Hope this will help.

Posted 7-Jan-14 23:45pm

Gitanjali Singh

Updated 7-Jan-14 23:47pm

v2

Comments

amit1992 8-Jan-14 5:50am

@Gitanjali Singh plzz tell without using image handler..

Gitanjali Singh 8-Jan-14 5:55am

Refer:http://stackoverflow.com/questions/20741343/how-to-display-image-inside-gridview-template-field-without-using-handler-class

Murali0195 · Answer 2 · 2014-01-07T23:45:00

Solution 2

hi...
See this link,may its help ful to u.
How to bind images in datalist/gridview[^]
Thank u.

Posted 7-Jan-14 23:45pm

Murali0195

JoCodes · Answer 3 · 2014-01-07T23:48:00

Refer

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

Also , check the paths are same while saving the file and inserted path to DB.

FileUpload1.SaveAs(Server.MapPath("~/uploadedimages/")+ FileName);

and the

"insert into FileUploads1 values('" + TextBox1.Text + "','" + path + "'

should be same .
Hope this helps...

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) · Answer 4 · 2014-01-08T00:17:00

Solution 4

The following is what you exactly need.

how to save images into folder and images path in database and display images from folder in gridview based on images path in database using asp.net[^]

Posted 8-Jan-14 0:17am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

TrushnaK · Answer 5 · 2014-01-08T00:24:00

refer below links:-
http://www.aspsnippets.com/articles/display-images-from-sql-server-database-in-asp.net-gridview-control.aspx[^]
http://www.c-sharpcorner.com/UploadFile/5089e0/show-image-in-gridview-using-Asp-Net/[^]
http://www.dotnettwitter.com/2011/11/how-to-show-images-in-gridview-when.html[^]

amit1992 · Answer 6 · 2014-01-08T19:06:00

Solution 6

I m getting Image path in gridview when runs the application. how can show image, not path.
plzz help me..i trie my fulll effort..bt nt success..Thnxx

Posted 8-Jan-14 19:06pm