Data Controls :: How To Show GridView Image Conditionally
Nov 9, 2013
For this I am using ASP.NET 4.5, C#, and Entity Framework to SQL.
I have some sections of my site where users can make multiple entries and can optionally upload attachments. There is a page where the user can see a gridview that acts as an overview of the entires. I have been asked to display a column with a paperclip icon if an attachment exists.
The way the database is structured, the table that holds the entries has columns like this:
id, schoolName, dateStarted, dateEnded, attachmentId
The attachments are in another table. For this table the attachmentId will hold an Int32 or be NULL (no attachment). My current query looks like basically like this:
var query = context.applications.Where(c => c.id == applicationPrimaryKey);
var results = result.educationUniversities.ToList();
gdvEducationUniversity.DataSource = results;
gdvEducationUniversity.DataBind();
Gridview looks like this:
<asp:GridView
ID="gdvWorkMentor"
runat="server"
AutoGenerateColumns="False"
DataKeyNames="id"
<Columns>
[Code]....
I somehow need to create a condition where an image of a paperclip is shown if the attachmentId value is not Null. Optionally I imagine the query could be re-written to return a true/false value based on if the attachmentId value is null though I'm not certain how to do this.
View 1 Replies
Similar Messages:
May 24, 2010
dv = new DataView(table);
Table.Columns.Add("ID", typeof(string));
table.Columns.Add("Type", typeof(string));
table.Columns.Add("EmpName", typeof(string));
table.Columns.Add("Manager", typeof(string));
row = table.Rows.Add();
row["ID"] = result["ID"].ToString();
row["Type"] = result["Type"].ToString();
row["EmpName"] = result["EmpName"].ToString();
row["Manager"] = result["Manager"].ToString();
Then I am adding boundfield to gridview for all 4 columns. Now I want to check if "Type" column contain "Sales" thne do not show "Manager" columns. Let me know can I do this?
View 4 Replies
Dec 5, 2013
i have a gridview, in my gridview, i have a attachment button.
when user click on the attachment button, it will direct them to EquipmentAttachment.aspx.
what i want to do right now is, if the attachment exist, then the attachment button visible, else the button attachment set to false.
View 1 Replies
Oct 17, 2013
if (!IsPostBack) {
string[] filePaths = Directory.GetFiles(Server.MapPath("~/PMRF/"));
List<ListItem> files = new List<ListItem>();
foreach (string filePath in filePaths) {
string ext = Path.GetExtension(filePath);
foreach (GridViewRow gr in GridView1.Rows)
[code]...
i want the image of image button to change according to file extension . But its not working.
View 1 Replies
Sep 30, 2010
how to show image in gridview from sql database
View 2 Replies
Sep 1, 2010
I've got this gridview with a column labeled "Client Comment" that displays a clickable little icon when there is a client comment in the database. The problem is the icon is appearing whether or not there is data in the DB (except I don' t think it does when the DB value is null.)
How can I make it so the icon only appears if there is a comment in that database field? With code behind (if so VB) or in the tag?
[Code]....
View 8 Replies
Sep 14, 2013
My grid view will display the data like below..
Id Name Mark1 Mark2 Mark3
1 aaa 50 30 20
2 bbb 50 30 30
3 ccc 50 30 20
if mark3 has all fields with 0 means i want to hide column mark3. How to do this..
View 1 Replies
Dec 19, 2012
i am using template field display image based on condition in table field. i have field name verify i used to store yes or no value if it is yes then display image else noting to display in gridview
View 1 Replies
Jan 4, 2011
i have a gridview of a list of VehicleRequisition's with a column whose itemtemplate is as follows.
[Code]....
[Code]....
View 2 Replies
Mar 11, 2014
How to update each data in gridview from template field textbox?
if select reason is adjust-In then update plus the qty else adjust -Out minus the qty.
<asp:GridView ID="GridView1" HeaderStyle-BackColor="#3A64F2" HeaderStyle-ForeColor="White" runat="server" AutoGenerateColumns="false">
<Columns>
<asp:BoundField DataField= "RowNumber" HeaderText="RowNumber" />
<asp:BoundField DataField= "INV_ID" HeaderText="INV_ID" ItemStyle-Width="150" />
<asp:BoundField DataField= "INV_TYPE" HeaderText="INV_TYPE" ItemStyle-Width="150" />
<asp:BoundField DataField= "INV_SHORTDESC" HeaderText="INV_SHORTDESC" ItemStyle-Width="150" />
<asp:BoundField DataField= "INV_LOCATION" HeaderText="INV_LOCATION" ItemStyle-Width="150" />
<asp:BoundField DataField= "INV_QTY" HeaderText="INV_QTY" ItemStyle-Width="100" />
[CODE]....
View 1 Replies
Jul 30, 2013
On Row databound i want to show some rows in If and Hide in some rows in else conditon. But it generate an exception that (Index was out of range. Must be non-negative and less than the size of the collection Parameter name: index.
protected void gvHotels_RowDataBound(object sender, GridViewRowEventArgs e)
{
DataTable dt = new DataTable();
if (e.Row.RowType == DataControlRowType.DataRow)
[code]...
View 1 Replies
Nov 21, 2013
How to redirect a page to a particular website link( links are saved in database) using database on button click, for particular DropDown value i.e, External. If dropdown value is "external", then on clicking button page should redirect to particular website link related to the above drop down. This link can differ in DB but DropDown value is same for all users i.e "External"..(these website links are saved in database, I have to fetch these links from database.
View 1 Replies
May 7, 2015
I have a gridview that contains columns of electrical specification (value, resistance, etc.). The rows are populated with archival data from previous versions of th same part (rev A, rev B, etc.).
The question is: is there any way for me to review each row and set the font color to red if the value is different from the cell below, or above? This would highlight where changes were made to each individual revision of a part from the previous version.
View 1 Replies
Apr 30, 2010
I am facing a situation where I have to disable GridView field (in EDIT mode ) conditionally.
Here is the situation,GridView has 5 fields "Product Name" "Small" " Medium" "Large" "XLarge"
Here is the problem, application has section where user activate/deactivate sizes (SMALL,MEDIUM,LARGE,XLARGE). Suppose User activates "SMALL" and "LARGE". Now When the GridView is populted normally, I don't have to disable any fields. But when the user clicks "EDIT" on GridView row, I want "MEDIUM" and "XLARGE" fields to appear as disable.
Here is what I know
1) I will have active sizes in SESSION ... in the above case (SMALL and LARGE)
2 I know I have to catch GridView_RowDataBound and then I have to check for the edit mode for the row.
Then What ?I am using templates for each field
[Code]....
View 3 Replies
Jan 9, 2010
I have created a gridview and added a headertemplate field inside templatefield. Inside header template field I have added a button and a condirmbutton extender. confirmbutton extender uses modelpopup with ok cancel. This works fine but with one problem. I want this popup to open on button click only if user has checked atleast one checkbox from gridview. So far it shows this modelpopup everytime even user hasn't checked anything.
View 2 Replies
Apr 27, 2016
How to show defalut image in datalist untill large image fully loaded in same datalist ?
View 1 Replies
Jan 31, 2011
how to show the loader image when the data is loading ?I did a sample one which is not a perfect one.Please suggest me the best way .I have a question can we use jquery or javascript?Here when i click the load the data has to load to GV in between this process the preloader has to be visible like in GMAIL.
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Loader Image While Loading Data in GV.aspx.cs"
Inherits="Loader_Image_While_Loading_Data_in_GV" %> [code]...
View 1 Replies
May 13, 2013
I have a page with a label and a textbox with two button edit and update. when the user clicks on edit the labels get hidden and text box appears. And when he clicks on update the textbox disappears and label appears I have achieved making the text box disappear and label appear but when I click on edit the textbox is not appearing ....
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class Institute : System.Web.UI.Page {
[Code] ....
View 1 Replies
Jun 19, 2012
[URL].... I got correct code .. but image is not stable on mouse over.... little bit flying...
and on mouse out still previous image will display.....
Requirement:
I have grid with some product details.. like product id ,price,description. on mouse over of each row. should display a image of particular product thumb nail..
View 1 Replies
Jul 19, 2013
I have One Dropdownlist in that index is 1 2 3 4, when i select index 3 then panal will be visible
View 1 Replies
Mar 24, 2011
Using ASP.NET MVC 2, I have a model for a view. The view has a dropdownlist of roles that is populated by the model and there is a list below that of checkboxes with a number of privileges. I want to show only specific privileges depending on the dropdownlist selected roleID and have it update the privileges everytime the dropdownlist changes. I know how to do this in web forms ASP.net with absolutely no problem but I cannot seem to figure out where to start in ASP.NET MVC. Can someone please advise me what I need to do or towards a tutorial that will show me what to do? I am a novice in MVC.
View 2 Replies
Jul 19, 2010
I get pic and data from database using data list , and want to know to show up image in box with any larger size when mouse over the pic this pic show image i want and code
View 3 Replies
Dec 28, 2010
How can I save image in db as byte array and show the saved image as slide show in my web page with C# asp.net 3.5
View 1 Replies
May 22, 2010
i have images stored in database and i have to show it in a web page thru datagridview
View 1 Replies
Oct 25, 2010
I want to show a image in panel below datagrid if I select particular row.I want to highlite that row in a diff color.
View 3 Replies