I'm trying to create a string from the DateTime object which yields the format mm:dd:yyyy. Conventionally the DateTime object comes as mm:dd:yyyy hrs:min:sec AM/PM. Is there a way to quickly remove the hrs:min:sec AM/PM portion of the DateTime so that when I convert it toString() it will only result in mm:dd:yyyy?
View 3 Replies
Currently I am able to bring the datetime from my SQL table but I also need the milisecods. Here is the line of code:
[Code]....
So latestTimeStamp = {9/22/2010 6:24:09 PM} but I needed it to be latestTimeStamp = {9/22/2010 6:24:09:080 PM}
since the SQL field value is 2010-09-22 18:24:09.080 and I want to do an accurate datetime comparison.
I'm trying to calculate the yrs, months, days, hours, mins, seconds between two dates with sql server or c# (ive just used sql more).
I have some code below that I started, but I get some negative values for months, values over 31 for months, and there very well could be more issues. Honestly my math is not the greatest and Im just not sure how to fix it. I want the user to be able to enter their birthday and for it to calculate the yrs, months, days, hours, mins, and seconds they have been alive.
[Code]....
I am converting my datetime object with current date and specific time 23:59:59 as shown underneath.
[Code]....
But when I check in my sql table datetime column, it is changes seconds part of time from 59 to 00, so for instance, if I have a datetime, 2010-08-11 23:59:59, it changes this to 2010-08-11 23:59:00. How should I fix this.
i published my site to server and login users with session but this session remove after 30 seconds !!! and user page send error i used this code in web.config buy session remove again
View 2 RepliesI test my asp.net website app in my win 2000 server in Administrator user mode, the session I start (Session("user_ses") = myclass) only lasts a few seconds. But if I do the same as a 'common' user the session lasts 20 minutes, which is the time I set in web.config file:
<sessionState mode="InProc" cookieless="false" timeout="20" />
which is the reason the session lasts so little in Administrator user mode in windows 2000 server?
i am using below code to print my content of webpage in asp.net using javascript
window.print(document.getElementById('dvPrint'));
when i do print, it automatically adds date time on page.. (i think because of page setup) in firefox. how can i remove this setting. i mean i dont want datetime to be printed automatically on my print page (even if its set in pagesetup).
in my default.aspx page i have a dropdown List and a textbox with a submit button below that there are 2 listbox... and the dropdown list holds the names of the listbox
my logic here is to select an item from the dropdown list and put some text in the text box and submit the form which will add an item to the listbox selected.. but when i do this i get an error saying Object reference not set to an instance of an object. i tried to figure out the problem and found that when i remove the reference to the Site Master Page it works fine and when i undo and apply my reference back to the Site Master Page i get the same error.
[Code]....
I have a grid view which contains Hours as one of the columns.. now, i need to have a total hours in the footer (sum of hours for all rows).
View 2 RepliesI am calling an action from JQuery using $.getJSON() method.
This action returns a JsonResult object.
I am getting all the values correctly but not the Date Format.
Below is the Date format which i am getting.
/Date(1287587195000)/
/Date(1287587195000)/
But i want it like "10/15/2010 11:56 AM" this format.
How can i achieve it...
Does the DateTime object stores the CultureInfo with it, or you need to use the Formatter to format the DateTime according to current culture ?
I have a class property that retuns a DateTime. Within that property I am setting the DateTime object with current culture information using CultureInfo object. Below is the code for class property I am using:
public DateTime PrintedQuoteDate {
get{
DateTime printQuoteDate = DateTime.Today;
// cInfo = CultureInfo object
return Convert.ToDateTime(printQuoteDate , cInfo);
}
}
So my question is when I will use the above property in my code, will it have the corrosponding culture information that I am setting in its get method, or I will have to use the same CONVERT code for formatting date time. The restriction here is that the Property should return only DateTime type.
System.DateTime start_time = (System.DateTime)phones_.GetStartTime(callInfo.No[1].e164, callInfo.No[0].e164)[0][0];
View 1 RepliesI'm really drawing a blank on this one. I've been working on globalization but the DateTime seems to always revert back to the CurrentThread's culture.
I've got a textbox with the date expressed as a string:
// the CurrentThread's culture is de-DE
// My test browser is also set to de-DE
IFormatProvider culture = new System.Globalization.CultureInfo("de-DE",
true);
// en-US culture, what I'd ultimately like to see the DateTime in
IFormatProvider us_culture = new System.Globalization.CultureInfo("en-US",
true);
// correctly reads the textbox value (22.7.2010 into a datetime)
DateTime dt= DateTime.Parse(txtStartDate.Text, culture,
System.Globalization.DateTimeStyles.NoCurrentDateDefault);
// correctly produces a string 7/22/2010
string dt2 = dt.ToString(us_culture);
At this point I want a DateTime that's in en-US I've tried both:
DateTime dt3 = Convert.ToDateTime(dt2, us_culture);
DateTime dt3 = DateTime.Parse(dt2, us_culture);
But both produce de-DE DateTimes. My motivation in asking this question is the rest of the business logic is going to be calling dt2.toString() and will result in an incorrect date time string. I realize I could change toString() to be toString(us_culture) but I'd rather not change all of the rest of the business logic to accomodate this change.
Is there a way to get a DateTime in a culture other than the CurrentThread's culture?
Consider this snippet of code:
string sDate = string.Format("{0:u}", this.Date);
Conn.Open();
Command.CommandText = "INSERT INTO TRADES VALUES(" + """ + this.Date + """ + "," +this.ATR + "," + """ + this.BIAS + """ + ")";
Command.ExecuteNonQuery();
Note the "this.Date" part of the command. Now Date is an abject of type DateTime of C# environment, the DB doesnt store it(somewhere in SQLite forum, it was written that ADO.NET wrapper automatically converts DateTime type to ISO1806 format)
But instead of this.Date when I use sDate (shown in the first line) then it stores properly.
My probem actually doesnt end here. Even if I use "sDate", I have to retrieve it through a query. And that is creating the problem
Any query of this format
SELECT * FROM <Table_Name> WHERE DATES = "YYYY-MM-DD"
returns nothing, whereas replacing '=' with '>' or '<' returns right results.
So my point is:
How do I query for Date variables from SQLite Database.
And if there is a problem with the way I stored it (i.e non 1806 compliant), then how do I make it compliant
I have an application which uses globalization, hence the datetime objects are globalized based on current culture. These datetime objects are passed as sql parameters for a select query. The database stores the datetime in only one format (en-US style). Although the query is parameterized the final query generated does not contain converted values (format that Database is expecting).
View 1 RepliesI have a site that uses a jquery calendar to display events. I have noticed than when using the system from within IE (all versions) ASP.NET MVC will fail to bind the datetime to the action that send back the correct events. The sequence of events goes as follows. Calendar posts to server to get events Server ActionMethod accepts start and end date, automatically bound to datetime objects
In every browser other than IE the start and end date come through as:
Mon, 10 Jan 2011 00:00:00 GMT
When IE posts the date, it comes through as
Mon, 10 Jan 2011 00:00:00 UTC
ASP.NET MVC 2 will then fail to automatically bind this to the action method parameter. Is there a reason why this is happening?
The code that posts to the server is as follows:
data: function (start, end, callback) {
$.post('/tracker/GetTrackerEvents', { start: start.toUTCString(), end: end.toUTCString() }, function (result) { callback(result); });
},
Dim strTime as String = FomatDateForSave("28/12/2010")
Public Shared Function FormatDateForSave(ByVal strDate As String) As Date
FormatDateForSave = Date.ParseExact(strDate,'dd/MM/yyyy', System.Globalization.CultureInfo.InvariantCulture)
End Function
I am expecting strTime to be "12/28/2010" .... But its getting converted to "28/12/2010" The thing is when the operation is performed by FormatDateForSave ... it converts it to "12/28/2010" But when it is returned it is again converted to "12/28/2010"
I have set the Date for Page.Culture to be "dd/mm/yyyy" and want the value to be "mm/dd/yyyy" to be saved in DB.
I am making an ajax call with jquery like:
$.ajax({
url: "path/to/webservice.asmx"
beforeSend: function(xmlHTTPRequest) {
//modify headers here
//remove cookies
}
success: function() {
//do stuff
}
}
What I would like to do in the beforeSend function is take the incoming xmlHTTPRequest variable that is set and modify the headers to remove the cookie object that is in there, so in the call to my web service, it does not renew forms authentication in asp.net
I use a DetailsView to update data using an object data source. Everything works fine except the date time values
following is a the code of the object datasource and the details view binding:
[Code]....
when data reach my BLL class to update the fields the project id and project Title have the expected binded values from the details view edit template textboxes but the date value is the value of the item tempate's label box (EVAL)
i want to create a datetime object in the way dd/mm/yyyy but the defualt behaviour of datetime object is mm/dd/yyyy. I want this because my user enters date in dd/mm/yyyy format and i want to apply different additions and subtrations on this format. I know how to display dates in different formats.
View 3 RepliesFor my site, I have a list of users and a list of events. I will be assigning users to each event. I have a table named EventUsers to hold this data:
EventUsers
EventID | UserID
1 | 123
1 | 456
2 | 789
On my page, I want to be able to add and remove users for a certain event. I could have a dropdown populated with users and an "Add" button next to it, then when I want to add a user, I pick one and click "Add". There would be a grid below it displaying all the users for the event, with "Delete" buttons for each one. The downside to this is that a database call is made for every Add and Delete.
Another option is to have two listboxes on the page - one on the left containing all users in the database, and another on the right which will contain users for the given event, and I can just add or remove from the list on the right. Then when I'm done, I click save, and it makes one database call. The only issue is that if I'm removing and adding, I'll have to delete every record in my EventUsers table for that event, and then add the changes. I've run into this before, and I've always gone with the dropdown method. What's the preferred method here?
string NewsFillter = string.Empty;
List<string> PublishDatePostMeta = (from post in postrepository.GetAllPosts()
join pstmt in postrepository.GetAllPostMetas()
on post.int_PostId equals pstmt.int_PostId
where (post.int_PostTypeId == 4 && post.int_PostStatusId == 2 && post.int_OrganizationId == layoutrep.GetSidebarDetailById(SidebarDetailsId).int_OrganizationId) && pstmt.vcr_MetaKey=="Publish Date"
select pstmt.vcr_MetaValue).ToList();
int DatesCount = PublishDatePostMeta.Count();
foreach (string PublishDate in PublishDatePostMeta)
{
if (PublishDate != "")
{
NewsFillter += System.DateTime.Now + ">=" + Convert.ToDateTime(PublishDate);
}
}
var postsidebar = from post in postrepository.GetAllPosts()
join pstmt in postrepository.GetAllPostMetas()
on post.int_PostId equals pstmt.int_PostId
where (post.int_PostTypeId == 4 && post.int_PostStatusId == 2 && post.int_OrganizationId == layoutrep.GetSidebarDetailById(SidebarDetailsId).int_OrganizationId)
&& (pstmt.vcr_MetaKey.Contains(filter) && pstmt.vcr_MetaValue.Contains("true"))
select post;
The thing is that how NewsFillter would be accomdated in the postsidebar query in the pstmt object after true ( i would be putting it in contains,equals join or what). is there any way that a chunk (between &&s) return enumerable and i can get away with this. at this moment it is not allowing that
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?
How can I remove the html content and add new string to the Response object. If I use the Respose.Write method the page contains the string, but while taking the view source option from browser it will display some html tag like Doctype, head, body etc. My requirement is only the string should be displayed in the source.
View 2 RepliesHow can I remove the inherited properties?
View 2 Replies
