Get No. Of Days From TextBox

Question

in my databasae table i have to coloumn one coloumn for issueDate and one for leaveDate i get issueDate and LeaveDate from database and show them in textbox But the problem is i want to get on no of days for example issue date =12/12/2014 leave date=12/10/2012 reamin=12-10=2 i want this kindly tell me how i can get only only days from textbox and calculate there difference??????????

Bhushan Gawale · Answer

If your application is going to be deployed worldwide and supports the localization - it might be possible that the users are entering dates in the textbox according to their cultures and hence the server code which parses the date might throw an exception. In such cases - it is highly recommended that you should always try to read the values in the UTC date time format and pass it as string to the server, which then parses the UTC string to give you DateTime object. Read more info about converting date time to UTC here - http://praveenlobo.com/techblog/how-to-convert-javascript-local-date-to-utc-and-utc-to-local-date/ The server code should look something like this DateTime dateTime = DateTime.Parse(utcDateString,CultureInfo.InvariantCulture, DateTimeStyles.AdjustToUniversal); Now about calculating the date difference - Its better to use the Linq providers like this int diffDays = System.Data.Linq.SqlClient.SqlMethods.DateDiffDay(date1, date2);

Md. Raskinur Rashid · Answer

i think this solution is perfect for you- DateTime issuedate = DateTime.Parse("12/12/2014"); DateTime leavedate = DateTime.Parse("12/10/2012"); int issuedate_Day = (int)issuedate.Day; int leavedate_Day = (int)leavedate.Day; Console.Write(Math.Abs("remain = "issuedate_Day - leavedate_Day)); Console.Read();

Vulpes · Answer

If you want to get the difference between those two dates in days on, say, a button click and display the result in a third textbox, then the following code should work: private void btnCalculate_Click(object sender, EventArgs e) { if (txtIssue.Text.Length == 0 || txtLeave.Text.Length == 0) { MessageBox.Show("Both textboxes must be populated first"); return; } DateTime issueDate = DateTime.Parse(txtIssue.Text); DateTime leaveDate = DateTime.Parse(txtLeave.Text); int days = (int)(leaveDate - issueDate).TotalDays; txtDays.Text = days.ToString(); }