Is there any way to use the DateTime.ToString() method to display the meridiem of the time portion as "A.M." instead of "AM"? I tried using the mask "t.t." but this just outputs "A.A."
View 2 Replies
I have a situation where I need to display the time in 24hr clock mode rather than 12hr mode. Is there a way to do this?
I need it to just display the the Hours & Mins e.g. 13:42. AM or PM is optional.
How to format DateTime.ToString(????)Result should look like: 2010-02-05T10:36:26+10:00
View 2 RepliesI have deployed my asp.net application in my hosting provider they are from US... I have one filed in which i have wriiten Datetime.now.tostring() it saves in Database table it save 11/11/2010 5:20:47 AM
View 17 RepliesWhen a post is made to the site/database, it's made as Universal Time. A user can set the site's default timezone from a dropdown menu in the admin area, which saves the selected timezone to a database table (table: DefaultTimezone, column: Timezone). Now, how can I adjust the following code to display the datetime according to the correct timezone, that was set in the database? So if the Timezone column has "US Eastern Standard Time" in it, it would display the published datetime in that format.
<%#Eval("Published", "{0:MMM dd, yyyy - h:mm tt}") %>
I have a label like:
<asp:Label ID="dateLabel" runat="server" Text='<%# Eval('SomeDate') %> />
This displays showing the date and time. However I just want to display the date.
I'm aware that in the code behind you can write SomeDate.ToString("dd MM yyyy");
However I want a way of doing this by changing the code in the tag instead.
how do i display a datefield field e.g. 07/27/2010 08:00:00 as Tuesday, July 27, 2010? (i want the time part but i couldnt find any fucntions that display the date in text mode?)
I am creating a SQL procedure and need to read the data back into a gridview in that format.
I have a DateTime stored in UTC time that I'd like to display to the user in their local time from within a GridView control. How can I convert my DateTime to the user's time (not my server's local time)? Here is my current field as it appears in the GridView Columns collection:
<asp:BoundField DataField="RunTime" HeaderText="Run Time"
SortExpression="RunTime" DataFormatString="{0:f}" />
How can I get date in the format 2015-09-23T10:24:22.940+01:00 as a datetime and not string, in c#.
View 1 RepliesI am using Calendar to display Date in Textbox. my Problem is that it works Ok in localhost but when I had uploaded the same, error come "Unable to convert String to datetime".
View 4 RepliesThere is a "singleline" Textbox in my page in which both date and time are fetch from database table column "DateTime".
I want Time to be come below Date in that "singleline" Textbox.
I can't take that Textbox as "multiline". How to split date and time in singleline Textbox?
How to achieve this?
I am trying to insert "Date" and "Time" in database table (both are separate columns) using below code:
string query = "Insert into tempTable(List_Id, Date, Time) VALUES('" + lblId.Text + "', @Date, @Time)";
SqlCommand cmd = new SqlCommand(query, connection);
connection.Open();
TimeSpan time = new TimeSpan();
time.ToString();
cmd.Parameters.AddWithValue("@Date", Convert.ToDateTime(DateTime.Now.ToShortDateString()));
cmd.Parameters.AddWithValue("@Time", Convert.ToDateTime(DateTime.Now.ToString("HH:mm:ss")));
cmd.ExecuteNonQuery();
connection.Close();
Above record is inserted in DB like below:In Date column: 12/29/2014 12:00:00 AMIn Time column:12/29/2014 5:30:46 PMDatatype for "Date" and "Time" column is "datetime"I want that: as I save the Date and Time in DB table, it should display same date and same time what is saved in DB table not current date and time.I tried below code to fetch saved records from table, after inserting Date and Time in DB:
string query2 = "Select Date, Time where Id='" + itemId + "'";
SqlCommand cmd2 = new SqlCommand(query2, connection);
connection.Open();
SqlDataAdapter da = new SqlDataAdapter(query2, connection);
DataTable dt = new DataTable();
da.Fill(dt);
lblDate.Text = DateTime.Parse(dt.Rows[0][0].ToString()).ToString("dd-MM-yyyy");
lblTime.Text = DateTime.Parse(dt.Rows[0][1].ToString()).ToString("HH:MM tt");
But currently it is giving me below output : Date:29-12-2014Time:18:04 PM (current time)..
Why its showing current date time in place of saved record ??
i have created a table with column like date (datetime), employeename (varchar) and their designation (varchar).. am using sql server 2005 and vb.net
I want to display this information in gridview.. i also displayed the inforamtion, but what the problem is the display of date is 4/2/2010 12:00:00 AM.. i need to display only the date in the gridview as 4/2/2010 under the date column .
My work is done properly all good with this query
View 1 Repliesi am having table in which date, company name and amount is stored
i have one dropdown in which i kept year
now i want to show data in gridview according to year selected from dropdownlist but how i can seperate date from year in date field
protected void ddlYear_SelectedIndexChanged(object sender, EventArgs e)
{
conn.Open();
[Code].....
in my asp.net_vb web there is a text box (textbox1) in which a date is dispalyed from database (eg 21-Mar-2012) in another text box (textbox2) i want to display
if the date is less than 30 Jun then the textbox2 should display 1 Jul+the year of textbox1
if the textbox1 date is greater than 30 Jun the text box2 should display 1 Dec + the year of textbox1
my web is in asp.net and code is in vb
whats the difference in the two string methods below?
string str1 = dr["RAGStatusCID"].ToString();
string str2 = (string)dr["Description"];
I've a strange problem. We use Dutch and French lanuage on our site (nl-NL / fr-FR)I'm binding to a gridview and the strange thing is, the numeric value-saparator (dot) is not displaying well for French (fr-FR)ASP.NET
protected void gridview_RowDataBound(object sender, GridViewRowEventArgs e)
{
Label lbla_min_10 = new Label();
[code]...
I have an XElement object that contains about 120MB of data. The XML consists of approx 6000 elements of about 20kb each.
I am trying to call XElement.ToString() as I need to return the OuterXml in a webservice.
I am getting a System.OutOfMemoryException.
System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown:
at System.String.GetStringForStringBuilder(String value, Int32 startIndex, Int32 length, Int32 capacity)
at System.Text.StringBuilder.GetNewString(String currentString, Int32 requiredLength)
at System.Text.StringBuilder.Append(Char[] value, Int32 startIndex, Int32 charCount)
at System.IO.StringWriter.Write(Char[] buffer, Int32 index, Int32 count)
at System.Xml.XmlEncodedRawTextWriter.FlushBuffer()
at System.Xml.XmlEncodedRawTextWriter.WriteAttributeTextBlock(Char* pSrc, Char* pSrcEnd)
at System.Xml.XmlEncodedRawTextWriter.WriteString(String text)
at System.Xml.XmlEncodedRawTextWriterIndent.WriteString(String text)
at System.Xml.XmlWellFormedWriter.WriteString(String text)
at System.Xml.XmlWriter.WriteAttributeString(String prefix, String localName, String ns, String value)
at System.Xml.Linq.ElementWriter.WriteStartElement(XElement e)
at System.Xml.Linq.ElementWriter.WriteElement(XElement e)
at System.Xml.Linq.XElement.WriteTo(XmlWriter writer)
at System.Xml.Linq.XNode.GetXmlString(SaveOptions o)
at System.Xml.Linq.XNode.ToString()
I have the same data in an XmlDocument and can call XmlDocument.OuterXml without a problem. I can also call XElement.Save() to save the XML to a file without a problem.
When I run the following debugging code it writes out credits:0
Dim MembershipUser As MembershipUser = Membership.GetUser()
Dim UID As String = MembershipUser.ProviderUserKey.ToString
SQL = "SELECT SUM(Credits) As Credits FROM Credits WHERE " & _
"DateDiff(m, [DateTime], GETDATE()) < 6 AND [UserID]=@UserID;"
cmd = New SqlCommand(SQL, Conn)
cmd.Parameters.Add(New SqlParameter("@UserID", UID))
DataReader = cmd.ExecuteReader()
If DataReader.HasRows Then
Do While DataReader.Read
[Code]....
after my grid view updates a record I would like to run some code, I have tried to use SelectedDataKey.Value.ToString() to get the datakey. However it is null, the record updates so the value must be stored somehow?
View 1 RepliesI want to Know What is the difference between .ToString and Convert.To string?
View 4 RepliesBookmarkA.Title = Me.head.Page.Title.ToString()
I tried the above one in order to get the page title but I failed ! What I need to do ?
Me.head.Page.Title.ToString() did't get the value !
I created a UserControl and added a public DateTime property. I want to set this property in Markup (ie. <cc1:MyControl runat="server" id="MyControl1" DateTimeProp="1/1/2010" /> ) however I live in a place with a dd/mm/yyyy date format so it complains if I set something like "20/1/2010". Is there a way to set markup in my local datetime format or do I have to conform to "mm/dd/yyyy"?
View 2 RepliesI have a problem:
I've created usual Controller and View(Edit view) for editing my Entity (EntityFramework)
Here is view example:
<div class="editor-field">
@Html.EditorFor(model => model.BirthDate)
@Html.ValidationMessageFor(model => model.BirthDate)
</div>
BirthDate is Nullable<DateTime>
but during loading my View I get this exception
The model item passed into the dictionary is null, but this dictionary requires a non-null model item of type 'System.DateTime'.
That's because of BirthDate is null in database but it is nullable and I expect that it just leaves the filed empty.
And I have Shared EditorTemplate:
@model System.Nullable<System.DateTime>
@if (Model.HasValue)
