Get No. Of Days From TextBox

umair shahid

11y1.6kWindows Forms

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??????????

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Bhushan Gawale11y ago
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 Rashid11y ago
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();
Vulpes11y ago
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();
}