Change database datetime column value in tmrTimer_Tick event

Question

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?

Answer 1

Hi Chetan,

 

Please see the below links.

 

https://pauliom.com/2009/04/30/how-to-remove-items-from-a-bound-list-box-or-how-to-avoid-operation-not-supported-on-read-only-collection/