Change database datetime column value in tmrTimer_Tick event

Dawood Abbas

In my application two forms are have i.e, 'Customer_Registration' and 'Customer_Search', so whenever iam registering the form aftre that have to show me that record into 'Customer_search' with 'Active' status if whatever 'expirydate' will be. In 'customer_search i am binding gridview on the column name and with its value base search.

so after one day status will change automatic 'active' to 'AutoHold' if expirydate is passed. mean daily it have to check auto.

So if I use 'Timer Control' then how to check my table col values and bind it to gridview?

2 Replies

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

Azaad Abbas11y ago
can we do this job in sql job schedular?
Deepak Saini11y ago
Dear Dawood,

you make another page to edit your database content,set the timer on this page and this page run on spacific time on your browser. edit your bulk status on bases expirydate.

when the customer serach than they can't be pick on this entry.

i hope you will get right data.