Display Image In Gridview Depending On Value Of Column?

Dec 2, 2010

I have a gridview which displays rows and columns all linked to an sql statement... and all works as normal.

I want to include a new column, that displays an image depending on what the value of the column is. If the column has a value - it will display an image. If the column value is null no image whill be displayed.

My sql is something like:

SELECT c.call_id, title, a.call_id as b_attach
FROM calls c
LEFT JOIN attachments a ON c.call_id = a.call_id
GROUP BY c.call_id,title,description, a.call_id

What's returns from this sql is:

Call_id | title | b_attach
1235 | title goes here | 1235
1382 | another title |NULL

So if there's something in b_attach - diplay image in gridview column, else display nothing in gridview column

My Gridview:


View 1 Replies

Similar Messages:

Forms Data Controls :: Display An Icon Image In Gridview Depending On The Returned Data

Aug 13, 2010

I have a gridview and would like to display one of 5 icons depending on the value returned from the database for that row (simply just A, B, C, D or E). Which event in my datagrid should I be looking at to check what value I'm getting? I presume once I can check a value I can simply set an image source using if statements?

View 4 Replies

Web Forms :: Display Image (im1/img2) Depending Upon Db Value?

Dec 27, 2010

i have a database with a field for 'hasimage' with values true/false.

if it is true i want to display img1 and if false i want to display img2.

currently i have a single static image which takes user to the url.

code aspx:

<a runat="server" id="hlkmail">
<img src="../images/send_mail_icon.jpg" alt="" /></a>
<a>Send<br /> Mail</a>

code aspx.vb:


now, i want to use the db value and accordingly display img1 / img2, onclick of which will take the user to the url.

View 5 Replies

Web Forms :: How To Display Image Depending Upon Db Field Value

Dec 29, 2010

this is my aspx page code :

<a runat="server" id="hlkmail"><img src="../images/send_mail_icon.jpg" alt="" /></a>
<a runat="server" id="hlkgallery"><img src="../images/galleryl_icon.jpg" alt="" /></a>

this is code behind (aspx.vb) :

hlkmail.HRef = "sndmail.aspx?Clientname=" & clientName
hlkgallery.HRef = "pgallery.aspx?Clientname=" & clientName

above code shows fixed images.

i want to display image dynamiccally depending upon the db value.

i have a stored proc that returns hasmail ='true/false' and hasgallery='true/false' from database.

if true i want to display send_mail_icon.jpg else send_mail_icon_watermark.jpg

and gallery_icon else gallery_icon_watermark.jpg. i want to do this in code behind using if loop.

View 7 Replies

Forms Data Controls :: How To Update Row On Editable Gridview Depending On Two Column

Jun 29, 2010

Solved like this

currentID = Convert.ToInt32(GridView_ABC.DataKeys[0].Values[0]);
activityName = Convert.ToString(GridView_ABC.DataKeys[1].Values[1]);
DataRow row =
originalDataTable.Select(String.Format("EmployeeID = {0} AND ActivityName = '{1}'", currentID, activityName))[0];

View 1 Replies

Change An Individual Image In A Gridview Depending On A Value?

Mar 5, 2011

i have 2 tables assignment and feedback, in a gridview it displays all the assignments, the assignments then get feedback. im then wanting to change the view feedback button in the gridview depending on if there is new feedback for example:

the feedback table has a state field in it so when its 1 i want that image button to change to the one with the +

View 1 Replies

Forms Data Controls :: Gridview Column Changing Visibility Depending On A Row.text?

Oct 18, 2010


and im not getting the result i expected =

View 5 Replies

Forms Data Controls :: Gridview Column Formatting Depending On Text In Header?

Mar 30, 2010

I want if the header of a particular column contains a word "S", the header and row turns red. I used following code to make header red and it works fine. How to make it such that the rows also turn red if condition is met ? I cannot hardcode in columns since the Gridview is autogenerate colums as data structure keeps changing.

Protected Sub GridView1_DataBound(ByVal sender
ByVal e
As System.EventArgs)Dim HeaderRow
As GridViewRow = GridView1.HeaderRowFor
Each c
As TableCell
In HeaderRow.CellsIf c.Text.EndsWith("S")
c.BackColor = Drawing.Color.OrangeRed

View 2 Replies

Forms Data Controls :: TemplateField Change Itemtemplate Label CSS Depending On Column Value For Each Row In Gridview?

Jan 28, 2011

I was wondering if anyone could help me. I have a template field which has four itemtemplates that each hold a label in a gridview. These labels are always constant with the same strings. What I want to do is change the css formatting of these four labels depending on the value of a column. So the css formatting would have to be done for each row, not the whole column. I bind the gridview to a dataaccesslayer so there is no sqldatasource on the page. Does anyone have any idea how to do this and where it would be done. I will have the dataview with the data sorted in the correct order. The actual column that is used to alter the CSS will not be in the gridview although I could assign it to the datakeyname if that makes it easier as the data is not sensitive.

View 1 Replies

Data Controls :: How To Read Bytes From Image Column Field And Display As Image

May 7, 2015

My query is that I have an sql field for image with db type "Image" , now I have successfully inserted some images in the form of bytes, now how to read those bytes of image from database and convert, show in gridview?

View 1 Replies

Forms Data Controls :: >>>want To Display Gridview Column Heading When Mouse Over To The Particular Column In The Gridview?

Oct 12, 2010

I want to display gridview column heading when mouse over to the particular column in the gridview.I am working in VisualStudio 2005 with MS.Net2.0 framework.I don't want to use ajax.

View 4 Replies

Data Controls :: Rotate GridView Rows Into Column With Image Column

Apr 27, 2016

I saw post [URL] .... which is converting rows into column item,quantity ,price. I have one other image field .how can bind image in this program?

View 1 Replies

Forms Data Controls :: >>>Display Gridview Column Heading When MouseOver On Particular Column?

Oct 12, 2010

want to display gridview column heading when mouse over to the particular column in the gridview.

View 9 Replies

Forms Data Controls :: Display Text In 2 Rows And Then A Gridview Column - Third Row Is Displayed As A Row Under First Column

Jul 14, 2010

I have a gridview with 3 columns. In second column I want to display some text in 2 rows and then a gridview.
Here is my code:


The problem is my third row is displayed as a row under first column. How do I make it a separate column in my girdview. Not sure what is going wrong.

View 11 Replies

VS 2008 Image In GridView / Display Images In The Gridview From The Image Folder

Jul 25, 2010

I have a folder named img containing some images:

I want to display images in the Gridview from the image folder in this way:

But without saving the image location in the Database (i.e;i want to do this using the System.IO)

I can fetch the names of all the images present in the "img" folder but my problem is i cant set the src of the <img> tag properly which would display the image here is what i did:


View 6 Replies

Data Controls :: Display Default Image (NotFound) When Image Does Not Exist In GridView?

Aug 30, 2012

i have gridview in my page

<asp:TemplateField ItemStyle-Width = "25px" HeaderText = "" ItemStyle-Height="18px" HeaderStyle-Height="18px" ItemStyle-HorizontalAlign="left">
<asp:Label ID="lblType" runat="server" Text='<%# Eval("price") %>' ></asp:Label>

i want if there wasn't any data in database, I want to display not found message

View 1 Replies

Data Controls :: Display Alternate Image If Image Is Not Present In GridView

Mar 15, 2013

How can i but alternate Image if No image retrieve  in image Control  ? 

View 1 Replies

Data Controls :: Display GridView Selected Row Image In Image Control

Dec 3, 2013

My file path in which I have stored image will be like this "C:Documents and SettingssureshDesktopRegIR_NEWRegIRinDebug....Images8-Q-IMG.jpg".

This file path will be diaplayed in Gridview and I have made "Auto Generate Select Button - True" in Gridview.

Is it possible to get the image in image control by using this file path on the click of "SELECT" option in gridview.

My running this application on a remote server.

View 1 Replies

Data Controls :: Display Image In Image Control When LinkButton Inside GridView Is Clicked?

Aug 18, 2015

i have added a hyperlink in the gridview and i am displaying the image names in the grid as hyperlinks

when i click on the hyperlink in the grid, the related image has to be displayed in the same page but in another div which is next to gridview

but for me ,image is displaying in another page

View 1 Replies

Data Controls :: Display Image In GridView With Path In Database With Image Enlarge Option?

Jan 12, 2013

<asp:ImageField DataImageUrlField="photo" > <ItemStyle Width="50px" Height ="50px"
HorizontalAlign="Center" VerticalAlign="Middle" ></ItemStyle>

i need to display image from database in gridview.  i have the above html and a select query executed from code behind which displays the image.

i am storing the image path in the database table and image in a folder.

Queries related to above

1. image size not able to set

2. the gridview image column will display image if the column data is not blank. but if its blank i have 2 default images  male image and female image

so if the field is blank i need to display one of the default images depending on the gender selected
3. if the image is clicked it should show enlarged image as popup 

View 1 Replies

Web Forms :: Display Thumbnail Image In DataList Image Gallery And OnClick Display Original Image

Oct 12, 2012

I need to develop image gallery

Image saved in Folder called Images and image Name , Description saved in Database Table Images.

On Deafault.aspx

Thubnail images should display with out any change in Quality i.e by DataList Control

On Click of Thubnail images Fullview of image with width and height same as image width and height   
Next, Previous, Close Buttons on Popup window

View 1 Replies

Forms Data Controls :: Display Default Image When Image (file) Not Found GridView - ImageField

Mar 26, 2010

I have a page which displays details and a pictures of employees. The details are stored in a SQL database and the images are on the server. How can I set a default Image to display (e.g. an Image saying "Awaiting Image") if an employee picture is missing?

I can't use NullImageUrl as the Images are not stored in the database. I can't use the solution found on [URL] as an ImageField does not accept an ID attribute.


View 7 Replies

Forms Data Controls :: Gridview - Display A Image Button To Display Date

Sep 7, 2010

i have a gridview binded with data when i hover mouse to row i want to display a image button to display date ,and when i click the button i want to display calender control for choose date, and next step after i choose date it will be must insert into database. and mean while a hidden label control will display and date shuld be display in it

View 2 Replies

Data Controls :: Display Image Thumbnail From Database In GridView And Display Enlarged Popup

May 7, 2015

After saving image in db how can we retrieve it in gridview like thumbnail size image and by clicking on image in gridview its open as preview. How can we do this in asp.net using c#.

View 1 Replies

SQL Server :: Dynamic Nullable Columns Depending On The Value Of A Column?

Feb 11, 2011

I have a master document which is composed of other document types (some are required and some are not). While the master document's status is "Draft" I need to ignore all not nullable constraints (because the writer may decide to work on one of the children
documents that is not required and save as draft).

The closest solution I found for this problem is check constraints but I have not yet to see an example of this in check contraint and I'm not even sure if this is possible. Has anyone implemented a similar solution with check constraints (or any other methods)?

View 2 Replies

Copyrights 2005-15 www.BigResource.com, All rights reserved