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.
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.
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())
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 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 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 ..
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?
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
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" />
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 -.
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.
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.
Here is part of my code. The commented portion is the logic in which i am trying to implement. I want client side validation to be done and checked to see if it is correct format (MM/DD/YYYY).
I have a objectdatasource control with a field of date and time and I was wanting to know how you format the date to uk format with the select statement through my objectdatasource. And what type of integer is bigint in SQL?
I am storing date data in sql server as varchar but I want to make comaparisons on this field in where clause- like this field from 2 days before or after etc
In the above code , i am creating pdf file from aspx page and i am sending it as a attachment in email. i want to print above pdf page instead of sending email. could any please extend above code to print it.
