I have a date/time stored in a smalldatetime field (ms sql 2005) that i want to compare with the current time and receive a difference. If the difference is less than 30 minutes, do this....if more do that....
View 1 Replies
This is the sqlDateTime overflow problem again. Background. As I'm sure you know dates must be between 1/1/1753 and 12/31/2999. If you have an empty date field, it throws and exception. So I created a function (below) that solve the problem when attempting to update or insert a record with a date field. Works great.
Public Shared Function MakeDateField(ByVal pasDate As String) As Nullable(Of DateTime)
If IsDate(pasDate) Then
Try
If pasDate <= System.DateTime.MinValue Then
Return Nothing
Else
Return CType(pasDate, DateTime)
End If
Catch ex As NullReferenceException
Return Nothing
End Try
Else
Return Nothing
End If
End Function
So I thought about using a time field. I have the field, have the validator in place and then attempted to test the page. It resulted in my least favorite error message "sqlDateTime overflow".
I can think of several workarounds like adding a date or a fixed date to the time field, or converting it to a string. Each of these is problematic.
IS THERE A BETTER WAY TO UPDATE/INSERT TIME FIELDS.
I need to do to the following:
Find if the current time falls within hourly ranges and display the start hour and end hour of that range in labels.
Examples:
If the current time is 8:46am, label startTime would return "8am" and label endTime would return "9am"
If the current time is 10:01pm, label startTime returns "10pm" and label endTime returns "11pm"
If the current time is 12:59am, label startTime returns "12am" and label endTime returns "1am"
I have been working with the C# TimeRange class but not getting what I need.
I am trying to create an app which shows current time in 6 time zones (Sydney, S'pore, india, london, EST and CST).
I am having troubles handling DST, because DST starts and ends on different dates in different countries.
More over I want to make it configurable (add/remove cities from the list).
Currently I have added the cities in .config with their timezone differences (with respect to GMT).
[code]....
I've pulling back an entity object from a database and I need to update the date to the DB server's date/time - usually you could accomplish this by setting it with the SQL getDate() function.
How can I accomplish this in the following scenario:
var client = context.client.Where(c=>c.clientID == 1).FirstOrDefault();
// the value needs to be the value of the server's current date, i.e, getDate()... not DateTime.Now
client.someDate = <somevalue>;
context.SaveChanges();
I was wondering if anyone knows of a good login stored procedure that can be freely used and features login limits and so on (basically a good one) With my limited SP knowledge, I've tried to create one myself, I haven't completed it yet as I'm not sure on how to compare the last login attempt time against the current time (it's in the comments).
P.S. I had to write this in notepad.
[Code]....
How to get the current date and time in textbox in IST ( Indian Standard Time) in vb.net ?
View 1 RepliesI have an asp.net control textbox, clicking on which a jquery timepicker appears and user can select any time.But I want to validate the selected time so that it is one hour greater than the current time in the client side. I mean when textbox value will be changed it should be validated.
View 1 Replieshow to suppress the "AM" in the gridview (template Bind("RideTimeMin", "{0:t}")? Don't tell me to use military time because the function is not "time on a clock"; it's how much time is allowed for a task (in this case the min/max hours & minutes that horses have to complete a 20 mile trail; e.g. 05:00, 05:27, etc). I'm currently accomplishing this in the "ondatabound" function by "..RTmin.Replace("AM","")". I have looked and looked at all the websites that talk about datetime formatting but have yet to find a way to do it upfront in the gridview bind statement.
View 6 RepliesIn my asp.net application I user Microsoft Membership to manage site access security and find the time saved into LastLoginDate is ahead of local time (Eastern Time Zone) 3 hours. What is wrong with it and how to ajust it to local time by application system only such as changing some properties od application?
View 2 RepliesI'm trying to set the "time" value stored in a date time field, in other words, I want to change the value
05-13-2010 08.47.34
to
05-13-2010 00.00.00
or
05-13-2010 23.59.59
What statement would I use to accomplish this?
I need to do an update a field in database every x minutes. ie: a person login and I need to update a field related to they every X minutes until the value reach a value. Like this, this person start a count event from 1 to 10, they log off the web, but this count must remain countting until reachs 10, 1 by 1 every 7 minutes. I cannot do a SQL Job. Should I User a System.Timer??? Should I record the time and value of the last update, when the person log in I cauculate and update the value??
View 4 RepliesMy problem is that I have a grid view that show the data from database.In my gridview i add a column name date .like eg You knw that when we send a scrap to anyone then show time how much time to send a scrap.
View 6 RepliesI have a gridview on my page. I have a checkbox in each row of this gridview. For each checkbox in the gridview, I'd like to update my table accordingly, but I don't want them to have to hit a submit button every time they check the checkbox. I want them to check all the boxes they need to and at the end, they should hit one submit button.
View 12 RepliesI have 2 fields being displayed in a Gridview, StartTime, EndTime. I want to create a 'Time" column which shows the elapsed time in HH:MM format. (StartTime - EndTime) This was all generated with VS2008, table is pulled from an SQL Query.
View 1 RepliesI hav a gridview in which i display the project name,created date,Start time ,end time ,total hours along with the task id field which is visible=false.
My starttime and endtime format is 2010-10-13 03:00:00,but i want to display these two fields in dropdownlist ie.,only i want to display the HH:MM:SS in dropdown so that when the user changes the time it should be automatically be reflected in the total hours(6:0) field after updating.pls tell me what i have to do to bring the Hours ,minutes and seconds in dropdownlist into the cells of gridview with the value in database ,how to write the code.
i am using C# and VS 2008. how can i compare my datagrid column with current system date/time with current system date.
let us say current value in Date1 column is: Tuesday, February 16, 2010
foreach (GridViewRow r in GridView1.Rows)
select distinct tbl.emp_code, b.EmplName, convert(varchar, tbl.punched_date,101) as Punched_date,
(select convert(varchar(8),itbl.PUNCHED_TIME, 114)+', '
from Trn_Capture_Data_New itbl
where itbl.EMP_CODE=tbl.emp_code and itbl.PUNCHED_DATE=tbl.punched_date and itbl.EMP_CODE='4'
and tbl.punched_date >= '03/27/2013' and tbl.punched_date <= '03/28/2013'
for xml path('')) Punched_Time
[Code] ....
I have the above query and that gives me result
Emp_code EmplName Punched_date Punched_Time
4 XXX 3/27/2013 14:22:00, 09:44:00, 10:38:00, 11:01:00, 16:12:00, 18:25:00,
4 XXX 3/28/2013 13:14:00, 09:49:00, 18:02:00,
Now i need to Bind it to gridview, the gridview columns should be
Date,IN,OUT,IN,OUT
In punched time the first one should be IN and second OUT. A employee would have punched several time a day. Based on that I should take maximum punches and bring that of columns as IN and OUT in gridvew dynamically. How to achieve this?
My work is done properly all good with this query
View 1 RepliesI have created a web form where users input there details and submit it to an acess database. I also want the current data and time of there submition to be stored into the database along with the other information. I was thinking about making the time and data displaying in a lable or textbox and submit the the values within them into the database. I have been looking around the internt on how to do this but I couldn't get any of the examples I have tried working. Is there another way to create this funnctionality.
View 5 RepliesI have a gridview, which on the row data bound method that inserts a row when comparing values on a particular field. If the two values are different, a new row is inserted, if not no row is inserted. This coding is working as a grouping gridview, and is working correctly. However, I have problem, and problem is counting the rows between each group, which I want to display in my blank row between each group, the value of which I am holding in a hiddenfield.
When I try to do it, the first group doesn't show the result, but is displayed on the next group. I am pretty sure that I am doing something wrong. My approach is that if the value between the last row and the existing row are different, then the value is one, on the next row data bound event, if the values are the same then the value is increased by one, else the value is one because it is a new group. Here is my code:
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
Table tbl = e.Row.Parent as Table;
TableCell cell = new TableCell();
CheckBox chk = new CheckBox();
Label lbl2 = new Label();
HiddenField rowValue = new HiddenField();
if (e.Row.RowType == DataControlRowType.Header)
{
e.Row.Visible = false;
}
else
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
Session["count"] = 1;
Label lbl = (Label)e.Row.FindControl("lblValue");
string str1 = ((Label)(lbl)).Text;
string prevStr= (string)Session["previousStr"];
if (prevStr== str1)
{
lbl.Visible = false;...................
My web application has hosted on the canada server but my all clients are indians.So, as I am using System.datetime.Now to store all the dates in application.Obviously, it is displaying the canadian time instead of india time.How can i do it?Is there not any gloabl settings that we can do in our web.config file so that it indicates to the server at run time which time zone to execute..?Or any other suitable alternate?
View 3 RepliesHere what i am trying to accomplish. I want to have a div or panel on the page and have some text on it. The div or panel must hava a specfied time limit and then disaaper from the page. Say i want this text to apper on 10Cotober 10.00 and disapper from the page on 11October 18.00.
View 1 RepliesI have a column in a table within an SQL database that is defined as a time variable. How do I obtain the current time formatted for insertion into that table's column using C#?
View 6 RepliesHow can I update a table with current date and time using sqldatasource control?
View 2 Replies
