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:
[Code]....
View 1 Replies
Similar Messages:
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
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:
hlkmail.href="remail.aspx?clientname="&clientname
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
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
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
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
Oct 18, 2010
[Code]....
and im not getting the result i expected =
View 5 Replies
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
As
Object,
ByVal e
As System.EventArgs)Dim HeaderRow
As GridViewRow = GridView1.HeaderRowFor
Each c
As TableCell
In HeaderRow.CellsIf c.Text.EndsWith("S")
Then
c.BackColor = Drawing.Color.OrangeRed
End
If
Next
End
Sub
View 2 Replies
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
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
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
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
Oct 12, 2010
want to display gridview column heading when mouse over to the particular column in the gridview.
View 9 Replies
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:
[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
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:
[code]....
View 6 Replies
Aug 30, 2012
i have gridview in my page
<asp:TemplateField ItemStyle-Width = "25px" HeaderText = "" ItemStyle-Height="18px" HeaderStyle-Height="18px" ItemStyle-HorizontalAlign="left">
<ItemTemplate>
<asp:Label ID="lblType" runat="server" Text='<%# Eval("price") %>' ></asp:Label>
</ItemTemplate>
</asp:TemplateField>
i want if there wasn't any data in database, I want to display not found message
View 1 Replies
Mar 15, 2013
How can i but alternate Image if No image retrieve in image Control ?
View 1 Replies
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
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
Jan 12, 2013
<asp:ImageField DataImageUrlField="photo" > <ItemStyle Width="50px" Height ="50px"
HorizontalAlign="Center" VerticalAlign="Middle" ></ItemStyle>
</asp:ImageField>
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
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
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.
[Code]....
View 7 Replies
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
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
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
