HI
I have House_info table in my database
House_info
expiredate
|
date
|
name
|
Id
|
2013-03-04
|
2012-03-04
|
sara
|
1
|
2013-01-25
|
2012-01-25
|
jack
|
2
|
2013-03-04
|
2012-03-04
|
micheal
|
3
|
and 1 lable=LblExpire in admin.aspx page that I want bind it from database
In house_info table are 2 column 1-date 2-expire date
I want 1 week before Expire date in LblExpire in admin.aspx Page show Count of users that after 1 week thier users account will be expire
i.e
here users sara & micheal =ExpireDate are==2013-03-4
I want in 2013-02-27 in lblExpire in admin.aspx page show number (2)
that means 2 users exist that after 1 week their account will expire?
what should I do?
how I can write SP?
thanks alot