Data Controls :: How To Convert And Format Date In Eval Function In GridView
May 21, 2013
According below thread I had problem with showing date to persian and solved it
Error-Occure-when-want-to-show-date/?s=2#Replies
Now this problem happen for below code I used datalist to showing date
</asp:TemplateField>
<asp:TemplateField ItemStyle-Width = "100px" ItemStyle-HorizontalAlign="Center">
<ItemTemplate>
<%# System.Convert.ToDateTime(miladitoshamsi(Eval("Date"))).ToString(" yyyy/MM/dd") %>
[Code] ....
ERROR : Server Error in '/behtop website' Application.
Year, Month, and Day parameters describe an un-representable DateTime.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception
Details: System.ArgumentOutOfRangeException: Year, Month, and Day parameters describe an un-representable DateTime.
Source Error:
Line 231: DateTime miladi = Convert.ToDateTime(miladi1);
Line 232: System.Globalization.PersianCalendar shamsi = new System.Globalization.PersianCalendar();
Line 233: DateTime shamsidate = new DateTime(shamsi.GetYear(miladi), shamsi.GetMonth(miladi), shamsi.GetDayOfMonth(miladi)); Line 234: //DateTime shamsidate = new DateTime(shamsi.GetYear(miladi), shamsi.GetMonth(miladi), shamsi.GetDayOfMonth(miladi), shamsi);
Line 235:
How I can change this code?
View 1 Replies
Similar Messages:
Oct 21, 2015
<asp:Label ID="lbl_date" runat="server" Text='<%# Convert.ToDateTime(Eval("dt_pub")).ToString("dd/MM/yyyy") %>'
check for systax error
It show me server tag not well formed error
View 1 Replies
Jun 26, 2012
i use this code for show and converting date in my grid view
<asp:TemplateField ItemStyle-Width = "100px" HeaderText = "DATE" >
<ItemTemplate >
<%# System.Convert.ToDateTime(miladitoshamsi(Eval("Date")))
</ItemTemplate>
</asp:TemplateField>
here show my date and time from data base i learn in below threads how i can bind date from data base that just show date.URL....with this code
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
<Columns>
<asp:BoundField DataField="Item" />
<asp:TemplateField>
<ItemTemplate>
[code]...
now how i can mix these two code together that convert date from database and just show date?
View 1 Replies
May 7, 2015
<asp:TemplateField HeaderText="Is Activate ?">
<ItemTemplate>
<a href="#" onclick='fnViewRemarksTest(<%#DataBinder.Eval(Container.DataItem,"CustomerId")%>)'><%#Eval("IsActivated ")%></h3></a>
</ItemTemplate>
</asp:TemplateField>
Is Activated is a boolean data type column in Sql.
I want to Show that, when IsActivated is true text will be "User Is Active" and when false , the text will be "User Is not activate" ...
View 1 Replies
May 7, 2015
I have a SQL2012 database in the database in have a table with many cloumns one of the columns is date. on the gridview i am using a ItemTemplate field to display date
<asp:TemplateField HeaderText="DATE">
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Eval("Date").ToString() =="2000/01/01 12:00:00 AM "? "" : Eval("Date" ,"{0:dd/MM/yyyy}").ToString() %>'></asp:Label>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
The Problem i having is that i am testing weather the date matches something and based on that it display "" else it should display the date based on the formotting but both are not working.
View 1 Replies
Dec 29, 2012
this is my hyperlink code that is in gridview
<ItemTemplate>
<asp:HyperLink ID="lnkRemove2" runat="server" CssClass="LBP3E" Text = "more..." NavigateUrl='<%# "state/view.aspx?BehCode=" + Request.QueryString["BehCode"] + "&Id=" + Eval("Id") %>'></asp:HyperLink>
</ItemTemplate>
I want do some thing like that for my button control that is not in gridview it is out of grid view...HOw I can do it?
View 1 Replies
May 7, 2015
How do I pass Hidden Variable to javacript function on GridView hyperlink click.Below is the code used
<asp:GridView ID="gridMicroscopicCode" runat="server" ...
<ItemTemplate>
<table id="Table2" cellpadding="0" style="border-width: 0px; width: 100%;" class="tableBorder" runat="server">
<tr class="botborder1">
<td style="width: 25%;">
<input id="Hidden1" runat="server" value='<%# Bind("preferenceid")%>' type="hidden" />
<asp:HyperLink ID="hypMicroscopicPopUpEdit" runat="server"
Target="_self" NavigateUrl="javascript: EncryptDataFunc('VAAddEditMicroscopic.aspx?editoption=yes&queryprefid=' + <%# Hidden1.value %>);">
</asp:HyperLink>
View 1 Replies
Apr 17, 2014
Use Multiple Eval Fields in ASP.Net GridView ItemTemplate
I have a folder in my website project as "MAINIMAGES",inside that all the image folders that are fetched from database "GALLERY folder" are located
How to locate my image
MAINIMAGES>FOLDER>IMAGE
View 1 Replies
Nov 19, 2010
I have used following code :
''>'
it will display the date as:11/4/2010 10:52:33 AM
But i want that it will display only 11/4/2010. How to do this?
View 4 Replies
Jan 12, 2011
I want to bind two column on single level in GridView
I m using this code
<asp:Label ID="Label1" runat="server" Text='<%# Eval("lChannelName")+ " " +Eval("lTransformData") %>' >
</asp:Label>
But i want to bind First column at Left hand side and second column from right hand side
View 9 Replies
May 7, 2015
I want to pass hidden variable to javascript from href. Below is the code used
<input runat="server" id="hidOrganizationId" type="hidden" value="" />
<ul class="gloMenu">
<li id="liOrg" runat="server">
<a href="javascript: DataEncryption('../Admin/DetailPage.aspx?OrganizationId=' + hidOrganizationId)">
<b>Ordering Facility</b>
</a>
</li>
View 1 Replies
Jan 27, 2010
I'm looking for the best way (Performance) to do gridview columns formating RunTime /Dynamic depending on the datatable Columns type ,I want to bind the datatable to a gridview and format the Date columns to short date, and currency columns formatted with comma ex 10,000.00 inplace 100000.00 at datatable the column type is double run time (without converting them to String) since I do a filtering and sorting at these columns.
View 3 Replies
Feb 10, 2010
how can i convert the date format to mm/dd/yyyy hh:mm:ss tt like this 2/28/2010 12:53:32 PM
View 2 Replies
Apr 21, 2010
In my database im storeing date as varchar. Now i want to display the table in grid view sorted by date.So how to convert varchar to datetime.
Im trying the following querry but its not working.
SELECT
[Name],
convert(datetime
,103,[sdate]),
[place], [country],
FROM [table]
View 10 Replies
Feb 1, 2011
a table rows contains 02/25/2011,
03/27/2011,
04/25/2011
how to convert it rows in format -25-Feb-2011,
27-Mar-2011
25-Apr-2011
View 3 Replies
Jul 13, 2010
I have written a small web app to take fill a dataset from an xml file, which is then bound to a Gridview control. The problem I am having is that I am trying to format a date field as it is currently displayed as '2010-06-03T16:37:26.043+01:00'. I can usually set a format to an item within a templatefield by setting the bind or eval text, but in this case I cannot.
XML File
[Code]....
ViewTable.aspx.vb
[Code]....
I have tried formatting the column within the rowdatabound event but with no joy. Code shown below
e.Row.Cells(10).Text = Convert.ToDateTime(e.Row.Cells(10).Text.ToString())
View 4 Replies
Oct 18, 2012
My web is in asp.net+vb code and sql 2005 database. In a gridview i used to convert dateformat as dd/mm/yyyy (11 Jun 2011) format
convert (varchar, DTDOB,6) as [DTDOB]
when i use only DTDOB then date format is 6/11/2011 12:00:00 AM .(i can sort my grid on DTDOB and the date is correctly sorted)
when i use convert (varchar, DTDOB,6) as [DTDOB] then date format is 11 Jun 2011. (When i sort the date is sorted as per the day only.
eg 01 Nov 93,04 Nov 93,06 Nov 92,08 Jun 91,11 Dec 93 etc.
View 1 Replies
Oct 13, 2010
200011
200009
I want for the date to be displayed in the Grid at the following format MM/YYYY - that is:
Databound
Databound
Till Period
From Period
Databound
(I have just started programming in C#.net via Microsoft Visual Studio 2010, so I really don't have programming knowledge yet).
View 16 Replies
Oct 13, 2010
From the database - 2 of my GridView cells: From Period, and Till Period - retrieve dates in the format YYYYMM - that is: just Year and Month. For Example:
Databound
Databound
Till Period
From Period
Databound
200008
200005
200011
200009
I want for the date to be displayed in the Grid at the following format MM/YYYY - that is:
Databound
Databound
Till Period
From Period
Databound
08/2000
05/2000
11/2000
09/2000
How can I do it easily? (I have just started programming in C#.net via Microsoft Visual Studio 2010, so I really don't have programming knowledge yet).
View 4 Replies
Feb 10, 2010
I am having a table with some fields in which one field is emp's DOB of varchar datatype.I want to display the date in Gridview in 'DD-MM-YYYY' format as well as the dates should be in sorted in descending order.
For e.g:12/03/2010' should be displayed before '12/03/2009'.
View 7 Replies
Apr 1, 2013
i have a gridview , i dont know how to set the dateformat for gridview template field.
View 1 Replies
Oct 18, 2010
can I add a column to gridview that will convert the utc date to my local time? HOw?
View 2 Replies
Apr 11, 2010
i've gridview and sqldatasource bind,i got 2 field in gridview start date and end date,actual problem : both dates coming in format -11/4/2010 12:00:00AMi want 11-04-2010
View 4 Replies
Mar 13, 2010
I'm hitting a wall trying to format a boundfield of a gridview. I've tried suggestion about setting the htmlencode to false, but that didn't make a difference.The column I am trying to format is:<asp:BoundField DataField="FromDate" HeaderText="Start Date" DataFormatString="{0:MM/dd/yyyy}" HtmlEncode="False" />
View 1 Replies
May 7, 2010
I would like to format the date time to
Monday 7th May 2010 9:00 am
What is the format string using <%# Eval("StartSession", "{0:?????}") %>?
View 4 Replies
