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 check the link

http://www.aspsnippets.com/Articles/Create-and-Drop-SQL-Server-Table-programmatically-using-ADONet-C-and-VBNet.aspx

For insert record in table

http://www.aspsnippets.com/Articles/Using-SqlBulkCopy-to-import-Excel-SpreadSheet-data-into-SQL-Server-in-ASPNet-using-C-and-VBNet.aspx

Answer 2

Hi,

Its just the idea, try to use the import functionality of SQL server.

Hope it helps.

Thanks.