Duplicate existing table in vb.net

Question

0.00/5 (No votes)

See more:

hello

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.

Posted 2-Jul-10 4:40am

pacomarshavu

Add a Solution

2 solutions

Solution 2

sounds good. create another column to host the year and month at the edge of curent table.

but if i will do like this i think it would be dificult to create reports with report viwer control.

Posted 2-Jul-10 7:08am

pacomarshavu

Comments

tiggerc 3-Jul-10 13:15pm

Should be relatively simple, you could just store the entry date in the last field using getdate(), then using a query like this

SELECT * FROM TBL_ACCOUNTS
WHERE ENTRY_DATE BETWEEN CDATE('01-06-2009') AND CDATE('30-06-2009') ORDER BY ENTRY_DATE

that may work it does for me anyway, but i use SQL Server

R. Giskard Reventlov 4-Jul-10 4:39am

Don't respond with an answer; use comments to reply to posts.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**R. Giskard Reventlov** · Accepted Answer · 2010-07-02T04:48:00

Why don't you create a single secondary table that contains the data form all previous months rather than creating an endless series of identical tables. That way you can insert the month data into the archive data table which will have one extra identifying field (perhaps year/month like 201007, 201008 etc) and then delete those records from the main table.