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'.
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 RepliesI 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())
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).
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).
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 RepliesI'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 RepliesI would like to format the date time to
Monday 7th May 2010 9:00 am
What is the format string using <%# Eval("StartSession", "{0:?????}") %>?
I want to pass date from one page to another page using querystring. I have used a gridview hyperlinkfield.
When user click hyperlink in gridview the data should display on other page.
I have tried this but due to date format (dd/MM/yyyy) that is showing in gridview the hyperlink is not showing. I think '/' is creating problem. In gridview I already tried by replacing / to -.
I want to have a date format in gridview column when user is in edit mode.
That is when user is editing the date he should automatically get the format like this
'--/--/----' (i.e 12/01/2010) now he can write his desired date, he is not going to type the forward slash "/" using Key Board.
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.
i have a gridview , i dont know how to set the dateformat for gridview template field.
View 1 RepliesI have one problem im exporting my data into excel in that i have one column,after exporting that data to excel now it is taking system date format instead of that i want date format like mm/dd/yyyy
below in my code...
string strBaselineassessmentVisitdate = list[i].BaselineDateOfAssessment.ToString("MM/dd/yyyy");
First I am taking the data from database then im converting that to MM/dd/yyyy forma but still it taking the system date format which I don't want....
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?
i facing a problem to change the date format at gridview display.
below is my coding:
[code]....
Looking for an example that demonstrates usage of different validations with respect to gridview.
View 1 RepliesI am using a dataview to read a certain record from a database and then adding these values to different elements on a form (label, textbox) ..
One of the fields is a date/time and i only want to display the date without the time..
code:
{on page load}
Dim dv As System.Data.DataView = CType(DEDS.Select(DataSourceSelectArguments.Empty), System.Data.DataView)
lbl_startdate.Text = dv.Table.Rows(0).Item("'<%# Eval("evt_startdate","{0:d}")%>'").ToString()
' DEDS is my SqlDatasource ..
'evt_startdate is the date field coming from the DEDS datasource
.. It's not working .. I'm not sure how i should alter the date format ..
I have to display a news component peice in our website's homepage. The news information (date and news) is retreived from the db and I have queried to retreive that info now. My question is really simple --> How do I display the news with the timestamp in this specific format:
Database has it in this format:
2010-06-21 00:00:00. ----News blah blah A
2010-06-18 00:00:00. -----News blah blah B
2010-05-21 00:00:00. -----News blah blah C
2009-04-15 00:00:00. -----News blah blah D
I need the above information to be displayed in the following format:
2010
June
06/21/2010 - News blah blah A
06/18/2010 - News blah blah B
May
05/21/2010 - News blah blah C
2009
April
04/15/2010 - News blah blah D
I am using labels like this and few date formats which would extract like this, but some coding to retreive the earliest news first depending on the yr / month and date would be great.
asp:Label
ID="Label1"
runat="server"
Text='<%#
Eval("EffectiveDate", "{0:yyyy}")%>'
Font-Names="timesNewRoman"
Font-Size="10pt"
ForeColor="black"
Font-Bold="true"></asp:Label></td>
I am trying to assign datetime to the textbox when a date selected from asp.net Calendar control in the following format:
06/05/2010 12:25:04 PM
but I have tried following four options that are not giving required date format. What to do?
Calendar1.SelectedDate.ToShortTimeString() = 12:00:00 AM
Calendar1.SelectedDate.ToShortDateString() = 03/05/2010
Calendar1.SelectedDate.ToLongDateString() = 03/05/2010
Calendar1.SelectedDate.ToLongTimeString() = 12:00:00 AM
I want to display 06/05/2010 12:25:04 PM
How can I format my date field like this "Jan 6 @ 7:42 AM" from my date field. My present date field is in this format "1/6/2010 7:42:00 AM".
I am using this in my repeater control.
In my gridview I have a datetime columns and couple of decimal number columns. Lets say I have a datetime value like this 19.03.2011 00:00:00 and I want it to seem like 19.03.2011. And I would like 2 decimal digits only. How can I achieve this?
View 2 RepliesIn the following Datalist, The date in the "DateLabel" is showing like "1/24/2011 12:00:00am" but I want it to show only the date. How can I do this?
[Code]....
I have created a class file which gets me the state codes,license numbers and the expiration dates for the same.
I fetch the expiration dates in string format.
Each customer can have many licenses.
I have changed the format of the date (initially appearing as YYYY/MM/DD 00:00:00 when retrieved from database) to MM/DD/YYYY.
After retrieving all the licenses pertaining to a single customer, I bind them to a datalist.
Now the requirement is that for each customer, I need to sort the licenses according to the latest expiration date and then display the same.
How can this be achieved ?
Since I'm using Oracle database , I need to use this kind of date format :dd-mmm-yy
so, when a user insert date in this specific column, I ask him to insert the date in dd/mm/yyyy format and then I use a function to "translate" it to oracle date
the problem is that the next time the user will try to update the row, the validation rule asks to change the format of the date to dd/mm/yyyy
so what I wanted to do is that whenever I display the gridview I'll see the dates as dd/m/yyyy , but the data that will be sent to the database will be in the oracle format.
[Code]....
and i m Binding its DataSource as follows:
[Code]....
But when it shows the graph its XAxis Date Format is not according to my requirement i.e. "MMM-yy" But its showing the format that is stored procedure giving to the DataSource binding of this chart.