i have a simple payroll application written in visual basic 2010 express. i have created a database (called db.mdf) within this IDE. The type of database is Microsoft SQL Server Database File (SqlClient). the data is displayed in form by the help of a data grid view.
now my challenge is: at the end of the month the main table with all his content ( id, name, nr of worked hours) should be cloned and renamed with the name of current month.
i have been searched the web for 2 weeks and i didn`t find a workable way.