How to calculate age using DOB

Bhavesh Vankar

SqlConnection con = new SqlConnection(this.con);
SqlCommand cmd = new SqlCommand("Select DATEDIFF(YEAR,CONVERT(datetime,'"+ txtDob.Text +"',103),CONVERT(datetime,V_ISSUEDATE,103)) FROM MASTER_NEW", con);
SqlDataReader reader = cmd.ExecuteReader();

how to calculate age using DOB.

When user enter DOB in format dd/MM/yyyy in textbox1 than the age should be display in textbox2 using code behind.

i have tryed to do this with using sql query to take server date as current date.

but what to do next no getting idea...

8 Replies

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

Bhavesh Vankar5y ago
i have done it as below...
and its working using textbox lost focus event...
String birthdate = txtbod.Text;
SqlConnection con = new SqlConnection(this.con);

            SqlCommand cmd = new SqlCommand("Select DATEDIFF(YEAR,CONVERT(datetime,'" + birthdate + "',103),CONVERT(datetime,V_ISSUEDATE,103)) FROM MASTER_TABLE", con);
            con.Open();
            string year = Convert.ToString(cmd.ExecuteScalar());
            con.Close();
            txtage.Text = year;
+2
Sachin Singh5y ago
your rdr[o] is returning an int, so you can't use getstring() method on that instead use this
while (reader.Read())
{
string val =Convert.ToString( rdr.GetInt32(0));
txtAge.text=val;
}
+2
Arnab Mukherjee5y ago
1. while (reader.Read())
2. {
3. string val = reader[0].ToString();
4. }
+2

Arnab Mukherjee5y ago

Hi Bhavesh, please try the below code to get the value from SqlDataReader

while (reader.Read())
{
string val = rdr.GetString(0);
txtAge.text=val;
}

Bhavesh Vankar5y ago

hot to assign age to textbox2 when user enter dob than should be display age in textbox2 when user lost focus from textbox1 after entered dob.

Rijwan Ansari5y ago

You can try this way

var dtDob = Convert.ToDateTime(txtDob.Text);
SqlConnection con = new SqlConnection(this.con);
SqlCommand cmd = new SqlCommand("select DATEDIFF(YEAR, " + dtDob + ", SYSDATETIME())", con);
SqlDataReader reader = cmd.ExecuteReader();

You don't need to use any table. Simple input textbox date and SQL date SYSDATETIME().

Md Sarfaraj5y ago

https://stackoverflow.com/questions/1572110/how-to-calculate-age-in-years-based-on-date-of-birth-and-getdate

Check this one

Farhan Ahmed5y ago

https://www.aspforums.net/Threads/476413/Calculate-Age-from-given-number-In-TextBox-ASPNet-C-and-VBNet/