Forms Data Controls :: Display A Standard Picture On The GridView Field
Jul 19, 2010
I do have the following code for for a GridViewd that display pictures that are stored in a file. I am using AutoNumber(GUID) from the database to name the pictures before I stored them to the file. I can save up to 4 pictures using the same AutoNumber but adding these ending to it, Pic1, Pic2, Pic3 ,,,,etc.
The problem that I am having is that after I get the AutoNumber from the database, I want to display a standard picture on the GridView field if there is not particular picture associiated to this record in file. The name of the standard picture is located in the same file under the name of NoPicture.gif. How can I do this? So far this is my GridView code and it is working fine:
<
asp:GridView
ID="PublicClassifiedsSamplesGridView"
runat="server"
AutoGenerateColumns="False"
DataKeyNames="AutoNumber"
DataSourceID="PublicClassifiedsSamplesSqlDataSource"
CellPadding="4"
ForeColor="#333333"
OnDataBound="PublicClassifiedsSamplesGridView_DataBound"
>
<Columns>
<asp:TemplateField
HeaderText="Click for information">
<ItemTemplate>
<asp:ImageButton
ID="ThumbNailImageButton"
runat="server" Width="100px"
PostBackUrl='<%# string.Concat("~/Classifieds/DetailPage.aspx?AutoNumber=",Convert.ToString(Eval("AutoNumber")),"&FlagForm=NoSubmitted")
%>'
ImageUrl='<%# string.Concat("~/UploadedImagesClassifieds/",Convert.ToString(Eval("AutoNumber")),"Pic1.jpg")
%>'
/>
</ItemTemplate>
<ItemStyle
HorizontalAlign="Center"
Width="100px"
/>
</asp:TemplateField>
<custom:LongTextField
DataField="TListingComment"
Width="150px"
Height="70px"
HeaderText="Listing Comment"
HtmlEncode="false"
/>
</Columns>
</asp:GridView>
View 15 Replies
Similar Messages:
Jul 20, 2010
I had a problem before with GridView displaying picture and it was solve as post [URL] shows. I am trying to apply the same coding to another GridView with a different configuration and I am having a hard time making the adaptation. May someone take a look at it. What I am trying to add to this GridView is code as:
DataImageUrlFormatStringl='<%# IIF(System.IO.File.Exists(Server.MapPath(string.Format("~/UploadedImagesClassifieds/{0}{1}", Eval("AutoNumber"), "Pic1.jpg"))), string.Format("~/UploadedImagesClassifieds/{0}{1}", Eval("AutoNumber"), "Pic1.jpg"), "~/UploadedImagesClassifieds/NoPicture.gif")
%>'
And the GridView code is the following at the present time:
<
asp:GridView
ID="ClassifiedsDisplayGridView"
runat="server"
DataSourceID="srcClassifieds"
AutoGenerateColumns="False"
CellPadding="4"
ForeColor="#333333"
AllowPaging="True"
PageSize="100"
EnableSortingAndPagingCallbacks="true"
>
<Columns>
<asp:ImageField
DataImageUrlField="AutoNumber"
DataImageUrlFormatString="~/UploadedImagesClassifieds/{0}Pic1.jpg"
HeaderText="Picture"
ReadOnly="True"
>
<ControlStyle
Height="50px"
/>
</asp:ImageField>
<asp:BoundField
DataField="Category"
HeaderText="Category"
/>
<asp:HyperLinkField
DataNavigateUrlFields="AutoNumber"
DataNavigateUrlFormatString="~/Classifieds/DetailPage.aspx?AutoNumber={0}&FlagForm=NoSubmitted"
DataTextField="ItemTitle"
HeaderText="Listing
Title" />
<custom:LongTextField
DataField="ListingComment"
Width="400px"
Height="75px"
HeaderText="Listing
Comment" HtmlEncode="false"
/>
<asp:BoundField
DataField="EnterDate"
HeaderText="Listed
on" SortExpression="EnterDate"
/>
<Columns>
<FooterStyle
BackColor="#00693E"
Font-Bold="True"
ForeColor="White"
/>
<RowStyle
BackColor="#FFFBD6"
ForeColor="#333333"
/>
<PagerStyle
BackColor="White"
ForeColor="#333333"
HorizontalAlign="Center"
/>
SelectedRowStyle
BackColor="#FFCC66"
Font-Bold="True"
ForeColor="Navy"
/>
<HeaderStyle
BackColor="#00693E"
Font-Bold="True"
ForeColor="White"
/>
<AlternatingRowStyle
BackColor="White"
/>
<PagerSettings
Mode="NextPreviousFirstLast"
Position="TopAndBottom"
/>
</asp:GridView>
<asp:ObjectDataSource
ID="srcClassifieds"
TypeName="SearchUtility"
SelectMethod="GetClassifiedsSimpleSearch"
runat="server"
OnSelected="srcClassifieds_Selected"
EnableViewState="False">
<SelectParameters>
<asp:QueryStringParameter
Name="Category"
QueryStringField="Category"
Type="String"
/>
<asp:QueryStringParameter
Name="Activity"
QueryStringField="Activity"
Type="String"
/>
<asp:QueryStringParameter
Name="KindOfSearch"
QueryStringField="KindOfSearch"
Type="String"
/>
<asp:CookieParameter
CookieName="Country"
Name="Country"
Type="String"
/>
<asp:CookieParameter
CookieName="CityTown"
Name="CityTown"
Type="String"
/>
<asp:SessionParameter
Name="State"
SessionField="State"
/>
<asp:Parameter
Direction="Output"
Name="SelectRows"
Type="Int64"
/>
</SelectParameters>
</asp:ObjectDataSource>
View 4 Replies
May 18, 2010
I have store procedure and I want to when I execute this procedure , Select field list in my gridview. But store procedure dont show every field(it doesnt show relation table.?)
This is my Store Procedure
ALTER PROCEDURE [dbo].[rps_CarePlan3]
@PatientName nvarchar = NULL,
@PatientTypeId int = NULL,
@StartDate datetime = NULL,
@EndDate datetime = NULL,
[Code]....
I see only BakimDestekDto(cause it is part of TblBakimDestek but other field isnt part of TblBakimDestek it is relation field). Why dont I see relation table field? Maybe public IList<TblBakimDestek> GetByStoreProcedure(string startDate) I use inside IList TblBakimDestek?
View 9 Replies
Jan 6, 2010
I have a Gridview with a hyperlink field. The hyperlink will open a pdf file from a folder in the root of the web if there is a corresponding file. My problem is that there may or may not be a corresponding file and if there isn't a file then a browser window opens up and the contents of the folder are displayed. This folder will be maintenanced from day to day adding and removing files. coding something that will either disable the hyperlink were there is no corresponding data or just pop up a message that there is no corresponding data to view.
View 7 Replies
Feb 8, 2011
I have a requrement to display a popup window when i ckick on the gridview hyperlink field.
View 6 Replies
Aug 16, 2010
I have seen several Web Sites that use GridViews that have lookup fields with different Value and Text Fields (as in drop down lists) but I can't seem to figure it out how to display the Text Field in the Item Template when the Text Field is not in the datasource. .
Here's what I have. I have a Gridview whose datasource is a Linq to SQL Invoice table, e.g.
InvoiceID
CustomerID
InvoiceNumber
THe Customer table is related to the Invoice Table thru the CustomerID. The relationship is defined in SQL Server and is displayed in the DBML.
I have created a template field for the CustomerID field in the Gridview. I would like to display the CustomerName when the Item Template is displayed and a DropDownList in the Edit Template. The DropDownList works great, but I cannot seem to figure out how to display the CustomerName in then Item Template.
I seem to remember seeing in some video that you can simply drag the CustomerName into the CustomerID Item Template Field. But I can't seem to find the customerName field. The DataSource includes the Customer Table because of the relationship, but no fields are displayed.
I suspect this is real simple, but I cannot seem to find an article or video that explains how to do this.
View 11 Replies
Mar 11, 2011
I have a grid view attached to a custom query. The query selects data and the address data in the database is split into different fields like street_address1, mail_zip etc. etc. What I would like to do is display all the address data fields in my database in one field on the Grid View.
View 1 Replies
Oct 23, 2010
I have a gridview ...asp 2.0 and VS 2005.The Gridview has template fields and I am using a Header Templete and an Item Template field.Within the Item template fields I am using a asp: table and within the table I am using different asp controls to bind data to the gridview
Here is the issue ...I want that each datafield should align with each other eactly i.e. symmetricaly each column wise.The problem as of now is that as each row of data is displayed in a new table and as a result each column aligns differently.How can I align the columns with each other?
<ItemTemplate>
<asp:Table>
<asp:label> ...<Eval(datafield) </asp:label>[code]....
View 7 Replies
Apr 22, 2010
I am using a GridView Control to display multiple fileds with 0's and 1's.
I am using template fields where CheckBoxes are used.
Where exactly and how do I apply the Logic to get a checked CheckBox when field Value=1 and unchecked CheckBox when field Value=2 .Also some times to be able to write a YES where fieldValue=1 or NO where filedValue=0
Do I apply this logic using asp or C#? How?
View 2 Replies
Mar 20, 2013
i use visual studio 2010 i have stored image into sql server in binary format and how to retrive that image(which is in binary format) and display in image contro
View 1 Replies
Apr 1, 2010
I need to add multiple gridviews to a page displaying different data but of the same structure - the data has a lot of columns and I need it formatting quite tightly - is there a way of creating a template gridview in design mode and then somehow using that however many time I need to in the page as a template.
View 5 Replies
Jun 17, 2012
I use these code for resizing image
behind code
public string img_resize(string picname, int maxHeight, int maxWidth)
{
System.Drawing.Image currentImage = System.Drawing.Image.FromFile(server.mappath("mypics") + picname);
double imgHeight = 0;
double imgWidth = 0;
imgHeight = currentImage.Height;
imgWidth = currentImage.Width;
[code].....
but in this line occur error
<ItemTemplate> <%#img_resize(Eval("my_img"),100, 80)%> </ItemTemplate>
error: Parser Error
Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately. Parser Error Message: The server tag is not well formed.
what should i do ?
View 1 Replies
Dec 7, 2010
i have a gridview with a upload control in edit template. and a image control in item template bound to page that gets the new uploaded picture.the trouble is it does not return a picture no matter what i try??
View 2 Replies
Feb 17, 2011
i designed a gridview with the option of Freeze the header. below is the style i have applied in the headerstyle
background: #ecf5ff;
color: #333;
background-color: #6D91BF;
border-style: solid;
border-width: 1px;
border-color: #9cc9ed #5c9fde #6daddb #b4d2f0;
font-weight: bold;
text-align: center;
color: white;
text-decoration: none;
font-size: 12px;
position: relative;
top: expression(this.offsetParent.scrollTop);
z-index: 10;
but its not working in IE8 standard view but working in IE8 compatibility mode,
View 14 Replies
Jul 10, 2010
but I it throws an out range exception on the highlighted line for me:
[Code]....
View 4 Replies
Jan 20, 2013
I want to show a column of database in footer of gridviewthe column name is Totalthis is my code but it shows 0
<asp:GridView ID="gvodinfo" runat="server" AutoGenerateColumns="False" onrowdatabound="gvodinfo_RowDataBound"
showfooter="true" >
[Code].....
View 1 Replies
Aug 24, 2010
I do a gridview code that when displaying the information that come from the database is not showing any error at all, but is not displaying the right picture. The problem, I think, is that the (Eval("....") is not reading the values that are coming from the DataKeysNames. Due to this the right pictures are not displayed. But in another column, just for testing purposes I was able to display the values from DataKeysNames with the Eval. So I do not know what is going on and to make worse browser is not giving me any error. So, this is the line that is not processing, reading or executing well:
ImageUrl='<%# IIF( (Eval("TUDTIWasItemUpgraded")) = "Yes", string.Format("~/Images/ItemUpgradedTo.gif"), string.Format("~/Images/ItemNoUpgradedYet.gif") ) %>'
And this is the complete code for the GridView
<
asp:Panel
ID="DownlineUDTIGameClassifiedsViewPanel"
runat="server"
>
<asp:GridView
ID="DownlineUDTIGameClassifiedsViewGridView"
runat="server"
AutoGenerateColumns="False"
DataKeyNames="AutoNumber,TUDTIWasItemUpgraded"
DataSourceID="DownlineUDTIGameClassifiedsViewSqlDataSource"
CellPadding="4"
ForeColor="#333333"
AllowPaging="True"
PageSize="100"
OnDataBound="DownlineUDTIGameClassifiedsViewGridView_DataBound">
<FooterStyle
BackColor="#00693E"
Font-Bold="True"
ForeColor="White"
/>
<RowStyle
BackColor="#FFFBD6"
ForeColor="#333333"
/>
<PagerStyle
BackColor="White"
ForeColor="#333333"
HorizontalAlign="Center"
/>
<SelectedRowStyle
BackColor="#FFCC66"
Font-Bold="True"
ForeColor="Navy"
/>
<HeaderStyle
BackColor="#00693E"
Font-Bold="True"
ForeColor="White"
/>
<AlternatingRowStyle
BackColor="White"
/>
<PagerSettings
Mode="NextPreviousFirstLast"
Position="TopAndBottom"
/>
<Columns>
<asp:BoundField
ItemStyle-HorizontalAlign=Center
DataField="TUDTIGenerationNumber"
HeaderText="Generation"
SortExpression="TUDTIGenerationNumber"
/>
<asp:BoundField
DataField="TEnterDate"
HeaderText="Enter Date"
SortExpression="TEnterDate"
/>
<asp:BoundField
DataField="TItemTitle"
HeaderText="Listing Title"
SortExpression="TItemTitle"
/>
<custom:LongTextField
DataField="TListingComment"
Width="400px"
Height="75px"
HeaderText="Listing Comment"
HtmlEncode="false"
/>
<asp:TemplateField
HeaderText="Picture">
<ItemTemplate>
<asp:ImageButton
ID="ThumbNailImageButton"
runat="server"
Width="75px"
PostBackUrl='<%# string.Concat("~/Classifieds/DetailPage.aspx?AutoNumber=",Convert.ToString(Eval("AutoNumber")),"&FlagForm=NoSubmitted")
%>'
ImageUrl='<%# IIF(System.IO.File.Exists(Server.MapPath(string.Format("~/UploadedImagesClassifieds/{0}{1}",
Eval("AutoNumber"), "Pic1.jpg"))), string.Format("~/UploadedImagesClassifieds/{0}{1}", Eval("AutoNumber"), "Pic1.jpg"), "~/UploadedImagesClassifieds/NoPicture.gif") %>'
/>
</ItemTemplate>
<ItemStyle
HorizontalAlign="Center"
/>
</asp:TemplateField>
<asp:TemplateField
HeaderText="Item Upgraded To">
<ItemTemplate>
<asp:Image
ID="XItemUpgradedToPicture"
ImageUrl='<%# IIF( (Eval("TUDTIWasItemUpgraded")) = "Yes", string.Format("~/Images/ItemUpgradedTo.gif"),
string.Format("~/Images/ItemNoUpgradedYet.gif") ) %>'
runat="server"
Width="150px"/>
</ItemTemplate>
<ItemStyle
HorizontalAlign="Center"
/>
</asp:TemplateField>
<asp:TemplateField
HeaderText="Testing">
<ItemTemplate>
<asp:Label
ID="Label1"
runat="server"
Text='<%# Eval("TUDTIWasItemUpgraded") %>'
>
</asp:Label>
</ItemTemplate>
<ItemStyle
HorizontalAlign="Center"
/>
</asp:TemplateField>
<asp:TemplateField
HeaderText="Item Upgraded To">
<ItemTemplate>
<asp:Image
ID="ItemUpgradedToPicture"
ImageUrl="~/Images/ItemUpgradedTo.gif"
runat="server"
Width="150px"/>
</ItemTemplate>
<ItemStyle
HorizontalAlign="Center"
/>
</asp:TemplateField>
</Columns>
</asp:GridView>
View 3 Replies
Nov 22, 2010
Dear all; I have a gridview as follows below
ID ZONE
A AFRICA
B NORTH AMERICA
now, i would like to add a little picture icon on the leftmost side of the gridview, that would allow a user to click on it...which will indirectly bring up a pop-up screen. In the pop-screen, i would like to add a textbox and a button to it, in which the user will be able to use to make an update to a field ID in the gridview.
View 24 Replies
Jul 15, 2010
I am using VWD 2005 Express and Visual Basic.When my SQLDataSource feed my GridView, it does get the AutoNumber (GUID) of each record as well, to use it as a name for stored pictures. Pictures are not in the database but in a folder. Since I have several pictures, I do manipulate this ID with code and I add to it, pic1, pic2, etc and that is the final name for each picture, for each particular record. Example: The ID for one record in the database may be, 45623sdgd. If I have four pictures for this particular database record, the names will be, 45623sdgdPic1, 45623sdgdPic2, 45623sdgdPic3, and so on after Pic is added. After this I save these pictures in a folder.
Now, when I display the record information with a GridView, I get the AutoNumber of each record using: DataKeyNames="AutoNumber". I want to display a thumbnail picture link as well. But I really do not have many options in term of what control to use for the thumbnail inside the GridView. I tried the following controls unsuscesfully. HyperLinkField, can not add a picture to this one. ImageField, can not add a link to this one. ButtonField does not have a DataImageUrlField="AutoNumber" to get the AutoNumber. So since to be that my only opton is the asp:TemplateField. But it is giving me error with the coding. This is my coding,
Code:
<asp:GridView
ID="PublicClassifiedsSamplesGridView"
runat="server"[code].....
View 3 Replies
Feb 23, 2013
i have three saved values in database
1,2,3
i want to showing status in label for 1 , Pending
<asp:Label ID="lblLeaveStatus" Visible = "true" runat="server" Text='<%# Eval("Rec_Status").ToString() == "1" ? "Pending": Eval("Rec_Status") %>'>></asp:Label>
how can i show it with all 1,2,3?
View 1 Replies
Jun 11, 2010
I want to hyperlink from a field in one gridview to a field in another gridview based on id. I've tried many ways but haven't seen success.
View 20 Replies
Jul 9, 2010
I have 2 fields in my gridview one called ScriptType the other BagNo, when a user click the edit button, I would like the BagNo filed to be disabled if the ScriptType field is = "TTA" and enabled otherwise. How can I do this?..something along these lines see below..I am using VB..
[code]...
View 14 Replies
May 29, 2010
How can we insert a picture into an image field PictureBinary?
how to do it in C# and/or T-SQL.
View 1 Replies
Dec 19, 2010
I have a grid view, and I add new column as a hyper link field, I want the navigationURL for this field to be Pageexample.aspx?ID=other field value like this
[code]...
is that possible ?
View 2 Replies
Apr 14, 2014
I have year wise Photo now i want insert the photo by year and month and date wise after i want the main page shown the year when i click the year it will be shown the month and i will click the month it will open by date after the photos will be shown .
View 1 Replies