hi ranjit
You try like this i am, showing in 2tier format for just understanding purpose,
bring Expiry date from Database
ex:
Select Max(ExpiryDate) from TABLE where Username='"+txtusername+"' and Password='"+txtpassword+"'
cn.Open();
Datetime ExpDate;
dr = cmd.ExecuteReader();
if (dr.Read() == true)
{
ExpDate=convert.todatetime( dr[0].ToString());
}
cn.Close();
if(ExpDate<datetime.now.year)>
{
}
else
{
}
i hope this will helps you
Thanks&&Regards
Sandeep