How to find age from Access Database in C# WindowsApplicatio

Question

Hi all,

 

Greetings of the day...

 

I have a windows form (C#) and access database. in the database i have details of employees and there is one text field that contains date of birth. when i fetch record from the database, how can i display the age (years only. e.g. 25 Years or 35 Years) in a text box?

 

i have googled enough and there so many options but not the answer. please note that i want to get the answer (the age) based on date from database minus todays year.

 

please see the code below...

 

private void txtEmpNo_Validated(object sender, EventArgs e)
{ 

 OleDbDataAdapter SearchEmp = new OleDbDataAdapter("Select EmpFullName, EmpDOB, EmpSex, EmpMobileNumber, EmpCity From Employee Where EmpIDNo='" + txtCaseNo.Text + "'", MyConn);

DataSet dsSearchEmp = new DataSet();
SearchEmp.Fill(dsSearchEmp);

if (dsSearchEmp.Tables[0].Rows.Count > 0)
{

   //How to calculate? i have tryed with int, string, datetime, timespan etc.

   txtEmpAge.text = //What code?

}

}

 

please help.

 

thank you

 

Mayank Jani

Answer 1

Try like below

 

// Fetch the dob from the dataset
var dob = Convert.ToDateTime(dsSearchEmp.Tables[0].Rows[0]["EmpDob"]);

var yOld = DateTime.Now.Year - dob.Year;

 

 

Answer 2

Hey Amit,

 

it's done. i've done some mistake like an idot. 

 

thank you dear.

 

Mayank Jani

Answer 3

in Access database > Field Name - EmpDOB.  > Field Type - Text.

you can take any value like 15/05/1995.

Answer 4

Can you share the value of Empdob and dob?

Answer 5

Hi Amit,

the updated code runs but every time it shows 0 years.

Answer 6

Hey Mayank, I had updated my answer. Doesn't it work? Have you tried?

Answer 7

Nah... please note that i want to get the answer (the age) based on date from database (a date and after extract the birth year) minus todays year. or something else that does exact this as result.

Answer 8

You can try this...

 

DateTime from = Convert.ToDateTime("01-01-2001");

DateTime to = Convert.ToDateTime("01-01-2009");

Console.Write((((to-from).TotalDays)/12)/30);

 

Answer 9

Hey Amit, nice to see you again...

 

an error says, 'The as operator must be used with a reference type or nullable type ('System.DateTime' is a non-nullable value type)'

thanks for reply.

 

Mayank Jani