How to display image in Gridview Based on Text displayed from Database

Question

0.00/5 (No votes)

See more:

hi frnds,

How to display image in Gridview Based on Text displayed from Database (From Images Folder)

am working on asp.net C# and Sqlserver 2005.

presently am working on Gridview.
In Solution explorer i have images folder

I have a database with TableName(TravelDetails) with fields as
TrainCode,Train_Desc,Sch_Time,From,To

My record will look like this in Gridview as per database columns as above.

T6932 | Manmad Express | 1100 | Hyderabad | Mumbai

So, Instead of Manmad Express text I need to display logo of ManmadExpress. Which is in Images Folder.

So, we need to write code in RowDataBound as

C#

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) {
        if(e.Row.RowType == DataControlRowType.DataRow)
        {
            
        }

Please can you help me how to do this?

Thanks.

Posted 9-Feb-14 20:12pm

HYD Webdeveloper

Add a Solution

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)

Prasad Avunoori · Answer 1 · 2014-02-09T20:18:00

Solution 1

Hello Hyderabadi,

First you need to store the path of the images in the same Sql Table. Then

XML

<asp:TemplateField HeaderText="Train">
                                              <ItemTemplate>
                                                  <asp:Image ID="trainImage" Width="60px" Height="50px" runat="server" ImageUrl='<%#Eval("ImageURL") %>' />
                                              </ItemTemplate>
                                          </asp:TemplateField>

No need of using GridView1_RowDataBound.

Posted 9-Feb-14 20:18pm

Prasad Avunoori

Updated 9-Feb-14 20:19pm

v2

Comments

HYD Webdeveloper 10-Feb-14 2:23am

Sir, I am Just Retrieving data using sql query in code behind, am not using Template fields in gridview.PLEASE HELP.

Prasad Avunoori 10-Feb-14 2:35am

You need add one more column to your Table which stores the path of the specific images.

HYD Webdeveloper 10-Feb-14 2:43am

Ok sir, I have added as columnname as Images in Table.. Now how to give the path

Prasad Avunoori 10-Feb-14 4:13am

1. Update that field with actual location of the image
2. Modifie your select query as follow
Select TrainCode,Train_Desc,Sch_Time,From,Tom,Images as ImageURL From <TableName>.

OPees · Answer 2 · 2014-02-09T21:53:00

try like this..

C#

<asp:gridview id="gvTraininfo" runat="server" xmlns:asp="#unknown">
    AutoGenerateColumns="False"  
    GridLines="None"  
    AllowPaging="true"  
    CssClass="mGrid"  
    AlternatingRowStyle-CssClass="alt">  
    <columns>  
        <asp:boundfield datafield="TrainCode" headertext="TrainCode" />  
        <asp:boundfield datafield="Train_Desc" headertext="Train_Desc" />  
        <asp:boundfield datafield="Sch_Time" headertext="Sch_Time" /> 
        <asp:templatefield headertext="Image" itemstyle-horizontalalign="Center">
        <itemtemplate>
            <asp:imagebutton id="ImageButton1" runat="server">
            ImageUrl='<%# Eval("fldImageUrl")%>' Width="50px"
            Height="50px" Style="cursor: pointer"
          />
        </asp:imagebutton></itemtemplate>
    </asp:templatefield>  
      
    </columns>  
</asp:gridview>

and use SQL Select Statement like this

SQL

Select TrainCode,Train_Desc,Train_Desc,From,To,'c:/images/'+'logo.jpg' as fldImageUrl from table