insertion of records automatically in database using scheduler

Question

how is it possible to insert records automatically in database when due date expired using timer ? i want insert records in MS Access database using VB.NET.... actually i want insertion of records of hostelers in due Charges table who did not paid the fees at due date... i want something like if any hosteler due date expired on 15 /oct/ 2013 then record should be automatically inserted in due charges table....

i tried timer_tick event but it was inserting so many duplicate records how can i use scheduler in vb.net ?

So you had the right general idea and didn't get all the details correct? — Dan Bracuk, Oct 06 '13 at 03:30
can u suggest me some ideas how is it possible using sql query ? — Rahul Sharma, Oct 06 '13 at 03:32

score 2 · Accepted Answer · answered Oct 06 '13 at 07:44

2

how can i use scheduler in vb.net ?

There is some sample code available here. It is a C# example, but it should give you some idea of how you might manipulate Scheduled Tasks from a VB.NET app.

answered Oct 06 '13 at 07:44

Gord Thompson

116,920
32
215
418

tnX...it is really useful – Rahul Sharma Oct 10 '13 at 14:18

insertion of records automatically in database using scheduler

1 Answers1