How to move and copy data from one table to another table

Question

1.I want to move all data from old table to new table like cut and paste.
2.Then want to move some data(when i click check box particular row in front end)from old to new table like copy paste.

Any body give example in asp.net c#.i need code behind format.(MSSQL queries)